sensus | A Cross-Platform System for Mobile | iOS library

I am working on a system that writes text logs to a text column in PostgreSQL 12. I want to perform a simple search on a keyword (this part's easy!), but then I want to extract only a section of the text content that appears proximate to the located search keyword (to provide context).

The logs contain lines separated by carriage returns. Say I want to search for the keyword "exception" and bring back each line in the text column that contains the keyword. Or, maybe I want to return the line with the keyword as well as the line before and the line afterwards.

Is this possible using PostgreSQL query features alone? Or will I need to write other custom code to extract just the lines I'm interested in. (BTW, I don't currently use the tsvector feature.)

Any help would be greatly appreciated. Thanks!

[Edited to provide additional details.]

Say I have a table called LOG_RECORDS that contains a TEXT column called LOG_CONTENT. One particular row of this table contain the following in LOG_CONTENT:

I have an application that is already deployed and working in production however this was all done by someone else. I am now attempting to make a local version of the environment and I can't seem to get my local Celery/RabbitMQ to actually run the task.

The application is very large, so i won't attempt to post it all here but i have a few clues from my debugging that may be useful. One is this. When i run the following functions:

I have docker-compose file, where I have specified volumes:

I have sensus data that I need to pull together from a large number of workbooks. As I don't intend to read all of them to check for possible wrongfully entered data I plan on highlighting cells that don't adhere to a determined datatype.

To do so I created a list that has the expected datatype for each row. For example they can be: Long, String or Decimal.

I know there exists this schema for detecting datatypes with a UDF, which is found all over the internet:

I'have got web crawling from other website and i'have got data what i need. Now i want to store it in my own database. How to do it?

here what the data i'have got data from other website i'have got

On css I want to add a rule for a selfclosed tag like this: (exacly convert content to one symbol)

I already do it to add a different style for simple open-close tag lorem ipsum (I want to convert open tag and closed tag to a symbol so enclose a phrase inside symbols)

In css:

So I have a simple little page with a popout sidebar.

When you click the menu icon (the 3 bars), it uses transitions to make the potato and menu icon move/change.

When the navigation bar is opened, the transitions work fine in all browsers, but when closed, all the transitions work fine in all browsers, except in Firefox, where the 3 bars are not animated and just jump back.

I'd like to provide more info, but I really have no idea what else to say.