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 s
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? U
=?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 cu
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\
E:\DirectX90c\Feb2006_xact_x86.
> 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
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 being
"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 sy
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 thin
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:
Hell
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.
Sh
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
> transparent to SQLite and
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 intereste
[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 kno
[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
trans
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,
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
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
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 i
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 the
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: Wednesday, July 05, 2006 6:44 P
Christian said:
For desktop or server use, storage is cheap.
Thats true, however I'd like to compress the database because I need
portability.
Sure, one could compress the DB and move it into a mobile storaging unit,
then when you're done you could decompress the DB on the destination
harddr
On 7/6/06, Gussimulator <[EMAIL PROTECTED]> wrote:
Eduardo said:
> SQLite has no compression system for free.
Not for free?, I take it that its possible to implement a compression scheme
in the database system then. Which is what I care only - of course its
possible, but now I know its bee
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. It
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 perfo
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 with
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
26 matches
Mail list logo
