Stack Overflow
Stack Overflow

Questions tagged [embedded-database]

An embedded database system is a database management system (DBMS) which is tightly integrated with an application software that requires access to stored data, such that the database system is “hidden” from the application’s end-user and requires little or no ongoing maintenance.

434 questions
135
votes
11 answers

Embedded MongoDB when running integration tests

My question is a variation of this one. Since my Java Web-app project requires a lot of read filters/queries and interfaces with tools like GridFS, I'm struggling to think of a sensible way to employ MongoDB in the way the above solution…
seanhodges
  • 17,426
  • 15
  • 71
  • 93
104
votes
18 answers

Java Embedded Databases Comparison

I intend to develop a small (Java) application for managing my finances. I believe I need to use an embedded database, but I have no experience regarding this issue. I tried to look at some of the available products, but I can't decide which one…
Hosam Aly
  • 41,555
  • 36
  • 141
  • 182
57
votes
7 answers

Can mongodb be used as an embedded database?

I am working on a RSS reader application. And I need to find a backend database. I want the database be embedded because I don't want the users to install a database server. I know SQLite is a good choice, but I am wondering if there are any other…
Bill Yan
  • 3,369
  • 4
  • 27
  • 42
54
votes
3 answers

Where does H2's Embedded Databases Store the data?

So I just recently started learning about how databases work, how to use SQL ect. and decided to start implementing an embedded database into my Java application (specifically the H2 database) and seemed to work fairly well on the computer I was…
Sammy Guergachi
  • 1,986
  • 4
  • 26
  • 52
51
votes
6 answers

Embedded PostgreSQL for Java JUnit tests

Is there an embedded PostgreSql so that we could unit test our PostgreSql driven application? Since PostgreSql has some dialects, it's better to use embedded PostgreSql itself than other embedded databases. Embedded does not necessarily mean it…
blue123
  • 2,937
  • 7
  • 27
  • 29
43
votes
0 answers

Embedded java databases

I would like to get opinions or suggestions regarding embedded databases in Java. In particular I was looking at H2, HSQLDB and Derby. Have you use any of these in a production project? Do you have comment or recommendations to select one over the…
Guillermo Vasconcelos
  • 1,701
  • 2
  • 17
  • 30
43
votes
4 answers

Spring configuration for embedded H2 database for tests

What does your Spring configuration for integration tests look like using an embedded h2 datasource and, optionally, JUnit? My first try with a SingleConnectionDataSource basically worked, but failed on more complicated tests where you need several…
Dr. Hans-Peter Störr
  • 25,298
  • 30
  • 102
  • 139
42
votes
10 answers

Reliable and efficient key--value database for Linux?

I need a fast, reliable and memory-efficient key--value database for Linux. My keys are about 128 bytes, and the maximum value size can be 128K or 256K. The database subsystem shouldn't use more than about 1 MB of RAM. The total database size is 20G…
pts
  • 80,836
  • 20
  • 110
  • 183
40
votes
29 answers

Which embedded database to use in a Delphi application?

I am creating a desktop app in Delphi and plan to use an embedded database. I've started the project using SQlite3 with the DISQLite3 library. It works but documentation seems a bit light. I recently found Firebird (yes I've been out of Windows…
Darrel
  • 563
  • 1
  • 5
  • 9
39
votes
8 answers

If possible how can one embed PostgreSQL?

If it's possible, I'm interested in being able to embed a PostgreSQL database, similar to sqllite. I've read that it's not possible. I'm no database expert though, so I want to hear from you. Essentially I want PostgreSQL without all the…
pc1oad1etter
  • 8,549
  • 10
  • 49
  • 64
38
votes
11 answers

Embedded Database for .net that can run off a network

I was (and still am) looking for an embedded database to be used in a .net (c#) application. The caveat: The Application (or at least the database) is stored on a Network drive, but only used by 1 user at a time. Now, my first idea was SQL Server…
Michael Stum
  • 177,530
  • 117
  • 400
  • 535
32
votes
4 answers

Spring Boot. @DataJpaTest H2 embedded database create schema

I have couple of entities in my data layer stored in particular schema. For example: @Entity @Table(name = "FOO", schema = "DUMMY") public class Foo {} I'm trying to setup H2 embedded database for integration testing of my data layer. I'm using…
StasKolodyuk
  • 4,256
  • 2
  • 32
  • 41
31
votes
7 answers

Does SQLite support replication?

In an application which embeds SQLite3 and uses an in-memory database, is it possible to replicate the database between two running instances of the application? I could do this by hand with a homebrew protocol duplicating all my DB accesses, but…
kdt
  • 27,905
  • 33
  • 92
  • 139
28
votes
5 answers

Setting up an embedded Derby database in a standalone Java application

I'm trying to setup an embedded Derby database for a standalone Java application, but after pouring through all sorts of documentation, I just can't seem to find any simple explanations or examples. I'm using Eclipse with the Derby plugin and have…
Clark Minor
  • 281
  • 1
  • 3
  • 5
25
votes
8 answers

Am I crazy? Switching an established product from HSQLDB to Apache Derby

I have an established software product that uses HSQLDB as its internal settings database. Customer projects are stored in this database. Over the years, HSQLDB has served us reasonably well, but it has some stability/corruption issues that we've…
CarlG
  • 1,656
  • 1
  • 17
  • 21
1
2 3
…
28 29