EDB | A framework to make and manage backups of your database | Database library

When running the below

I would like to extract Name, Address of School, Tel, Fax ,Head of School from the website: https://www.edb.gov.hk/en/student-parents/sch-info/sch-search/schlist-by-district/school-list-cw.html Is it possible to do so?

I am working on a query to return the next 7 days worth of data every time an event happens indicated by "where event = 1". The goal is to then group all the data by the user id and perform aggregate functions on this data after the event happens - the event is encoded as binary [0, 1].

So far, I have been attempting to use nested select statements to structure the data how I would like to have it, but using the window functions is starting to restrict me. I am now thinking a self join could be more appropriate but need help in constructing such a query.

The query currently first creates daily aggregate values grouped by user and date (3rd level nested select). Then, the 2nd level sums the data "value_x" to obtain an aggregate value grouped by the user. Then, the 1st level nested select statement uses the lead function to grab the next rows value over and partitioned by each user which acts as selecting the next day's value when event = 1. Lastly, the select statement uses an aggregate function to calculate the average "sum_next_day_value_after_event" grouped by user and where event = 1. Put together, where event = 1, the query returns the avg(value_x) of the next row's total value_x.

However, this doesn't follow my time rule; "where event = 1", return the next 7 days worth of data after the event happens. If there is not 7 days worth of data, then return whatever data is <= 7 days. Yes, I currently only have one lead with the offset as 1, but you could just put 6 more of these functions to grab the next 6 rows. But, the lead function currently just grabs the next row without regard to date. So theoretically, the next row's "value_x" could actually be 15 days from where "event = 1". Also, as can be seen below in the data table, a user may have more than one row per day.

Here is the following query I have so far:

I'm using docker-compose to containerize a flask API. The API connects to MongoDb to fetch data, so I included a link to it in the docker-compose.yml. Here is the docker-compose file:

I have this piece of code:

I am migrating from oracle sql to edb and wanted to convert the regular expression replace, but i am not able to bring all the constraints to the edb equivalent. Could you please help.

I am writing a query to pull a list of student enrollments, and creating a virtual column with logic to assign students with various academic plans to communication groups (comm_group). The source view I've been provided to work with pulls one record for EACH academic plan for a student with ANY enrollment in our department. As a result, there are records of enrollments that have nothing to do with our department, because OTHER enrollments that in our department exist. I could just filter out those rows, but I would like to double-check the logic in my virtual column by finding any students who have ALL null values in the comm_group column. That would indicate that I missed some plan codes somewhere. Here's some sample data:

User 3 has an enrollment in EDC, so should have a value for that column for COMM_GROUP for that row. This means I have left out EDC from my case statements in my virtual column. I would like to identify all such errors by selecting finding all users who ONLY have NULL values.

I'm almost there, but I'm missing something. My code looks like this right now:

We are setting up a virtual machine with Vagrant ( ubuntu/focal64 ) and we are using some shell scripts to handle Postgres 11 installation. What we want to achieve is initializing the default cluster with specific locale settings. The wanted behavior is similar to installing PostgreSQL on a Windows machine using the EDB installer and specifying the collation, encoding etc.. before installation. How can we do that ?