[sqlite] SQLite Database File Size

Hi, I have started to use SQLite recently. I have an interesting situation of deciding the database schematic for my solution. In one of the tables I need to store contents of size 2000 * 20. If I could create 4 rows containing only one or two columns, my schema is quite convenient and

Re: [sqlite] SQLite embedded installation

Hello John, On 28 jul 2004, at 23:42, John Mistler wrote: I created an application with XCode for OS X that interfaces with a MySQL database. I would like to switch it over to SQLite. Could someone shed some light on how I go about incorporating the SQLite library into my application? For

RE: [sqlite] Storing unicode

Cleared this problem up - it was actually a conversion problem on my part (never rely on MFC to function correctly - always check!), SQLite works fine Dennis // Software for animal shelters http://www.smartpethealth.com // -Original Message- From: Dennis Volodomanov

[sqlite] sqlite_compile - bad return code

Hello, I am using SQLITE 2.8.13. Until now I had no major problems. My problem is a call to sqlite_compile() with this query: "SELECT * FROM RV WHERE VH=115863566" sqlite_compile returns SQLITE_OK, but *ppVm is NULL and pzErrmsg is "out of memory". I think there are two issues here: 1. Why

Re: Re: [sqlite] C callback that returns numeric data without conversion from text?

On Tue, Jul 27, 2004 at 10:56:09PM -0700, Al Danial wrote: > Great, that fits the bill perfectly, thanks! > > I know you mentioned the code is incomplete but the usage instructions > don't match the executable's behavior: the third command line argument > (the SQL command, or argv[2]) isn't used

[sqlite] collation sequence

would it be possible to add a COLLATE keyword at the TABLE level, also, so that, if the following is executed : CREATE TABLE bla(...) COLLATE mySequence then this sequence is the default for this table, when no specific sequence is defined ? or, if this is not possible, is it possible to

Re: [sqlite] re: ANN: SQLiteDB, a COM wrapper around sqlite has been released

Ed Porter >> The SQLite code is in the DLL (you do not need to install the SQLite3.02 dll). This wrapper is excellent! As a third party reviewer, I find it to be the best one to date! Thx for the feedback. I'll give it a shot. Fred.

Re: [sqlite] One or many db and vacuum (Improving speed)

On Wed, 28 Jul 2004, Rubens Jr. wrote: >Hi ! > >Suppose one database with 4 tables : S1, B1, B2 and B3, where S1 (small >1) has < 100 records, and B1, B2, and B3 (big tables) has > 100,000 >records each. Them entire database has +- 400 MegaBytes. These records >are inserted in ramdom order : S1,

[sqlite] HI SQLITE HELP IN GTK

Hi, I am using sqlite embedded in gtk program, the code is giving a segmetation fault and i am not able to figure out the error. The func where it is giving the segmetation fault is as given below : func() { int j,Crows=0,Ccols=0; txt = gtk_editable_get_chars(

[sqlite] One or many db and vacuum (Improving speed)

Hi ! Suppose one database with 4 tables : S1, B1, B2 and B3, where S1 (small 1) has < 100 records, and B1, B2, and B3 (big tables) has > 100,000 records each. Them entire database has +- 400 MegaBytes. These records are inserted in ramdom order : S1, B1, B1, B1, B3, B2, B1, B1 ... etc, so I think

[sqlite] Storing unicode

Hello all, Can you please tell me how to store UNICODE in SQLite v3? I'm using the sqlite3_mprintf() functions with %q, but it doesn't handle UNICODE correctly - I pass in a CString with a UNICODE value, but on the output of this function I get an incorrect string. The program is of course