Re: [sqlite] SQLite version 3.6.14

On Wed, May 6, 2009 at 7:36 PM, D. Richard Hipp wrote: > SQLite version 3.6.14 is now available on the SQLite website > >     http://www.sqlite.org/ > > Version 3.6.14 contains performance enhances in the btree and pager > subsystems.  In addition, the query optimizer now knows how to take > advan

Re: [sqlite] Performance of in-memory database and memory journal

On May 7, 2009, at 11:40 AM, Pavel Ivanov wrote: >> At the top of file memjournal.c there is a #define called >> "JOURNAL_CHUNKSIZE" >> that sets the size of the allocations used to store the in-memory >> journal. > > I was interested more in the way to do it without recompilation. > So there's n

Re: [sqlite] Performance of in-memory database and memory journal

> At the top of file memjournal.c there is a #define called > "JOURNAL_CHUNKSIZE" > that sets the size of the allocations used to store the in-memory > journal. I was interested more in the way to do it without recompilation. So there's no such way - that's ok for now, I can adapt myself to it. >

Re: [sqlite] Performance of in-memory database and memory journal

On May 7, 2009, at 3:27 AM, Pavel Ivanov wrote: > Hi, all! > > Recently I've discovered that my application works faster if it uses > journal_mode = PERSIST instead of MEMORY. After running under > callgrind I've found that with journal_mode = MEMORY application > spends a lot of time inside mall

[sqlite] unsubcribe

New Email addresses available on Yahoo! Get the Email name you've always wanted on the new @ymail and @rocketmail. Hurry before someone else does! http://mail.promotions.yahoo.com/newdomains/aa/ ___ sqlite-users mailing list sqlite-users@sqlite

[sqlite] SQLite version 3.6.14

SQLite version 3.6.14 is now available on the SQLite website http://www.sqlite.org/ Version 3.6.14 contains performance enhances in the btree and pager subsystems. In addition, the query optimizer now knows how to take advantage of OR and IN operators on columns of a virtual table. A n

Re: [sqlite] Optimizing concurrency with sql query - locks?

Many thanks to all of you for your responses. Helped a great deal. I think I'm experiencing a "duh" moment. :) -rosemary. On May 6, 2009, at 10:34 AM, Olaf Schmidt wrote: > > "Rosemary Alles" schrieb im > Newsbeitrag news:AF79A266-B697-4924- > b304-2b1feccba...@ipac.caltech.edu... > >> Run o

[sqlite] group_concat bug

The following example demonstrates what seems to be a bug in group_concat. With the latest version of CVS: CREATE TABLE example (id INTEGER, x TEXT); CREATE TABLE table2 (key TEXT, x TEXT); CREATE TABLE list (key TEXT, value TEXT); INSERT INTO example VALUES (1, "a"); INSERT INTO table2 VALUES

Re: [sqlite] Optimizing concurrency with sql query - locks?

Sqlite is an ACID database - it ensures that data is written to disk, so a database in memory still shares a single disk resource. Jim Wilcoxson wrote: > I'm not sure what you are considering a massive slowdown, but let's > assume that the entire database fits into memory and disk I/O isn't > the

[sqlite] need help, sqlite produces errors

at first let me say: this doesn't run on my pc, but on a Popcorn-Hour A110 Mediaserver. That is a problem, because i can't predict the behaviour of sqlite or php and i can't get real error message (Just one general Message which occurs for all things). i have a function that scans a folder which

Re: [sqlite] sqlite in shell loop

On Wed, 6 May 2009 23:24:00 +0200, Daniel Wolny wrote: >2009/5/6 Kees Nuyt : >> On Wed, 6 May 2009 23:01:24 +0200, Daniel Wolny >> wrote: >> It should be possible, sqlite sends its output to stdout, so >> it works like any other unix utility. >> >> Just give it a go. Experiment. >> And enjoy. >>

Re: [sqlite] sqlite in shell loop

You should do for i in $HANDLER Notice: NO quotes. Though be careful - it will not work if row contains text field with spaces. Pavel On Wed, May 6, 2009 at 5:24 PM, Daniel Wolny wrote: > 2009/5/6 Kees Nuyt : >> On Wed, 6 May 2009 23:01:24 +0200, Daniel Wolny >> wrote: >> It should be possibl

Re: [sqlite] Sqlite3 tables hidden from program to program

rajyalakshmi bommaraju wrote: > Hi, > I started using sqlite3 recently on Ubuntu. I came across an issue with the > database that, I was able to create database and table from commandline > successfully, I also inserted couple of rows, no problem. When I tried to > open database from C program,

Re: [sqlite] Sqlite3 tables hidden from program to program

