Questions tagged [database-recommendation]

Determining what database product best fits the requirements and limitations in a specific situation. This is advice that generally requires much more insight into requirements than can easily be gleaned on a Q&A forum such as StackExchange.

If you are seriously evaluating databases for a project then the evaluation is likely to be affected or even constrained by a range of factors. These could range from feature requirements to corporate policies mandating the use of certain platforms. Feasibility studies for this can be quite in-depth pieces of research in their own right.

Asking questions of the form 'what database should I use for xxx' is unlikely to produce a useful answer unless you can be quite specific about requirements. Specifying these in a useful level of detail can produce quite substantial documents.

You are much more likely to get a useful response if you can do some preliminary research based on the capabilities you are looking for, and then use Q&A forums to get specific clarifications on individual points.

327 questions
18
votes
2 answers

Which DBMS is good for super-fast reads and a simple data structure?

I am developing a product that, as a part of it's operation, must track a large number of files/directories. The idea is to store stat information in a database then, on boot, create watches for each file. Files that change will be queued (in the…
beatgammit
  • 283
  • 1
  • 2
  • 9
9
votes
1 answer

What are the advantages and disadvantages of Firebase for a database?

I am currently developing a site to track credits gained from exams, and how these stack up against the user's goal credits. I am looking for a database system that will store all the possible exams someone could take in NCEA (New Zealand's…
user51166
8
votes
2 answers

A database for digital assets

I work at a print shop that has a decent sized archive of old print jobs. Currently, to find a job we have to search the SMB share (on win2000 server), which looks through a few hundred thousand files. Our job data is organized by:…
7
votes
6 answers

Best database to store and retrieve Word and Excel documents

My current project is to create a barcode system (for lack of a better word) that is linked to a database (was not given more information or directions). My task is to have a barcode scanner interpret a barcode, query a database that stores MS Word…
Gerasimos.Zap
  • 73
  • 1
  • 1
  • 7
5
votes
3 answers

Multi-database object-oriented proxy

Do you know if there is a system/product/technique which would allow to "wrap" one or more relational databases into one object-oriented virtual database (or could we call it a "multi-database object-oriented proxy")? Let me illustrate the…
Xoum
  • 153
  • 4
4
votes
2 answers

best db and file system for high volume, high qps

I'm looking at setting up a DB for a very high volume non-profit situation that also would benefit from high speed updates and searches. Each transaction record will be relatively small (basic customer information plus 10-12 extra fields) but must…
anon
  • 41
  • 2
4
votes
3 answers

Choosing relational DB for a small virtual server with 1Gb RAM

I am trying to find a decent relational database that would run on a small server, would be easy to administer and have much community love. I need a lightweight relational database for my personal Ubuntu server with only 1Gb of RAM. It would be…
3
votes
5 answers

Are there any in-memory hybrid databases available?

I am looking for a database that is - Relational (Not NoSQL). Has an in-memory store. Has disk-based backing storage. I want to set up a system where entire contents of the disk are replicated in memory. So writes are made to both the in-memory…
Kshitiz Sharma
  • 3,237
  • 9
  • 31
  • 35
3
votes
1 answer

Storage solution to run IoT analytics

I have several hundred IoT devices pushing data to my server every minute. The data is structured and it has following columns: Site ID (String) Event Start time (Date Time) Event End Time (Date Time) Data (String) Data once created, does not…
3
votes
2 answers

Update/fix or recreate old database

My employer is currently using a database build in Borland Visual dBase 5.5 that has been running on a Windows 95 machine for the last 20 years. I am trying to figure out my best course of action to bring this database into the 21st century, but my…
megruder79
  • 63
  • 1
  • 5
2
votes
4 answers

Is there a DBMS that allows the "= NULL" syntax?

Inspired by a StackOverflow question (Why doesn't SQL support "= null" instead of "is null"?). Is there a DBMS that actually supports the = NULL syntax?
Richard
  • 6,393
  • 8
  • 42
  • 62
2
votes
4 answers

Is there a Storage-Engine/DB that logs all changes and allows selective rollback of specific changes?

Is there a storage-engine or database that naturally support this use-case: 1) Key-Value storage. Small Fixed Length Key, and value within [1KB, 64KB] 2) Access is read-mostly 3) Latency more important than throughput. 4) Use discs for values; not a…
2
votes
2 answers

Small Cloud Database

I'm researching the best way to do the following but haven't been able to come up with anything. I'm trying to build a small (probably 3 or so tables with at most 200 records each) relational database that is hosted online. If it could be hosted…
Josh
  • 273
  • 2
  • 9
1
vote
2 answers

Appropriate database for web analytics?

I am working on the web analytics it is similar to google analytics, Currently i am using the mongoDB. Problem using MongoDB Writing and reading is performed at the same time so after some point writing is bit slow. So i am looking for appropriate…
karthick
  • 151
  • 2
  • 7
1
vote
1 answer

the best place for save binary file

Possible Duplicate: Files - in the database or not? anyone can tell me, what is the best place for save binary file? database or just in a file system? and what is plus and minus for both? :D actually, I want to save my image file, but I don't…
1
2 3