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 ...
Which method do you suggest to efficiently secure your embedded database in Delphi applications? Here are the methods I've tested: Using Molebox Pro Pros - Fast, unpacking is not child's play, no additional task/coding Cons - Database will be read-only, same drawbacks as exe compressors Using DISQLite3 Pros - Overcome Molebox's r...
Hello, I'm hoping you can help. I'm looking for a zero config multi-user datbase that my winforms application can easily upload to a webserver folder (together with 1 or 2 classic asp pages) and am looking for some suggestions/recommendations. The idea is that the database will be used to collect feedback entered by people filling in ...
Actual Question: As the title implies, I am having confusion in choosing a better embedded RDBMS for a simple website, only few pages need some server side scripting language otherwise all HTML. I have already chosen Python for that, now could you folks recommend me which embedded database system I should use. The requirement goes lik...
I need to create a storage file format for some simple data in a tabular format, was trying to use HDF5 but have just about given up due to some issues, and I'd like to reexamine the use of embedded databases to see if they are fast enough for my application. Is there a reputable embedded Java database out there that has the option to s...
Hello, I was wondering if there was a lightweight, embeddable, key/value database out there. Something like a lightweight Couchdb (RESTful, key/value, etc) where you just send it the key and it responds with appropriate values. Thanks! ...
As the title asks, is VistaDB 3.x/4.x supported in Data Access Application Block (DAAB) of Microsoft Patterns and Practices Enterprise Library 3.x/4.x? If it is and you have used the two together, are there any issues or caveats I should know about? Or... Could anybody provide links to source code for the custom provider for Enterprise...
I need to store up to tens or even hundreds of millions of pieces of data on-disk. Each piece of data contains information like: id=23425 browser=firefox ip-address=10.1.1.1 outcome=1.0 New pieces of data may be added at the rate of up-to 1 per millisecond. So its a relatively simple set of key-value pairs, where the values can be s...
Is there a way to trace/log sql from the code (not from the db side, but rather what the code thinks it's doing)? I am using Pro*C/C++: Release 8.1.7.0.0 for Oracle ...
My application at present uses Microsoft Access, but now may be hosted on Linux boxes. Additionally while being accessed from multiple computers, one of these may update the records (when its being read by other users). I also require that the embedded database should support complex SQL queries - like inner SQL, Joins, etc. I tried SQ...
I'm making this tiny utility program (Windows Forms) and it would need to save a bit of data to the disk. In DB terms it would be about one table, no more than about couple thousand rows, each row being less then 1KB in size. What would you use? Added: Forgot to say - it would be really neat if the whole program would be just one .EXE ...
Currently, I have an application that uses Firebird in embedded mode to connect to a relatively simple database stored as a file on my hard drive. I want to switch to using PostgreSQL to do the same thing (Yes, I know it's overkill). I know that PostgreSQL cannot operate in embedded mode and that is fine - I can leave the server process ...
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 (!), but only a small random fraction of the data is accessed at a time. If necessary, I ...
Hello I would like to access data stored in an embedded Derby database by my Java application from a program like MS Access/Excel, Open Office, etc? Is there a way of doing this? I guess the only way this could be achieved is if Apache Derby came with an ODBC driver right? ...
I have a little problem with a Pro*C query I'm trying to optimise. To explain, our application searches for rows in a huge database. These rows exist in several languages and the old code selected a row for each language in an array. Now as these queries are the most time consuming part of our app, I wanted to make only one query which ...
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, it should be able to start its own mini MySQL server and manipulate data. So essentially,...
Hey guys, I'm writing an app for BlackBerry OS 4.7 and would greatly benefit from having a lightweight relational database such as SQLite that my application can use to store data locally on the device. SQLite is coming out with 5.0, which is still in beta. Can anyone recommend any other alternatives that permit commercial use? Additi...
I was wondering about the use of the .NET entity framework with an embedded database solution. Right now, I only use the EF with SQL Server but for a new project I'm looking for alternate solutions. SQL Server Compact would be one solution, but are there other alternatives that I can use with EF? Preferably solutions that don't require c...
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 it seems like something that should be done inside the DB layer. ...
I have come to the conclusion that SQL Server CE isn't a viable product. Between the versionsing issues and the impossibility of a non-administrator install it just doesn't work at my company. Off hand I'm thinking about Jet, Oracle Berkeley, and SQLite. Given that I'm using .NET with ClickOnce, what embedded database would you recommen...