On Wed, 6 May 2009 14:13:46 -0700 (PDT), rajyalakshmi bommaraju wrote: >Hi, > I started using sqlite3 recently on Ubuntu. I came > across an issue with the database that, I was able to > create database and table from commandline > successfully, I also inserted couple of rows, no > problem. When

Re: [sqlite] sqlite in shell loop

2009/5/6 Kees Nuyt : > On Wed, 6 May 2009 23:01:24 +0200, Daniel Wolny > wrote: > It should be possible, sqlite sends its output to stdout, so > it works like any other unix utility. > > Just give it a go. Experiment. > And enjoy. > It doesn't work to me: #!/bin/sh HANDLER=`sqlite -noheader /ro

Re: [sqlite] sqlite in shell loop

On Wed, 6 May 2009 23:01:24 +0200, Daniel Wolny wrote: >Hi, >Is possible to use sqlite in shell for loop? > >eg. >#!/bin/sh > >for i in `sqlite db "SELECT smt FROM db"` >do > echo "$i" DUPA >done > >I want to act sqlite like any other command in for loop, i mean one >record from db as a one

[sqlite] Sqlite3 tables hidden from program to program

Hi, I started using sqlite3 recently on Ubuntu. I came across an issue with the database that, I was able to create database and table from commandline successfully, I also inserted couple of rows, no problem. When I tried to open database from C program, It is fine but I cant access the table.

[sqlite] Sqlite3 tables hidden from program to program

Hi, I started using sqlite3 recently on Ubuntu. I came across an issue with the database that, I was able to create database and table from commandline successfully, I also inserted couple of rows, no problem. When I tried to open database from C program, It is fine but I cant access the table.

[sqlite] Sqlite3 tables hidden from program to program

Hi, I started using sqlite3 recently on Ubuntu. I came across an issue with the database that, I was able to create database and table from commandline successfully, I also inserted couple of rows, no problem. When I tried to open database from C program, It is fine but I cant access the table.

[sqlite] Import xml into SQLite

I am looking for a nice GUI for admin of SQLite database - on Mac OS. I tried FireFox SQLmanager with no luck - any other suggestions ? I need an easy way to import large XML into a new table. -- *Ben Marchbanks* ___ sqlite-users mailing list sqlite-us

[sqlite] sqlite in shell loop

Hi, Is possible to use sqlite in shell for loop? eg. #!/bin/sh for i in `sqlite db "SELECT smt FROM db"` do echo "$i" DUPA done I want to act sqlite like any other command in for loop, i mean one record from db as a one iteration, above will display: first1 first2 second1 second2 DUPA I

Re: [sqlite] Increasing output

2009/5/6 Kees Nuyt : > In the sqlite command line tool: > > .width 10 13 30 3 > Thanks. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Performance of in-memory database and memory journal

Hi, all! Recently I've discovered that my application works faster if it uses journal_mode = PERSIST instead of MEMORY. After running under callgrind I've found that with journal_mode = MEMORY application spends a lot of time inside malloc() which is called from memjrnlWrite(). Is there a way to o

Re: [sqlite] Increasing output

On Wed, 6 May 2009 19:13:29 +0200, Daniel Wolny wrote: >Hi, >Is possible to increase output of -column? > >1   nightwalker  nightwalker.szelka.net  1 >3   nightwalker  stolezka.pl 1 >4   nightwalker  czteroipolkilogramowya  1 >259 nightwalker  satan.edu

Re: [sqlite] sqlite3 source code modification

On Wed, 6 May 2009 20:59:06 +1000, Maria wrote: >Hi, I would like to modify sqlite source code. >Before, start of modification, I wanted to print 'hello world!' message from >'sqlite3_initialize()' routine. > >I've downloaded sqlite-amalgamation-3.6.13.tar.gz >

Re: [sqlite] SQL error: database disk image is malformed

On Wed, 6 May 2009 00:40:22 -0500, "Jay A. Kreibich" wrote: >On Tue, May 05, 2009 at 11:46:38PM +0200, Kees Nuyt scratched on the wall: >> On Tue, 5 May 2009 16:55:42 -0400, Pavel Ivanov >> wrote: >> >> >Is it just me or somebody else is >> >seeing too that the sql statement >> > "select blobid

Re: [sqlite] Optimizing concurrency with sql query - locks?

