All Questions
39
questions
1
vote
2
answers
61
views
What is the most suitable data type for a column in a table?
Currently I'm trying to develop a PostgreSQL database schema, it has only 2 tables, one of which contains usernames. The difficulty is that for certain reasons I cannot store the username directly, so ...
0
votes
1
answer
48
views
Create a table in postgress on jupyter results in syntax error?
I try to create a table in postgress in my jupyter lab!
but there comes this bug!
%%bash
cat <<"EOF" | sudo docker exec -i dbis-postgres-db-1 psql -U postgres
DROP DATABASE IF ...
1
vote
1
answer
135
views
How to get a table name inside a pg query with json?
I'm trying to get a json with a table name inside with a row, I've trying:
Create a table:
create table if not exists customer (
_id serial,
first_name varchar(50),
constraint pk_customer ...
0
votes
1
answer
46
views
How to optimize large database query accessed with an item ID?
I'm making a site that stores a large amount of data (8 data points for 313 item_ids every 10 seconds over 24 hr) and I serve that data to users on demand. The request is supplied with an item ID with ...
1
vote
0
answers
108
views
Proper Data model for stateful user forms using PostgreSQL
I'm building where much of the UI evolves from the user filling out and completing form wizards centered around a specific topic. I'm currently using PostgreSQL with Hasura GraphQL engine on the ...
3
votes
2
answers
454
views
PostgreSQL query on a JSONB Array of Objects
I've a PostgreSQL table with this complex structure :
"item": [{
"field10",
"field11",
"field12": {
"field20"
...
0
votes
1
answer
366
views
Write Conflict between two transactions [closed]
I am a noob in DBMS. I am developing a project which has multiple readers and writers.
Here are the steps of the project.
User Logins
Makes changes
Then clicks submit
Admins review the changes and ...
0
votes
0
answers
318
views
Advice about Designing SQL Database for catalog service for a marketplace
I'm currently designing catalog service (SQL database), and I'm trying to combine SQL and NoSQL to store data like for "Data field form item table".
Catalog service:
Item_type table allows ...
-1
votes
1
answer
162
views
NoSQL or SQL for Data Structure [closed]
I'm building an app, and this is my first time working with databases. I went with MongoDB because originally I thought my data structure would be fitting for it. After more research, I've become a ...
0
votes
2
answers
1k
views
Best way to periodically mirroring data from SQL to NoSQL?
I want to export updated data from MySQL/postgreSQL to mongodb every time specified table has changed or, if that's impossible, make the dump of whole table to NoSQL every X seconds/minutes. What can ...
0
votes
1
answer
2k
views
How to choose the right database for historic data storage for small company
I am working on creating a new database to store all the JSON file we accumulated historically (not much data, in the range of 10s of GB). We are a really small company and this database will be used ...
4
votes
1
answer
3k
views
Is a primary key query in a SQL database similar to a key query in a NoSQL one in terms of speed?
From my understanding, we can compare SQL vs NoSQL to array vs hashmap/dict.
(Let's consider PostgreSQL vs MongoDB just for a context)
SQL is arranged in tables and searches through the rows for ...
1
vote
1
answer
265
views
How many users can MongooseIM handle on the PostgreSQL backend?
I am working on MongooseIM server with PostgreSQL as backend. I need all the basic features like:
One to One chat with presence.
Group Chat (Muc light only)
MAM storage and all other basic features.
...
6
votes
1
answer
4k
views
Google Firestore (NoSQL) vs PostgreSQL (SQL) For Reactjs and React Native Apps
I just have a question about how to choose between using a noSQL database or sql database when creating a ReactJS or React Native app? For instance why would you choose to use Firestore over ...
0
votes
1
answer
40
views
Implement a many to many relation ships in postgresql
I have to implement a many to many relationships between table in postgresql.
The default SQL way to do this is to create :
data1
data2
relation1 (which is a virtual link between data1 and data2)
...