Tag Info

Hot answers tagged

10

A list can be found on Wikipedia. I think the overwhelming leader in embedded sql databases is sqlite. Found everywhere!


6

Yes. From the FAQ: Can multiple applications or multiple instances of the same application access a single database file at the same time? Multiple processes can have the same database open at the same time. Multiple processes can be doing a SELECT at the same time. But only one process can be making changes to the database at any moment in ...


5

A ported version of SQL Lite is probably your best bet. See this thread.


5

SQLite is probably the most commonly used one. It is light weight and has an open license. SQLite is being used by many embedded systems including Apple's iPod/iPhone/iTouch line of mobile devices, Google's Android phones, and Airbus aircraft. Given this I would probably recommend its use, but I will say that I myself have not used it for an embedded ...


4

At my previous employer, we sold applications with SQL Server Compact as the embedded database. It has some quirks, but it works reasonably well.


4

Based on your question "What support is there for multiprocessing": SQL Server CE and SQLLite are single-user DBs that work in your app and deployed as DLLs SQL Server (Express and above) (and MySQL, Oracle, Postgres et) are server engines where you submit a request Either you have proper multiprocessing or you don't: not much grey area in between. The ...


2

You are not missing the point :) The key is how many reads and how many writes do you have to do when you store/update/fetch various entities in your collections? You are presumably constantly (daily?) creating new posts and frequently creating new comments, and very frequently querying posts. Actions like updating authors' email are very rare compared to ...


2

You many want to look into using the Sphinx Search tools. It allows you to create a MySQL instance that runs on port 9036 and only stores indexing info along with keys into real MySQL databases/tables. There is a third party MySQL Storage Engine called SphinxSE. Theoretically, the keys can you store in Sphinx do not have to be for MySQL. They could be for ...


1

Normalization is a set of techniques to avoid certain problems viz data update anomolies. In a perfect world you would not store structured content but split it into its constituent parts across however many table are required and re-construct each complex object at runtime (1st normal form). However .. if pre-parsing the object and storing the interesting ...


1

Here are the functions from the C/C++ API mysql_library_init() : Should be called before any other MySQL function is called, preferably early in the main() function. mysql_library_end() : Should be called before your program exits. mysql_thread_init() : Should be called in each thread you create that accesses MySQL. mysql_thread_end() : Should be called ...



Only top voted, non community-wiki answers of a minimum length are eligible