> 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 is
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, reme
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 a
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 th
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 o
Has anyone done comparison between embedded mySQL and SQLite? Would like
to request feedback/comments on how do the two technologies
contrast/compare?
Vivek
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,
Ri
>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
pragma table_info (and others).
Look at the pragma docs.
Regards
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 databas
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 progra
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 Wind
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 Bam
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 v
--- 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 wher
15 matches
Mail list logo