Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [embedded]

This tag is for issues pertaining to databases that are embedded in an application.

The term "embedded" is used to characterize databases that were built to support exactly one application. There are other usages of "embedded", but this is the main one. When a database is embedded in an application, the requirements on the database are driven by the overall requirements on the application.

Questions arise about whether the design principles for databases in general apply to databases that are embedded in one application. There are also questions that arise about when and how embedded databases ought to be administered, and about whether access to the data via a language like SQL ought to be allowed or denied.

When a question about databases applies specifically to an embedded database, this tag will group the question together with other similar questions.

16 questions
13
votes
1 answer

Can I use SQLite to share data among different applications?

Can I use SQLite as a database to which 2 or more applications connect? I.e. can I use it to share data among different applications?
Pietro
  • 619
  • 3
  • 9
  • 19
13
votes
1 answer

Looking for simple contains method when searching text in postgresql

Im new to the PostgreSQL world so I do apologize in advance for not knowing if there is an obvious answer to these questions. Basically I'm looking for two things. First a simple "contains" based search where the python equivalent would be something…
codykochmann
  • 233
  • 1
  • 2
  • 6
10
votes
1 answer

Fast database for a small microcontroller

I am using a PIC32, which is a 32-bit processor clocked at 80 MIPS with about 64-128KB of RAM available. It will be accessing a microSD card - up to 4 GB, on a FAT32 filesystem. Running all of this is pushing it, but I need a compact database that…
Thomas O
  • 511
  • 5
  • 8
10
votes
1 answer

Efficiently store large list structure in RocksDB so that the data can be retrieved in pages

Description: RocksDB is a key-value storage so we can simply serialise the list of objects & store the value corresponding to a key. This would be ok if the data in the list is small enough. But if the list is large and ever increasing in size…
Pinank Lakhani
  • 103
  • 6
8
votes
3 answers

Which databases are recommended to be used as embedded databases?

Which databases are recommended to be used as embedded databases to store data within an application? The embedded database may or may not synchronize back to a larger system database.
SchwartzE
  • 339
  • 1
  • 7
6
votes
1 answer

How can I create and initialize a schema for a embedded MySQL DB?

I want to create an embedded MySQL database for running tests, but I'm not sure how to do it. How do I initialize the database? How do I run my create table statements? I'm using Perl, so it needs to be done with a language and not a couple of…
xenoterracide
  • 2,921
  • 5
  • 31
  • 33
6
votes
1 answer

MongoDB - handling embedded documents and relations

I am researching MongoDB for a web app that I am bulding. Coming from a MySQL background, the concept of embedded documents is not so easy to fully understand. Let's say I have a document called blogpost and it looks something like…
ragulka
  • 161
  • 3
3
votes
1 answer

SQL Server Embedded Edition vs SQLite

Can anybody shed some light on how these SQL products compare? No need for essays, only highlights such as "X supports this, while Y doesn't". How is efficiency affected as the database grows larger Inserts Updates Selects What kind of…
Jörgen Sigvardsson
  • 133
  • 6
3
votes
1 answer

What kind of database is this schema for, and how can I open it?

For sentimental reasons, I'm trying to export my text messages from an old feature phone (LG Cosmos 2, circa 2011) to a flat file (CSV or the like). I was able to successfully transfer the entire contents of the phone's file system to my computer,…
alexw
  • 192
  • 6
2
votes
1 answer

Is it always bad to have an own table for value objects?

I know that value objects should be embedded in the table of the object they belong to but what if the value object is more than a simple object and contains many fields/columns or even sub-objects? I currently have a table named content which in…
JMD Coalesce
  • 224
  • 1
  • 7
2
votes
1 answer

Building a custom database in C with/without SQL?

Provide link or tutorials to build a custom database management in C. I am looking for Full Text Search options of about 10GB DB.
Vineet1982
  • 169
  • 1
  • 5
1
vote
1 answer

What are the MariaDB/MySQL servers types, and how do they differ?, e.g., 'standalone' vs 'embedded', vs ...?

When configuring a MySQL or MariaDB server, the terms 'standalone' and 'embedded' are referred to, but without reference to what they are, or what they do that is different from each other. What does the term 'embedded' refer to? Is this like on…
Elliptical view
  • 143
  • 6
0
votes
1 answer

Reliability of Scimore embedded database

I currently use SQLite for some applications that need a light embedded database. These apps use multiple processes that access the same database. For concurrent write access this is cumbersome. We have done some work-arounds to overcome this to…
user45130
0
votes
1 answer

Using Sync Orchestrator to Syncronize two SQL CE 3.5 Databases

I am trying to set up synchronization between two SQL Compact 3.5 databases using SqlCeSyncProvider. I am able to create a scope for the two databases, which creates a meta table. When I try to run SyncOrchestrator.Synchronize() though, I get the…
Stuart
  • 123
  • 4
0
votes
1 answer

Many-to-many database

I am thinking about making a music database. Something where you can search by artist, album or song. This seems to be a Many-to-many model, as an album can have multiple songs, and the same song can be on different albums. Currently I am just using…
Zombo
  • 1
  • 3
1
2