All Questions
Tagged with database-recommendation postgresql
14 questions
0
votes
1
answer
85
views
Database Design for a Furniture Store E-commerce Site
I'm building my first web project: a modular furniture e-commerce platform using Next.js and PostgreSQL.
I’ve designed a normalized relational schema to handle:
Categories and subcategories
Furniture ...
- 9
3
votes
2
answers
3k
views
Choosing the right database for stock price history
The model is [(stock_id, period, ts), open, high, low, close, last, volume]
We write new prices for all stocks (120,000) each minute and delete old once when they go out of retention time. It doesn't ...
- 173
1
vote
3
answers
2k
views
How to store real-time data to database [closed]
Here is my situation:
I have a WebSocket connection that feeds me data real-time
I have an async callback function that gets the data and inserts into a queue
I have another thread that reads from ...
- 111
3
votes
3
answers
10k
views
What is the difference between views and materialized views
What is the difference between PostgreSQL's materialized views and MySQL's views?
- 309
4
votes
1
answer
2k
views
Optimal database for large number of columns or rows
Problem 1:
I have one file with 567 rows and 16,382 columns, most of which are floating point numbers. I have another file with 117,493 rows but only 3 columns. The contents deal with biology and ...
- 289
1
vote
1
answer
2k
views
Data structure design for supporting arbitrary number of columns in table or database [closed]
I am currently working on a sort-of a meta-modeler to build a free web service so that people can input data and run several models on that data.
The task I am currently struggling is: user needs to ...
1
vote
1
answer
155
views
What kind of database should I use?
I'm designing a new system and I'm wondering what kind of DB should I use for my needs.
I have a tree structure of nodes, where each node has historic values. For each historic value it should hold 2 ...
- 239
2
votes
0
answers
91
views
How to implement search for world-wide Wikipedia/OSM places with alternative-names
I would like to implement a search-backend which returns a location-aware search results of all Wikipedia / OSM place names, while recognising place names in all languages.
Thus, if you search for "...
- 121
9
votes
1
answer
3k
views
Managing and speeding up queries on PostgreSQL table with over 3 trillion rows
I have time series data which spans over 10 years and has over 3 trillion rows and 10 columns.
At the moment I use a PCIe SSD with 128GB of RAM and I am finding that querying takes a significant ...
- 381
1
vote
3
answers
2k
views
Mass data upload from Excel - technology
I am a Developer seeking help in terms of DB technology for a specific requirement. I have done some research but can not conclude with list.
Requirement:
There will be a web application which will ...
- 11
2
votes
1
answer
7k
views
Best Approach to storing chat history?
I'm building a chat application (Yes, another one :P) and am really curious about the best way to store a chat's history(String username, String Message, Time, and possibly string channel depending on ...
- 121
0
votes
1
answer
124
views
Is PostgreSQL appropriate for processing this large but simple dataset? [closed]
I have a dataset I'm not sure how to store. The structure is simple: 30 numeric attributes identified by about 15 billion x, y, and t values. We're expecting ~17k t values and maybe 90k x/y ...
- 133
2
votes
1
answer
273
views
Which database to use? [closed]
Hey there. I am looking for a free to use for commercial website database that should have these design features, in the given order:
Auto-Sharding (getting more free space by adding more server nodes)...
- 31
3
votes
1
answer
398
views
Postgres synchronized backup - what's with the archive?
I am setting up a Postgres 9.1 master and a hot standby-server. I read the documentation but I'm not quite sure yet what I should do with my WAL files.
Every commit is done on both servers before ...
- 577