ReadMeFeed / Community knowledge
Models, data engineering, retrieval, analytics and databases.
I wanted to edit the actions in a table. However I get the error message "Please specify covering index name." when I try to edit the FK. How do I fix this? The table consists of only two columns: The foreign keys: category FK:
Since I have moved to the new Apple Silicon architecture my docker setup with nextjs and postgres is not working anymore. The database inside the docker cannot be found by the nextjs server where I am using prisma. The prisma client can't reach the postgres database on port 5432. Can't reach database server at test-postgres : 5432 The migration also does not
Compare suitability, operational responsibilities and limits before choosing this technology for a project. Which trade-offs should guide the decision?
Recovery needs to recreate the working service and its required data after a machine or process is lost. Which artifacts and state need protection, and how should the restore be checked?
I know that UUIDs and incrementing integers are often used for primary keys. I'm thinking of nanoids instead because those are URL friendly without being guessable / brute-force scrapeable (like incrementing integers). Would there be any reason not to use nanoids as primary keys in a database like Postgres? (For example: Maybe they drastically increase query
I'm running a complex stored procedure and I'm getting an error when I have 3 unions, but with 2 unions no error. If I remove either of the top two unions it runs fine. If I make one of the NULLs a 0, it runs fine. The error is "UNION types text and bigint cannot be matched" ```lang-sql SELECT NULL AS total_time_spent FROM tbl1 GROUP BY student_id UNION ALL
An upgrade needs a compatibility check, a tested release and a recovery path. Which changes deserve particular attention before the new version reaches production?
I've had a million and one issues with Poetry recently. I got it fully installed and working yesterday, but after a restart of my machine I'm back to having issues with it ;( Is there anyway to have Poetry consistently recognised in my Terminal, even after reboot? System Specs: Windows 10, Visual Studio Code, Bash - WSL Ubuntu CLI, Python 3.8. Terminal: me@P
I am trying to install a library from the source that makes use of Poetry, but I get this error error: Multiple top-level packages discovered in a flat-layout: ['tulips', 'fixtures']. To avoid accidental inclusion of unwanted files or directories, setuptools will not proceed with this build. If you are trying to create a single distribution with multiple pac
postgresql
docker
prisma
pandas
numpy
python