"Rosemary Alles" schrieb im Newsbeitrag news:af79a266-b697-4924-b304-2b1feccba...@ipac.caltech.edu... > Run on a single processor, the following query is quite fast: > ...snip... > When concurrency is introduced (simply running the query on several > processors against the same database - say 30

Re: [sqlite] How to check if a character is alphanumeric?

On May 6, 2009, at 1:24 PM, paulmjpe...@gmail.com wrote: > Is there any SQL command to check if the first character in a text > field is > alphanumeric How about: x GLOB '[0-9a-zA-Z]*' where x is the string to be tested. D. Richard Hipp d...@hwaci.com

[sqlite] How to check if a character is alphanumeric?

Is there any SQL command to check if the first character in a text field is alphanumeric Or, more broadly to see if a character is alphanumeric? Something similar to IsAlphanumeric() ? Thanks. Paul ___ sqlite-users mailing list sqlite-users@s

[sqlite] Increasing output

Hi, Is possible to increase output of -column? 1   nightwalker  nightwalker.szelka.net  1 3   nightwalker  stolezka.pl 1 4   nightwalker  czteroipolkilogramowya  1 259 nightwalker  satan.edu.pl    1 260 nightwalker  prison.net.pl 

Re: [sqlite] Lets be realistic about errors

Sam Carleton wrote: >> Will SQLite return errors on a regular basis >> if one thread or process tries to access the database when another >> thread/process already has a lock or will it handle such a situation >> normally and only in extreme cases do I need to worry about it See sqlite3_busy_hand

Re: [sqlite] Optimizing concurrency with sql query - locks?

I'm not sure what you are considering a massive slowdown, but let's assume that the entire database fits into memory and disk I/O isn't the bottleneck. You said you're running 300 instances of the query on several processors. If several means 3 CPUs, then in a perfect world, running 300 instances

[sqlite] Lets be realistic about errors

I have completed all the back end development that is using SQLite, minus on issue: error handling I am using SQLite in Axis2/C web services on Windows and later on OSX. On Windows Apache starts up lots of threads and eventually spawns more processes, I think in the *NIX world it simply spa

Re: [sqlite] Optimizing concurrency with sql query - locks?

Igor Tandetnik wrote: > "Rosemary Alles" wrote > in message news:af79a266-b697-4924-b304-2b1feccba...@ipac.caltech.edu > >> Run on a single processor, the following query is quite fast: >> >> When concurrency is introduced (simply running the query on several >> processors against the same data

Re: [sqlite] Database Corruption

D. Richard Hipp wrote: > > > > Thank you for sending me the database file that is giving you problems. > > This is not a bug in SQLite. It is reporting "database disk image is > malformed" errors because, in fact, the original database disk (the > one you sent me) is malformed. You can

Re: [sqlite] Optimizing concurrency with sql query - locks?

"Rosemary Alles" wrote in message news:af79a266-b697-4924-b304-2b1feccba...@ipac.caltech.edu > Run on a single processor, the following query is quite fast: > > When concurrency is introduced (simply running the query on several > processors against the same database - say 300 instances of it) cau

Re: [sqlite] sqlite3 source code modification

On May 6, 2009, at 7:03 AM, Maria wrote: > thanks for quick reply. > >> ./sqlite3 test.db > it's working. does it mean that when I use '>sqlite3 test.db', it's > not > working from the source code?? When you type just "sqlite3", the shell searches the directories on your PATH environment var

Re: [sqlite] sqlite3 source code modification

thanks for quick reply. > ./sqlite3 test.db it's working. does it mean that when I use '>sqlite3 test.db', it's not working from the source code?? By the way, thanks so much. On Wed, May 6, 2009 at 8:58 PM, D. Richard Hipp wrote: > > On May 6, 2009, at 6:50 AM, Maria wrote: > > > Hi, I would li

[sqlite] sqlite3 source code modification

Hi, I would like to modify sqlite source code. Before, start of modification, I wanted to print 'hello world!' message from 'sqlite3_initialize()' routine. I've downloaded sqlite-amalgamation-3.6.13.tar.gz on ubuntu system. then, I followed

Re: [sqlite] sqlite3 source code modification

On May 6, 2009, at 6:50 AM, Maria wrote: > Hi, I would like to modify sqlite source code. > Before, start of modification, I wanted to print 'hello world!' > message from > 'sqlite3_initialize()' routine. > > I've downloaded sqlite-amalgamation-3.6.13.tar.gz >

[sqlite] sqlite3 source code modification

Hi, I would like to modify sqlite source code. Before, start of modification, I wanted to print 'hello world!' message from 'sqlite3_initialize()' routine. I've downloaded sqlite-amalgamation-3.6.13.tar.gz on ubuntu system. then, I followed

[sqlite] user_version and .dump

I noticed that sqlite3 command doesn't dump the user_version PRAGMA, though that would arguably be necessary for the correct work of the application (or it wouldn't have set it at all, I guess). Was it simply forgot or is there a specific reason not to dump that? -- Lapo Luchini - http://lapo.it