I am currently writing an App that needs the ability to modify and persist various pieces of data. I've decided to use Core Data for this purpose. When the user opens the Application for the first time I need to import a large amount of data from a sqlite database, this data consists of the many-to-many relationships. I'd like to find ...
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 increase to 250k) each with 1k of data (max 8 filed). That's approximate - I can try to...
What does your Spring configuration for a datasource with embedded h2 database that you use for integration (JUnit-)tests look like? My first try with a SingleConnectionDataSource basically worked, but failed on more complicated tests involving suspended transactions. You might start h2 in tcp based server mode as well, but this is proba...
What are the differences between SQLite and DISQLite and why would I want to pick one over the other? My context is that I am dealing with a large database (could be up to 10 GB), the critical part of which is in one very simple table with a single indexed field and one text field up to a few KB in size. My development tool is Delphi 2...
I'm in need of an cross platform embedded database solution for a c++ app. I don't need a relational database (but won't say no) as it's only needed for read only indexed lookups and text searches. I've had a look about and at first glance this is dead easy (sqlite automatically springs to mind) but here's the kicker: Tables receive re...
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 data. The amount of data would be such that it couldn't all be loaded into memory at the sa...
I'm looking for a key/value store meeting the following requirements: Open Source C API (C++ okay too) ACID Some level of crash recovery High [storage] capacity per file Both key and value are arbitrary binary data Embedded (like DBM, SQLite, et al.) GDBM looks particularly attractive. Per the fact that the datum struct uses int ds...
When using embedded java databases, can someone explain how the database persists data across sessions? Does it create a local file on the PC that is reloaded when the app connects to the database? Or would I need to explicitly dump/reload the contents on exist/restart? thanks, Jeff ...
We would like to implement an application architecture in which we have large numbers of databases on the disk, one database file for each customer. When a user request comes in the database is opened (if it isn't already). After a certain period of time with no activity, the database is closed automatically by the server, thereby free...
I'm developing an App on windows mobile and android, i needed a database for this app and as of now have shortlisted 3 lite databases. SQLite Ultralite (from Sybase) Oracle Lite of these 3, i was unable to configure UltraLite with my existing project on VS2008. i am currently using SQLite with the dll from http://sqlite.phxsoftware.com ...
I have rasterized map in different resolutions, which consists of 15K/60K/240K pictures each sized 256x256, and i have .NET Compact Framework application which can display the map. But it takes a lot of time to copy 300k files to SD card, approximately 35-60 hours (i copyied just 15K and it took ~ 2 to 2.5 hours), and i'm afraid it will ...
What is the detailed syntax for the 'CREATE DATABASE' statement for VistaDB? The documentation only describes various procedures,functions,operators etc, but nothing on the 'CREATE DATABASE' statement. The 'create database' 'how-to' specifies hard coded values for the page size and other parameters, but can I use an ADO.NET connection ...
I'm looking for a fast, embeddable key/value store with cursor semantics over key collections (or a simple embeddable DB) that I can use in .NET and mono. Need it to be open-source, would prefer an MIT or Apache style license over a GPL license. Not opposed to a library that needs bindings to be written, as long as binaries are available...
I am using an embedded database file, on start up of my app, i will open the database file, only when the app exit, i close the database file, is it a best practice? should i use it the traditional open-update-close fashion? ...
I have a .Net 4.0 WPF application that requires an embedded database. MS Access doesn't work on 64 bit Windows I'm told. And I'm having issues with SSCE: Unable to load DLL 'sqlceme35.dll': This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem. (Exce...
I need to develop a product catalog (about 4000 products) application, which would be given to clients on CD or DVD. The catalog exists in webpage format using PHP and MySQL. IMPORTANT: the application is given to clients who maight have old PC, old System. For minimal requirements I would put Windows XP and Internet Explorer 6 (if nee...
This might be a stupid question but I'm new at all this. I want to create a Windows program that communicates with a database. Is there any way to do this without the user of my program have to install a database program like MySql? I'm going to program it in C#. ...
Hello Good people!! I'm deploying a winform application built with vs 2008 0n XP sp3. I created a database with empty schema which i dropped in the root folder of the project and in properties i choosed Build Action: Embedded Resources and Copy to Output directory : Copy always. Now instead of having connectionstring in the app.config...
I'm wondering how long a (theoretically) desktop-app can consume the full 4GB limitation of these express/embedded database products (SQL-Server Express, Oracle Express, SQLite3, etc) provided that big blobs will be stored in filesystem. Also what would be your strategy when it hits the 4GB? Archive the old DB Copy 1-3 months of data...
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://<host>/mem:<databasename> I've tried many combinations, but simply cannot get the remote connection to work. Is this feature working, can anyon...