embedded-database

What is the difference between the different BerkeleyDB versions, and which should I choose?

Many things depend on BDB. When I go to install the prepackaged software for my server, each piece of software seems to want a different version of BerkeleyDB. But it seems when I compile them I can specify a specific BDB version. (The software involved includes Postfix, OpenLDAP, and Cyrus IMAP.) I use BDB in python projects occaisio...

MS Access CrossTab query - across 3 tables

Hi, I have the following 3 tables: 1) Sweetness Table FruitIndex CountryIndex Sweetness 1 1 10 1 2 20 1 3 400 2 1 50 2 2 123 2 3 1 3...

Are there any embeddable document database engines for Java? Something similar to MongoDB or CouchDB?

Are there any embeddable document database engines for Java, that do not require separate server. I am looking for something similar to MongoDB or CouchDB. ...

Good embedded database solution (like SQLite) for .Net

I am looking for file based storage solutions that I can use with a .Net project. THey need to have a sql-like interface for storing and retrieving data. They need to have relatively little overhead and must not require any additional components installed by the end user. I am hopping for a .dll that I can reference and use. Cool poi...

SQlite/Firebird: Does any of them support multiple concurrent write access ?

Question: I currently store ASP.net application data in XML files. Now the problem is I have asynchronous operations, which means I ran into the problem of simultanous write access on a XML file... Now, I'm considering moving to an embedded database to solve the issue. I'm currently considering SQlite and embeddable Firebird. I'm not ...

How to deploy a Java Swing application with an embedded JavaDB database?

I have implemented an Java Swing application that uses an embedded JavaDB database. The database need to be stored somewhere and the database tables need to be created at the first run. What is the preferred way to do these procedures? Should I always create the database in the local directory, and first check if the database file exist...

MultiOS "Jet Database" for C++/Qt?

Hopefully I can articulate this well: I'm porting an application I made years ago from VB6 (I know, I know!) to C++/Qt. In my original application, one thing I liked was that I didn't need an actual SQL server running, I could just use MS Access .mdb files. I was wondering if something similar exists for Qt that will work on multiple OSe...

Embed a database in the .apk of a distributed application [Android]

Hi everybody, My question is I think quite simple but I don't think the answer will be... I have quite a lot of content to have in my application to make it run properly, and I'm thinking of putting all of it in a database, and distribute it in an embeded database with the application in the market. The only trouble is that I have no ide...

Understanding how large sqlite databases works on top of jffs2

I am considering using sqlite3 on embedded Linux with JFFS2/NAND instead of using a file based approach. My concern is NAND wear and number of erase operations. So how will e.g. the scenario of deleting or inserting a row in a 12MB database work: Will the whole 12 MB database be re-written when I commit, thus queueing all 12MB of NAN...

Oracle times ten embedded in a java application

Can someone point to me some documentation on how to run the Oracle times ten database in an embedded mode within a java application? I would like to run times-ten as a replacement for HSQLDB. ...

Good embedded database for Qt?

I am looking for good embedded database that i can use for application developed using Qt. The applications target desktop users from various sites of a single large company. The database should be able to store data separately at each site and the data shall be merged with other sites as and when it is required. ...

When to use an Embedded Database

Hey everyone, I am writing an application, which parses a large file, generates a large amount of data and do some complex visualization with it. Since all this data can't be kept in memory, I did some research and I'm starting to consider embedded databases as a temporary container for this data. My question is: is this a traditional ...

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 had to code circles around, and even then, we can't seem to protect ourselves from them comp...

Spring disconnecting from Derby

I'm using Apache Derby with the Spring JdbcTemplate inside a web app running on Tomcat. Spring is managing the data source. I've noticed that if I update the .war file and Tomcat undeploys/redeploys the app, I get this error: java.sql.SQLException: Another instance of Derby may have already booted the database /tmp/manager_db/manager....

What database for both local and client/server?

We have a "large" code base already developed using SQLite and NHibernate using .NET 2 for our clients. Using SQLite we can communicate with the db (even multiple clients) across a Windows file share. Most of the time, this is perfectly sufficient for what we need to do. Over the last few months, we have needed to integrate our applic...

ASP.NET MVC 2 Embedded Database

Hi, I am building a very small temprorary website that needs a small backing store. I have built this in ASP.NET MVC 2, and wanted to host with DiscountASP - although this isn't essential. I would like an backing store that will work with ASP.NET MVC 2, VS2010 Express, enabled LINQ (or EF) and work without further charges on a shared h...

Seeking Embedded Database alternative to SQLite. Must have foreign key contraint and transaction support?

Do you know of any SQLite alternatives (Portable/flatfile based/serverless) that have foreign key constraint and/or offer transaction support? ...

low cpu footprint java embeded database

This is a follow up to a question i asked at http://stackoverflow.com/questions/3316630/java-disc-based-hashmap for a disk based hashmap. The solution suggested works but at a high CPU cost. I've tried using a few embeded databases, including hsqldb and derby as well as an sqllite implementation in java. The all get the job done, quit...

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? ...

Embedded DBMS with XML support for .NET?

Is there an .NET-enabled embedded database (like SQLite.NET) with support for XML? It doesn't matter for me if it is SQL or NoSQL, XPath, document-oriented or not. I just know of BerkeleyDB XML, but this project is still alha and seem to be dead for a year. ...