backup and restore
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...
Обсуждают сегодня