[sqlite] advice on schema evolution

Say you are doing some web development with SQLite in the backend. You progressively fill the database with the very web interface you are writing, throwing that data is not desirable in general. But at the same time the schema evolves with the project, tables are added, columns are

[sqlite] Re: Probably not simple question

John Stanton wrote: http://www.google.ca/search?q=boost+serialization I was describing no such thing. An example of what I was describing is what's serialization? http://www.google.ca/search?q=serialization union stored_word struct #ifdef BIG_END ... } a; #endif int b; }

Re: [sqlite] Re: Probably not simple question

I was describing a free union used to transform big endian to little endian and vice versa. There is no encoding involved. My alternatives, BASE64 and ASCII HEX are encodings of the binary integers. You let the buzzwords drown out the fundamentals. pps wrote: John Stanton wrote:

Re[2]: [sqlite] Re: Probably not simple question

Hello John, You guys are both going off in you own directions and arguing something that's really an unimportant implementation detail. Serialization's a wonderful thing, if you need it. It's nothing more than a protocol for storing, saving, transmitting something in a format that can be

Re: [sqlite] Re: Probably not simple question

Reads like good common sense to me :-). I mentioned Base64 and Hex as a possibility if TEXT type were to be used. As you so clearly point out they would be pointless if a BLOB is used. I also appreciate your comments about horses for courses. If you are just storing a JPEG image why do it

Re[2]: [sqlite] Re: Probably not simple question

Hello John, I'm not just storing JPG files, I'm storing them plus MD5 hashes, topics and other metadata. I agree, it's not as efficient as disk storage but, being able to easily search and manage the images as well as just keeping them in one place makes it worth the performance hit. The hash

[sqlite] Final Year Project/Dissertation help required!!!!

Hi, I am doing my final year project/dissertation on Creating a GUI to SQLite I am after help for my analysis phase and would like any comments/help from members or if you could put me in the right direction as to where I could find out this information. I would like information regarding SQLite

[sqlite] Final Year Project/Dissertation help required!!

Hi, I am doing my final year project/dissertation on Creating a GUI to SQLite I am after help for my analysis phase and would like any comments/help from anyone or if you could put me in the right direction as to where I could find out this information. I would like information regarding SQLite

[sqlite] equivalent of linked tables in sqlite ?

Hi All, I'm just starting with SQLite and hope to use it as the common database for a desktop and pocketpc tool. to keep it simple, I'd like to use a main database on the desktop and a secondary database to be copied to the pocketpc as a sqlite db. (no realtime synchronization is needed) if data

Re: [sqlite] Re: Probably not simple question

If you choose to store binary data such as JPEGs in files you have to have a limit on their number or some form of directory tree so that you keep each directory from overflowing, so that alone is a good reason for using Sqlite. The ease of backing up one file instead of tens of thousands of

Re: [sqlite] Final Year Project/Dissertation help required!!!!

john.newby wrote: Hi, I am doing my final year project/dissertation on Creating a GUI to SQLite I am after help for my analysis phase and would like any comments/help from members or if you could put me in the right direction as to where I could find out this information. I would like

RE: [sqlite] equivalent of linked tables in sqlite ?

Use Delphi. -Original Message- From: gl demoor [mailto:[EMAIL PROTECTED] Sent: Sunday, December 11, 2005 4:46 PM To: sqlite-users@sqlite.org Subject: [sqlite] equivalent of linked tables in sqlite ? Hi All, I'm just starting with SQLite and hope to use it as the common

Re: [sqlite] Final Year Project/Dissertation help required!!!!

john.newby wrote: Why users use SQLite instead of other SQL databases? Would a GUI detract users from using SQLite? I use SQLite as an embedded database for my content management system CeaMuS (http://www.ceamus.com). I use it because it allows me to distribute an application that takes full

[sqlite] About Index using

Hi , Here is a sql string ,like : select * from test where (a=0 or a=1) and b=1 ; and column a range from 1-1, and column b range from 0-1. and DB has about 300,000 record with colum a and b configured randomly . Two index is create on test table . First is on column b and the second

[sqlite] Re: About Index using

Bo Lin wrote: Here is a sql string ,like : select * from test where (a=0 or a=1) and b=1 ; and column a range from 1-1, and column b range from 0-1. and DB has about 300,000 record with colum a and b configured randomly . Two index is create on test table . First is on column b and the

Re: [sqlite] About Index using

On Mon, Dec 12, 2005 at 09:48:21AM +0800, Bo Lin wrote: Here is a sql string ,like : select * from test where (a=0 or a=1) and b=1 ; and column a range from 1-1, and column b range from 0-1. and DB has about 300,000 record with colum a and b configured randomly . Two index is create on

[sqlite] 回复： Re: [sqlite] About Index using

thanks a lot for your help ! Nathan Kurz [EMAIL PROTECTED] 写道： On Mon, Dec 12, 2005 at 09:48:21AM +0800, Bo Lin wrote: Here is a sql string ,like : select * from test where (a=0 or a=1) and b=1 ; and column a range from 1-1, and column b range from 0-1. and DB has about 300,000 record