On Sat, 12 Apr 2008 17:23:55 +1000
Neville Franks <[EMAIL PROTECTED]> wrote:
> For SQLite in particular "The Definitive Guide to SQLite" by Micahel
> Owens is reasonably good. Unfortunately it has the worst index of any
> book I can recall seeing, other than some Cook Books. This makes it
> very
Hey all,
When using SQLite 3.5.4.1 (a special branch cut for Mozilla, based
mostly off of 3.5.4 with some OS/2 fixes), I'm getting SQLITE_LOCKED
returned unexpectedly. The documentation seems to indicate that I
should only be getting SQLITE_LOCKED if I'm calling sqlite3_exec
recursively writing
"dark0s dark0s" <[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
> bash-3.1# gcc -shared half.c -o half.so
> bash-3.1# sqlite3
> SQLite version 3.5.7
> Enter ".help" for instructions
> sqlite> select load_extension('/root/half.so')
Which part of "terminate each statement with a
I modified row in function:
sqlite3_result_text(ctx,(const char*)ret, 4, SQLITE_TRANSIENT);
I know that dimension is 4, but my shell don't return values for extension
function also with half.c example copied from wiki:
bash-3.1# gcc -shared half.c -o half.so
bash-3.1# sqlite3
SQLite version
Thank you for pointing out the omitJournal argument to sqlite3BtreeFactory!
That's just what I was looking for.
By forcing omitJournal to 1 in all cases (thereby always turning off
journaling), I was able to increase the total speed of my application by a
factor of 2.5 over the speed I got by
Dennis Cote wrote:
> Fred J. Stephens wrote:
>> Is there a way to list the column names in a table from the SQLite
>> command line interface? I know .schema will show them, but the
>> output seems like it would be difficult to parse so that only the column
>> names are shown.
>>
>
> See
On Sat, 12 Apr 2008 10:40:43 -0400
"P Kishor" <[EMAIL PROTECTED]> wrote:
> On 4/12/08, Amit Uttamchandani <[EMAIL PROTECTED]> wrote:
> > Hey everyone,
> >
> > Just got back into the world of SQL after being away for 5 years. This
> > time I decided to jump in with SQLite. It really has me
On Sat, 12 Apr 2008, Jay A. Kreibich wrote:
> I purchased the hardback of this book some months ago only to discover
> the PDF version some weeks later. In the end, I ended up buying them
> both.
Jay,
I have both, too. Yes, using the find function within xpdf does compensate
for the lack
On 4/12/08, Amit Uttamchandani <[EMAIL PROTECTED]> wrote:
> Hey everyone,
>
> Just got back into the world of SQL after being away for 5 years. This time
> I decided to jump in with SQLite. It really has me excited.
>
> Anyways, I have done a lot database work but I seem to have forgotten a lot
On Sat, Apr 12, 2008 at 05:23:55PM +1000, Neville Franks scratched on the wall:
> For SQLite in particular "The Definitive Guide to SQLite" by Micahel
> Owens is reasonably good. Unfortunately it has the worst index of any
> book I can recall seeing, other than some Cook Books. This makes it
>
On Fri, 11 Apr 2008, Amit Uttamchandani wrote:
> Is there a set of documents/notes that you refer to? Something that covers
> SQL and database design in general?
Amit,
I second the recommendation of Mike Owens' "The Definitive Guide to
SQLite" for detailed insight on this system. And it does
"dark0s dark0s" <[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
> The soundex function don't return results of your processing.
> My output is below:
> bash-3.1# gcc -shared labsinf.c -o inf.so
> bash-3.1# sqlite3
> SQLite version 3.5.7
> Enter ".help" for instructions
> sqlite> select
The soundex function don't return results of your processing.
My output is below:
bash-3.1# gcc -shared labsinf.c -o inf.so
bash-3.1# sqlite3
SQLite version 3.5.7
Enter ".help" for instructions
sqlite> select load_extension('/root/inf.so')
...> select inf(savio)
...>
I don't understand
For SQLite in particular "The Definitive Guide to SQLite" by Micahel
Owens is reasonably good. Unfortunately it has the worst index of any
book I can recall seeing, other than some Cook Books. This makes it
very difficult and frustrating to use as a Reference Book.
I also purchased "Beginning
On Fri, Apr 11, 2008 at 01:54:43PM -0700, Richard Klein scratched on the wall:
> Jay A. Kreibich wrote:
> >On Thu, Apr 10, 2008 at 05:58:59PM -0700, Richard Klein scratched on the
> >wall:
> >
> >>My advice would be to try it and see. If table creation takes too long,
> >>you can always remove
15 matches
Mail list logo