All Questions
79
questions
1
vote
2
answers
2k
views
The best choice for database for large datasets [closed]
I'm about to start a new project which should have a rather large database.
the records have roughly up to 10 fields , these datas will have following specifications :
Only insert and read records ...
0
votes
1
answer
84
views
Query free booking based on time window and duration from MONGODB
I have the following problem for which I am looking for a solution.
I have a table in my database with the following structure:
id
Date
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
1
2022-02-01
0
...
1
vote
0
answers
89
views
Equivalent query from mysql to mongodb
JOIN t2 ON t1.id=t2.id AND t1.date=t2.date
I am new to mongodb and I didn’t find a query to join two collections where I need to compare two fields from both collections.
3
votes
2
answers
2k
views
Why do NoSql databases scale better than relational databases? How should I choose between them?
By nosql databases I mean something like mongodb or dynamodb
I've been trying to find why NoSql dbs usually are usually better at horizontal scaling than relational dbs, and how to choose between them
...
0
votes
2
answers
59
views
SQL Sort by multiple columns of a different table
I have two tables:
The first one having the columns:
|Name | Company | Job|
with values such as
(jack apple developer),
(Julian google developer),
(Jim eBay developer),
(jack apple janitor),
(Julian ...
1
vote
1
answer
1k
views
replication from mongodb atlas to on premise?
I want this functionality - https://docs.mongodb.com/manual/replication/ - except that my primary will be a node in mongodb atlas on awas and some of my secondaries will also be in atlas aws, but I ...
0
votes
2
answers
609
views
What’s the best way to handle an 'very large' inventory with SQL? [closed]
I am looking into building an online card game like that of Hearthstone. Players will have an unlimited inventory to store all the cards they own.
With this method there would be a very large their ...
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
75
views
What's the best approach to showcase benefits from SQL - NoSQL environment?
I was asked to create a little environment showcasing benefits from using NoSQL - SQL hybrid over only SQL database. Since my background is mostly Admin/DevOps I have basic knowledge about databases, ...
0
votes
1
answer
416
views
What is faster to insert, update or delete MongoDB or SQL?
I am deciding between using MongoDB and MySQL for my next application. I'll use Elasticsearch for search queries so I don't care about this.
So in these 3 operations: insert, update and delete. Which ...
1
vote
2
answers
2k
views
Correct DB design to store huge amount of stock cryptocurrencies data in DB
I want to store large amount of cryptocurrencies data in db. Then I want to show nice javascript price graphs with historical prices on webpage.
Problem is that I am not sure what database design is ...
0
votes
1
answer
561
views
Realization of BFS in relational databases
I need to use a structure of ternary tree which has to be stored somewhere (I chose relational DB, but I still can change it).
My DB tree looks like:
For example my relation contains columns - Id, ...
0
votes
0
answers
33
views
Optimise MySQL for regex queries or better DMBS for faster regex queries?
I'm currently using a MySQL Database with only one table where I'm searching for products with a regular expression. The table has the following columns: id, title, date and description. I'm looking ...
7
votes
3
answers
2k
views
Suitability of AWS Cognito Identity ID for SQL primary key
I am working on a platform where unique user ID's are Identity ID's from a Amazon Cognito identity pool. Which look like so: "us-east-1:128d0a74-c82f-4553-916d-90053e4a8b0f"
The platform has a MySQL ...
1
vote
1
answer
527
views
Offline first app using SQL
I'm working on Offline first app. I have tried working on PouchDB-CouchDB but they doesn't go easy for me. Is there any middleware or something using which i can sync server SQL database to local SQL ...