[sqlite] RE: Using sqlite on Nintendo DS / PSP

Thanks for the tips. I'll look into writing a custom OS interface layer, at least for the DS. Binary data that's embedded in ROM will usually be stored as a byte array directly in a source file, so I'll need to write an interface layer that doesn't rely on any type of file I/O. As for the PSP, I

Re: [sqlite] Working with database entirely from memory

My reason is mostly to increase performance since this is a relatively small database and will be accessed constantly. Its size is also not likely to increase much. You don't define what "small" is. You should first make sure you even have a problem. SQLite does in memory buffering anyway

Re: [sqlite] Working with database entirely from memory

Open it to :memory. You won't find much improvement, if any. Yaniv Pe'er wrote: Hi all, I wish to load my entire database to the program memory and work with it through there without having to use the hard drive at all (Well, besides the initial loading). My reason is mostly to increase

[sqlite] Working with database entirely from memory

Hi all, I wish to load my entire database to the program memory and work with it through there without having to use the hard drive at all (Well, besides the initial loading). My reason is mostly to increase performance since this is a relatively small database and will be accessed constantly.

Re: [sqlite] Compressing the DBs?

I don't really think this is a good way of dealing with this but thanks for the idea, if everything else doesnt work out, I might end up doing this. However its not a solution at all. - Original Message - From: "Mikey C" <[EMAIL PROTECTED]> To: Sent:

Re: [sqlite] Open sqb database in php?

On 7/6/06, Albert van Bergen <[EMAIL PROTECTED]> wrote: Hi All, I pretty new into sqlite. Is it possible to open a sqb database in php? Use PDO_SQLITE for sqlite2 and sqlite3 PHP5 only, or use SQLite extension for sqlite2. SQLite extension already built-in in PHP5, for PHP4 you must load

Re: [sqlite] Open sqb database in php?

Both Sqlite V2 and 3 are embedded in the standard PHP release. Albert van Bergen wrote: Hi All, I pretty new into sqlite. Is it possible to open a sqb database in php? When I use sqlite_open I do get the following warning: Warning: sqlite_open() [function.sqlite-open]: file is encrypted or

Re: [sqlite] Open sqb database in php?

On Thu, 6 Jul 2006, Albert van Bergen wrote: > Is it possible to open a sqb database in php? Natively you can open SQLite 2 databases. There is a 'package' avaiable to open SQLite 3 database, but I never tried that. Stefan

[sqlite] Open sqb database in php?

Hi All, I pretty new into sqlite. Is it possible to open a sqb database in php? When I use sqlite_open I do get the following warning: Warning: sqlite_open() [function.sqlite-open]: file is encrypted or is not a database in C:\Program Files\Apache Group\Apache2\htdocs\sql.php on line 2 file

Re: [sqlite] Compressing the DBs?

Gussimulator uttered: I've been using SQLite for a very short period of time and so far Its doing a great job for my application (single user, quite a big amount of data though). Now, since theres a lot of repetitive data, I thought that compressing the database would be a good idea, since,

Re: [sqlite] Compressing the DBs?

[EMAIL PROTECTED] uttered: Mikey C <[EMAIL PROTECTED]> wrote: Not sure what you mean there DRH, but I set compression on one of my database files on NTFS and file size shrunk from 1,289,216 bytes to 696,320 bytes. And of course the whole compression / decompression process is completely

Re: [sqlite] Multiple Users

[EMAIL PROTECTED] wrote: Original-Nachricht Datum: Wed, 05 Jul 2006 17:24:54 -0500 Von: John Stanton <[EMAIL PROTECTED]> An: sqlite-users@sqlite.org Betreff: Re: [sqlite] Multiple Users Hello John Ann don't cry into your beer, there is always next time! My team also got

Re: [sqlite] Compressing the DBs?

On 7/6/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: I'm guessing that the random I/O behavior of SQLite will frustrate the compression implemented by NTFS and Reiser. The end result will be a database file that might actually take up more space than if it were uncompressed. I'd be

Re: Re: [sqlite] Multiple Users

Original-Nachricht Datum: Wed, 05 Jul 2006 17:24:54 -0500 Von: John Stanton <[EMAIL PROTECTED]> An: sqlite-users@sqlite.org Betreff: Re: [sqlite] Multiple Users Hello John > Ann don't cry into your beer, there is always next time! My team also > got knocked out by Italy.

Re: [sqlite] Compressing the DBs?

If you have repetition like that it doesn't mean that you cannot normalize into third normal form. In your simple case having a table where X="E:\DirectX90\Feb2006" would work. It would perform better than brute force compression requiring inflation for each search. Gussimulator wrote:

Re: [sqlite] Compressing the DBs?

Not sure what you mean there DRH, but I set compression on one of my database files on NTFS and file size shrunk from 1,289,216 bytes to 696,320 bytes. And of course the whole compression / decompression process is completely transparent to SQLite and if you decide that compression is a bad

Re: [sqlite] Compressing the DBs?

"Jay Sprenkle" <[EMAIL PROTECTED]> wrote: > On 7/5/06, Mikey C <[EMAIL PROTECTED]> wrote: > > > > What platform are you using? > > > > If you are using NTFS filesystem you can just mark the file for compression > > and the OS takes care of it transparently. > > The linux OS supports Reiser file

Re: [sqlite] Compressing the DBs?

On 7/5/06, Mikey C <[EMAIL PROTECTED]> wrote: What platform are you using? If you are using NTFS filesystem you can just mark the file for compression and the OS takes care of it transparently. The linux OS supports Reiser file systems. This will compress on the fly with the compression

RE: [sqlite] Using sqlite on Nintendo DS / PSP

> I'm building a dictionary application that will run on > Nintendo DS and PSP. > I'm considering using sqlite to store the database which will will be > read-only, and embedded on rom. > > Is it possible to get sqlite to read the database directly from such a > pre-allocated memory area? Usage

Re: [sqlite] Compressing the DBs?

At 07:07 06/07/2006, you wrote: Hello there, This is what I mean by repetitive data: Tables: E:\DirectX90c\ E:\DirectX90c\Feb2006_MDX1_x86_Archive.cab\ E:\DirectX90c\Feb2006_d3dx9_29_x64.cab\ E:\DirectX90c\Feb2006_xact_x64.cab\ E:\DirectX90c\Feb2006_MDX1_x86.cab\

Re: [sqlite] Fwd: sqlite3_busy_timeout() on NetBSD

=?ISO-8859-1?Q?Tobias_Rundstr=F6m?= <[EMAIL PROTECTED]> wrote: > Hello List, > > Got this email from this a developer of XMMS2 Sounds a bit scary, > anyone have seen this before? > > > > > I'm an xmms2 developer who does most of the work of getting xmms2 > > working on the various BSDs. I've

Re: [sqlite] Using sqlite on Nintendo DS / PSP

ahochan uttered: I'm building a dictionary application that will run on Nintendo DS and PSP. I'm considering using sqlite to store the database which will will be read-only, and embedded on rom. Is it possible to get sqlite to read the database directly from such a pre-allocated memory area?

[sqlite] Using sqlite on Nintendo DS / PSP

I'm building a dictionary application that will run on Nintendo DS and PSP. I'm considering using sqlite to store the database which will will be read-only, and embedded on rom. Is it possible to get sqlite to read the database directly from such a pre-allocated memory area? Usage examples I've