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

[ahochan]

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 was probably a little rash in assuming that I would not
have any file system access. Applications on the PSP run either from UMD or
from Memory Stick, both of which have a file system. I may be able to use
the Unix OS interface directly, assuming that it uses standard library file
I/O.

-- 
View this message in context: 
http://www.nabble.com/Using-sqlite-on-Nintendo-DS---PSP-tf1899461.html#a5210700
Sent from the SQLite forum at Nabble.com.

[sqlite] Re: Using SQLite

[Ron Aaron]

On Sunday 01 February 2004 04:06 pm, Demitri Muna wrote:
> Hello,
Hi, Demitri -

> I need to embed a database into my application, and was referred to
> SQLite. I narrowed down my options to it and PostgreSQL (which I am not
> completely sure I can embed into an app). One thing that I need to be
> able to do is regular expression searching, something that PostgreSQL
> can do, but I don't think SQLite can. What is the best way to work
> around this?

I don't think PostgreSQL is embeddable, but maybe I'm wrong.  It's certainly
much bigger than SQLite.

You are correct that SQLite doesn't have built-in regexp search, but you can
easily add your own function and make SQLite use it.  

> The only solution that I can see is to keep all of my data in memory.
> (I expect I'll have upwards of 10,000 records, 1K each on average.) I

That's only 10 Meg, which isn't really too bad on modern machines.  But if you
think the db may grow, or the record size change, you might be better off
leaving it on disk.

> Has anyone else run into this?

Not this specifically, but I have added my own functions to SQLite at runtime,
and this is a great feature to use and will address your first concern.0


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]