-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
SQLite was tested in the same configuration that it appears on the
website. It was compiled with -O6 optimization and with the -DNDEBUG=1
switch which disables the many "assert()" statements in the SQLite
code. The -DNDEBUG=1 compiler option
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Christian Smith wrote:
> On Tue, 8 Feb 2005, John Richard Moser wrote:
>
>
> Does the sqlite3 command line interface program support BLOB data?
>
> I am thinking of feeding sql commands to sqlite3 (the command). In the
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kurt Welgehausen wrote:
>>... feeding sql commands to sqlite3 (the command)
>
>
> The SQLite shell is not really designed for production
> work. It can be used as you suggest for routine queries,
> but for anything more complicated, you'll have
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Does the sqlite3 command line interface program support BLOB data?
I am considering that my choice of C may not have been the greatest idea
in tackling the problem of writing a package manager. There is much
already to do what I need to do, and I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Uh.
The core is better. Try benching a Barton (32 bit) next to a P4, you'll
see. I think it takes something like a 266MHz barton to clock with a
1GHz P4.
I estimate a clawhammer core at probably ~1.25-1.5x faster than a Barton
core; but with the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I'd probably suggest something about how to set BLOB data from a void*
and an int in 1 line of code, if I had any idea at all how blob data is
set now.
I found an example, but it was something like 400 lines long, overly
complex (loading a blob into
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
ok, screw it, I'm storing configuration files, policies, and POSIX ACLs,
I'll figure out blobbing later; I've only mastered like 3 functions from
SQLite's C API, so I've got other things to worry about. For now,
base64 . . .
John Richard Moser wrote
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
The documentation at [1] is confusing me. Does anyone have a URI or
such where I could see examples of code to set and read BLOB data?
I feel I may be looking at this as too simple a task. . .
[1] http://sqlite.org/capi3ref.html
- --
All content
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Here's a question.
I'm doing a file table with
(
path text,
name text,
...
)
And I know definitely I'll want to search for "name" where
/usr/lib/libgtk.so is name=libgtk.so
Now for path, will I ever care to search for '/usr/lib/'? Or would
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Christian Smith wrote:
> On Fri, 14 Jan 2005, John Richard Moser wrote:
>
>>-BEGIN PGP SIGNED MESSAGE-
>>Hash: SHA1
>>
>>
>>
>>D. Richard Hipp wrote:
>>
>>
>>>I don't *t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
D. Richard Hipp wrote:
> Christian Smith wrote:
>
>>> /tmp/ is rwx by anyone
>>> root stats /tmp/tmpdb.root.1072 (pid==1072)
>>> Nonexistant
>>> User ln -s /etc/fstab /tmp/tmpdb.root.1072
>>> root creates /tmp/tmpdb.root.1072
>>> fstab erased.
>>>
be useful.
Interesting, dependencies(/conflicts) in their own table.
Christian Smith wrote:
> On Sat, 8 Jan 2005, John Richard Moser wrote:
>
>
>>-BEGIN PGP SIGNED MESSAGE-
>>Hash: SHA1
>>
>>What can be in an SQL table?
>>
>>Can tables contain tab
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Christian Smith wrote:
> On Tue, 11 Jan 2005, John Richard Moser wrote:
>
>
>>-BEGIN PGP SIGNED MESSAGE-
>>Hash: SHA1
>>
>>http://rafb.net/paste/results/jRFmZD25.html
>>
>>This is code from
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
http://rafb.net/paste/results/jRFmZD25.html
This is code from a package manager I'm writing based on SQLite. These
two functions open a database, creating it if it doesn't exist.
While most of this isn't of general interest, I'd like to point out that
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
~From what I can tell people are just in shock and awe that checking 3000
tables each holding several years of data for a company (again: several
years of data for 3000 different companies) calls malloc() several
million times.
Interesting enough,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
http://www.w3schools.com/sql/sql_create.asp
Data types given there
http://www.sqlite.org/datatype3.html
Data types given here
Is it ok to use the SQL data types given by w3schools? Or must I
strictly use TEXT, NULL, INTEGER, BLOB, and NUMERIC?
- --
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mrs. Brisby wrote:
| On Sat, 2005-01-08 at 00:04 -0500, John Richard Moser wrote:
|
|>What can be in an SQL table?
|
|
| Tuples.
|
|
like Baby from DBGT?
[...]
- --
All content of all messages exchanged herein are left in the
Public Domain, unl
ble (data) inside a
table (group) inside a table (subcategory) inside a table (category)
logically.
SQL databases, can they handle this literal hierarchy, or do I not have
the ability to embed tables in tables?
John Richard Moser wrote:
| What can be in an SQL table?
|
| Can tables contain tables
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Andrew Piskorski wrote:
| On Fri, Dec 24, 2004 at 07:32:07PM -0500, John Richard Moser wrote:
|
|
|>I thought sqlite databases weren't supposed to be opened with two sqlite
|>processes at once. There are unimplemented locking comman
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
D. Richard Hipp wrote:
| John Richard Moser wrote:
|
|>
|> I thought sqlite databases weren't supposed to be opened with two sqlite
|> processes at once. There are unimplemented locking commands due to this
|> right?
|>
|
| Whe
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I thought sqlite databases weren't supposed to be opened with two sqlite
processes at once. There are unimplemented locking commands due to this
right?
I'm bouncing back and forth in my head trying to decide if I should use
mysql or sqlite to write a
21 matches
Mail list logo
