Re: [sqlite] Function to find the size returned data size from a SELECT??

> I was wondering if there was a way to find the size of data that will be > returned before actually making the call to sqlite3_get_table which will > return a pointer to a malloc'd memory location. My question is really: can I > find the required memory size before the call? The short answer

Re: [sqlite] How to bind DATE and TIME values

Look at: http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions Alternatively, you could use the c library's time() or gettimeofday() and store the result in an INTEGER column (which in sqlite can hold 64-bit values, if you need the full resolution from gettimeofday). In either case,

Re: [sqlite] "Data Dictionary" in SQLite?

Daniel Hutchison wrote: Is there an Oracle data-dictionary equivalent in SQLite? Ie. Is there something similar to "SELECT * FROM ALL_TABLES" to get information about tables in the database returned in row format? Daniel, The other replies were not bad, but the query closest to what you

[sqlite] How to bind DATE and TIME values

Hello, I would like to use the sqlite3_bind_* functions to bind data to a TIMESTAMP column. With regular SQL I can use the following command: INSERT INTO TABLE (completed) VALUES(date('now')); The data('now') function returns the current date. What is the correct method in the C API to have

Re: [sqlite] Embedded mySQL & SQLite

Hi, Last time i tried embedded mysql (4.1) i just noticed it was buggy and not properly documented. i could get it to work but is still needed silly things like a my.cnf on the c:\ drive (windows), possibly conflicting with a running mysql server. To me it looks embedded mysql needs tonloads

[sqlite] Embedded mySQL & SQLite

Has anyone done comparison between embedded mySQL and SQLite? Would like to request feedback/comments on how do the two technologies contrast/compare? Vivek

[sqlite] Function to find the size returned data size from a SELECT??

Hi, I was wondering if there was a way to find the size of data that will be returned before actually making the call to sqlite3_get_table which will return a pointer to a malloc'd memory location. My question is really: can I find the required memory size before the call? Thanks in advance,

Re: [sqlite] "Data Dictionary" in SQLite?

>From what I know sqlite is not a DBRMS Thanks > Is there an Oracle data-dictionary equivalent in SQLite? > > > > Ie. Is there something similar to "SELECT * FROM ALL_TABLES" to get > information about tables in the database returned in row format? I know > that I can use .tables or .dump to find

Re: [sqlite] "Data Dictionary" in SQLite?

pragma table_info (and others). Look at the pragma docs. Regards

Re: [sqlite] "Data Dictionary" in SQLite?

select * from sqlite_master; A column tells the type of object. On 9/21/05, Daniel Hutchison <[EMAIL PROTECTED]> wrote: > > Is there an Oracle data-dictionary equivalent in SQLite? > > > > Ie. Is there something similar to "SELECT * FROM ALL_TABLES" to get > information about tables in the

[sqlite] "Data Dictionary" in SQLite?

Is there an Oracle data-dictionary equivalent in SQLite? Ie. Is there something similar to "SELECT * FROM ALL_TABLES" to get information about tables in the database returned in row format? I know that I can use .tables or .dump to find out what is going on in the database, but I have a

[sqlite] [ANN] SQLcrypt 1.5 for Windows and OS X

Hi all, I'm pleased to announce that SQLcrypt 1.5 is now available. SQLcrypt is a commercial enhancement of SQLite featuring transparent AES encryption. This release, based on SQLite 3.2.2, is available for both Windows and OS X. It passes all tests in SQLite's (adapted) test suite: For

Re: [sqlite] Share an sqlite3 struct between multiple threads

So SQLite is not "portable" on some Unix (more precisely on recent linux NPTL where file locks seems broken). i submitted a patch this month: http://www.sqlite.org/cvstrac/tktview?tn=1417 Best regards, Wed, Sep 21, 2005 at 02:56:48PM +0100: Christian Smith wrote: > On Tue, 20 Sep 2005, Marco

Re: [sqlite] Share an sqlite3 struct between multiple threads

On Tue, 20 Sep 2005, Marco Bambini wrote: >I know based on http://www.sqlite.org/faq.html#q8 that it is not safe >to share the same sqlite3 structure between multiple threads. >But what if I protect its access with a mutex? >It is safe? Until recently, by chance, yes, on some platforms. Recent

RE: [sqlite] Problem with floating point fields, and a feature request

--- Cariotoglou Mike <[EMAIL PROTECTED]> wrote: > collating sequences do not apply to floating point comparisons, do they? Hmmm, excellent point. Guess I didn't think too hard about that one. But the other point is the real show-stopper, how should the software deal with the circumstances