I have a large script that saves data to a postgres database. Tell me how can I get rid of [' and ']. I need the data in the storage to be saved without these characters total.to_csv("C:/Users/.../total_type19.csv", index = False,…
I have an table and I want to fill the null value with previous value order by date but there have an group too For example: Table X: Date Group value 1/1/2023 A null 2/1/2023 A Kevin 3/1/2023 A null…
I was trying to make a simple database to write and read from and on pretty much one of the first steps I encountered a problem: it would not connect. I got the error message: "No connection could be made…
I have two tables: TableA Id Status User 1 15 111 2 15 111 3 15 111 And TableB which contains history of status changes from previous table: Id IdA Status Date 1 1 10 2023-01-18 2 1 30 2022-12-18…
I am trying to find if search query contains result , if not then return null here is the code , but even the search is not present in DB it is showing previous search results if (!empty($searchInput)) { $complexityLevel->join('organizations',…
Stages of MongoDB aggregation pipeline are always executed sequentially. Can the documents that the pipeline processes be changed between the stages? E.g. if stage1 matches some docs from collection1 and stage2 matches some docs from collection2 can some documents from…
I need an non-superuser to create dbs and users, and assign this users to its respective DB, but this "start" user should not be able to delete other DBs or basically nothing more than create users and DBs. I have…
I created my first App, using Laravel in the Backend. Everything was running on my localhost and I deployed everything to my Netcup Webhosting Server. I run composer install successfully, generated the API key by using php artisan key:generate --ansi…
I want to delete 2 models from a postgreSQL production database that are no longer used but have data on them. I am a bit afraid of removing them from the schema and running prisma migrate dev and then having…
I’m new to Flutter. How can I retrieve user data from Firebase to my profile page? My Firebase data contains a name, email, blood type, and a date of birth. And I would like to retrieve this data to my…