Databases

if the fucking database cant do that then how can i trust it?

Any schema recommendations To store chat messages one-one chat and group chat messages and also message status in surrealdb ?

I'm trying to implement chat in my app. I am using postgres How should I design my database schema and store the chats? Right now I made a table with Id Createdat Content ...

What does indexing actually do? I mean it's pro and cons. I know it make looking up records faster and there is the cost of the size of the DB.

In a SQL database. Are the primary keys indexed? If yes why do I need to index other columns?

in postgres if i have "id SERIAL PRIMARY KEY" and some other VARCHAR UNIQUE NOT NULL data. why does the id keep incrementing when i try to add some non unique piece of data. w...

The part that slightly confuses me is that I usually put the foreign_key in the table that is "owned" by the other table. In this relationship I would consider the User "owns"...

I'm working on an application that the server retrieves currency rates from a third-party-api and saves it in its database; for the purpose of real-time chart plotting. The ch...

For engineers who have worked on postgres read replicas, A particular query (eg: SELECT * FROM students WHERE subject_id = 266 LIMIT 50) runs fast on the primary.. but neve...

I have a question, because one of my columns does not take Chinese characters and from C# I send it to nvarchar and in sql I put an N'value', I want to improve that, what do y...

could it be that multiple COPY operations within one transaction can deadlock the connection?

db = hardware dbms = software abstractions to manage db Is my above hypothesis correct?

how would you model these 2 tables. User can have one Address. Address can be had by many Users. would you put the address_id in the Users table? Or use a pivot table and use...

Hey so is there a lightweight nosql db ??

hello, so i dont use this chat very much so not sure this is where my question belongs. But out of curiousity... this website (https://www.sql-practice.com/) amongst many othe...

Hello everyone, I was wondering if you have any recommendations regarding a Postgres development tool? The main points I would like the tool to have: * Ability to connect to...

Hello friends I want to do groupby based on city_name, but in such a way that the sum of columns A and B show the frequency of each city. If I want to explain better, it goes ...

I'm new to Mysql workbench. I've created a table with a primary key and on validation, the primary key hasn't been generated. Should I fill it in myself? Thank you for your an...

hi guys in postgres im trying to implement a pagination I need to query N rows before and after a specific ID my problem is implementing the "before" part I do "where id < X ...

Hi guys, I'm developing a Telegram bot who reads all the messages sent in a large ammount of group chats. For every message the bot receives, it querys a MongoDB database to ...