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
22
votes
7 answers

Which embedded DB written in Java for a simple key/value store?

I recently asked a question about Neo4j, which I got working and which seems nice. It's embeddable and it's written in Java and there aren't (too) many dependencies. However it's a graph DB and I don't know if it's a good idea or not to use it as a…
Cedric Martin
  • 5,945
  • 4
  • 34
  • 66
22
votes
2 answers

java embedded library on-disk key-value database

What I think I'm looking for is a no-SQL, library-embedded, on disk (ie not in-memory) database, thats accessible from java (and preferably runs inside my instance of the JVM). That's not really much of a database, and I'm tempted to roll-my-own.…
Groostav
  • 3,170
  • 1
  • 23
  • 27
22
votes
4 answers

Java, MySQL: Is there a way to embed a MySQL server with a Java program?

One thing I love about .NET is the ability to have a database file along with the project. I know that using a SQLite database, this can be done, but did someone achieve this with a MySQL database backend? So for instance, if I run a java program,…
Legend
  • 113,822
  • 119
  • 272
  • 400
22
votes
1 answer

confusion about SQL Server Express and localdb

I need to deploy a WCF service with a database on client machines. I am confused about SQL Server Express. I need to verify all of the following. When attaching database files in the App_Data folder, do I still need to install SQL Server Express…
Costa
  • 3,897
  • 13
  • 48
  • 81
21
votes
2 answers

Saving in-memory H2 database to disk

How can I save/load full embedded h2 in-memory database to some file or directory in binary mode for faster loading. I want to use this for caching data so I don't have to run all the lines of create table/insert clauses every time.
mikkom
  • 3,521
  • 5
  • 25
  • 39
21
votes
8 answers

Embedded non-relational (nosql) data store

I'm thinking about using/implementing some kind of an embedded key-value (or document) store for my Windows desktop application. I want to be able to store various types of data (GPS tracks would be one example) and of course be able to query this…
Igor Brejc
  • 18,714
  • 13
  • 76
  • 95
20
votes
6 answers

Embedded database for .net

I need an embedded database for one of our .net applications. This database should support sql (Unlike Berkley). Can anyone suggest any options.
Hemanshu Bhojak
  • 16,972
  • 16
  • 49
  • 64
20
votes
14 answers

Why does my flapdoodle Embedded MongoDB test fail to run? (creating 'embeddedMongoServer' could not start process EOF)

I'm having trouble getting my brand new project to build. I used https://start.spring.io/ to generate a fresh new Spring 2.0 MongoDB Maven project, and I want to have an embedded MongoDB database for my integration tests. The spring initializer…
SnoopDougg
  • 1,467
  • 2
  • 19
  • 35
20
votes
10 answers

What's the "best" database for embedded?

I'm an embedded guy, not a database guy. I've been asked to redesign an existing system which has bottlenecks in several places. The embedded device is based around an ARM 9 processor running at 220mHz. There should be a database of 50k entries (may…
Mawg says reinstate Monica
  • 38,334
  • 103
  • 306
  • 551
19
votes
3 answers

Does Spring embedded database support different SQL dialects?

H2 has a range of compatibility modes for various other databases such as MS SQL Server, MySQL, Oracle, etc that support different SQL dialects. However, when setting up an embedded database in Spring I do not find any corresponding setting. Does…
matsev
  • 32,104
  • 16
  • 121
  • 156
18
votes
5 answers

How to do "select current_timestamp" in hsqldb?

Oracle: select systimestamp from dual MySQL: select current_timestamp SQL Server: select current_timestamp PostgreSQL: select current_timestamp The question is, how can I get the current timestamp in HSQLDB? I use version 1.8.0.10
cherouvim
  • 31,725
  • 15
  • 104
  • 153
18
votes
8 answers

Embedded (pure Java) database for Clojure

I'm in need for an embedded database for a Clojure application. Maybe it's the same criteria as for any other Java application but I rather get some other people's opinion anyway. I'm not picking SQLite because that's not pure Java so distribution…
Pablo Fernandez
  • 279,434
  • 135
  • 377
  • 622
17
votes
3 answers

Are Prepared statements supported in embedded MySQL

I normally develop with a live server, but for the first time I figured I'd make the leap and see if I could get all my (C++) mysql code working as an embedded server. Particularly, I'm very fond of prepared statements as they are (IMHO) "generally"…
Sass
  • 560
  • 4
  • 17
17
votes
1 answer

H2 Database vs SQLite on Android

Because of the lack of Unicode support on the embedded SQLite database in Android I am mostly interested in performance and stability of H2 Database vs Android SQLite Are you guys using it? Should I be aware of any H2 database shortcomings?
Eduardo
  • 2,327
  • 5
  • 26
  • 43
17
votes
4 answers

h2 in-memory tables, remote connection

I am having problems with creating an in memory table, using H2 database, and accessing it outside of the JVM it is created and running in. The documentation structures the url as jdbc:h2:tcp:///mem: I've tried many combinations,…
Carolyn
  • 171
  • 1
  • 1
  • 3
1
2
3
…
28 29