Re: [sqlite] corruption problem with attached macintosh database

> >Have you tried with this turned on: > > http://www.sqlite.org/compile.html#enable_locking_style Enabling this causes link errors under my version of OSX, due to the absence of "gethistuuid". I see some traffic on the web that suggests this comes in a later OSX. (I use 10.4.11) Also, this

Re: [sqlite] Update problem in use C/C++ interface

> and i'm sure there is a record with the ID bind for the third parameter. You should be also sure that this record contains ID as an integer value, not as text value. Without affinity integer will never be equal to text. Pavel 2010/3/24 王志刚 : > ??? wrote: >> Hi, I

Re: [sqlite] locking across the network...

http://www.sqlite.org/whentouse.html "...file locking logic of many network filesystems implementation contains bugs (on both Unix and Windows). If file locking does not work like it should, it might be possible for two or more client programs to modify the same part

Re: [sqlite] Available alternatives to syntax diagrams in documentation

On Fri, Mar 26, 2010 at 08:37:23PM +0100, Kees Nuyt scratched on the wall: > On Thu, 25 Mar 2010 18:38:49 -0500, P Kishor > wrote: > > >I must be in an alternate universe. So, I have turned off images in my > >browser and I am looking at

Re: [sqlite] Available alternatives to syntax diagrams in documentation

On Thu, 25 Mar 2010 18:38:49 -0500, P Kishor wrote: >I must be in an alternate universe. So, I have turned off images in my >browser and I am looking at http://www.sqlite.org/lang_delete.html You are trying to find a formal syntax description in text. It's not there, but

Re: [sqlite] Android database corruption

Thanks very much for the quick response! Unfortunately, the android SQLiteDatabase class deletes the database when it hits this, so it doesn't give me a chance to do that. However I do have a channel to the android db developers, so I will forward this onto them, and hopefully they can do

Re: [sqlite] Android database corruption

On Mar 26, 2010, at 12:10 PM, Shane Harrelson wrote: > On Fri, Mar 26, 2010 at 11:38 AM, cliff 2 > wrote: > >> >> Hi, >> >> Hopefully someone here can help where the android guys haven't been >> able >> to. >> We are having an issue with our sqlite database

Re: [sqlite] Android database corruption

On Fri, Mar 26, 2010 at 11:38 AM, cliff 2 wrote: > > Hi, > > Hopefully someone here can help where the android guys haven't been able > to. > We are having an issue with our sqlite database running on the android > platform. We are accessing the db from the sdcard on

[sqlite] Android database corruption

Hi, Hopefully someone here can help where the android guys haven't been able to. We are having an issue with our sqlite database running on the android platform. We are accessing the db from the sdcard on an android phone running android 2.1. It works perfectly 99% of the time, but every now

Re: [sqlite] corruption problem with attached macintosh database

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dave Dyer wrote: > whatever is default. I compile mu own sqlite static libraries, but > I don't customize the settings. Have you tried with this turned on: http://www.sqlite.org/compile.html#enable_locking_style Roger -BEGIN PGP

[sqlite] locking across the network...

I am currently using SQLite in my client/server application: Server: Apache Web Server -- the sole process that access the SQLite databases Client A: Admin Client to configure the server, there is only 1 instance of this client. Client B: Kiosk Client, there is 1 or more of these, some have over

Re: [sqlite] sqlite3_open16_v2

On Mar 26, 2010, at 8:28 AM, NSRT Mail account. wrote: > Looking at, http://www.sqlite.org/c3ref/open.html it seems that a > function sqlite3_open16_v2() is inexplicably missing. Is there a > reason for this? > An sqlite3_open16_v2() would add no new capabilities. The sqlite3_open16()

Re: [sqlite] Get a specific sequence of rows...

On Fri, Mar 26, 2010 at 1:25 PM, Igor Tandetnik wrote: > Fredrik Karlsson wrote: >> This is of course another solution. I guess, coming from R, I was >> looking for a substitute for th %in% operator (or the MySQL IN >> operator as it turns out, now that I've Googled this some

Re: [sqlite] Get a specific sequence of rows...

On Fri, Mar 26, 2010 at 5:00 AM, Fredrik Karlsson wrote: > Hi, > > I have a list of id:s stored in a field. I would now like to get some > information from a table by these id:s, but exactly in this order. So, > if I have a table > > 1 One > 2 Two > 3 Three > > and the

Re: [sqlite] Running UPDATE on a large table uses too much RAM

On Mar 26, 2010, at 8:11 AM, NSRT Mail account. wrote: > I have a database with a single table. The database is 23922826240 > bytes. The table has 2147483685 rows in it. > > Running: UPDATE t SET v=1; makes my application start to use all > available RAM, then swap, and is finally killed by

[sqlite] sqlite3_open16_v2

Looking at, http://www.sqlite.org/c3ref/open.html it seems that a function sqlite3_open16_v2() is inexplicably missing. Is there a reason for this? ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Get a specific sequence of rows...

Fredrik Karlsson wrote: > This is of course another solution. I guess, coming from R, I was > looking for a substitute for th %in% operator (or the MySQL IN > operator as it turns out, now that I've Googled this some more) but a > temp table would also do the trick I guess. Well, you can generate

Re: [sqlite] Get a specific sequence of rows...

On Fri, Mar 26, 2010 at 12:22 PM, Simon Slavin wrote: > > On 26 Mar 2010, at 9:00am, Fredrik Karlsson wrote: > >> I have a list of id:s stored in a field. I would now like to get some >> information from a table by these id:s, but exactly in this order. So, >> if I have a

[sqlite] Running UPDATE on a large table uses too much RAM

I have a database with a single table. The database is 23922826240 bytes. The table has 2147483685 rows in it. Running: UPDATE t SET v=1; makes my application start to use all available RAM, then swap, and is finally killed by the OS (I do not have 23GB of free RAM+swap). Should running an

Re: [sqlite] sqlite performance with large and multiple attached databases

On 26 Mar 2010, at 10:47am, Akbar Syed wrote: > Unfortunately, my application restricts me to use independent > databases than to a single database > as each database exists on a different device and contains the info of > that device in the database. > Multiple devices are allowed to connect

Re: [sqlite] Issue "sqlite database locked"

On Mar 26, 2010, at 12:40 AM, wrote: > Hi, > > > I have downloaded the sqlite from the link > http://www.sqlite.org/download.html > version sqlite-3.6.23.so.gz sqlite-3.6.23.so.gz> (220.62 KiB). I am using

[sqlite] sqlite performance with large and multiple attached databases

Hello, >>If you want to improve utilization memory, just put everything in one >> database. Each attached database in each connection has its own cache. >> With that many data sources you're going to get a very uneven distribution >> of cache utilization, and very high worst-case usage.

[sqlite] Issue "sqlite database locked"

Hi, I have downloaded the sqlite from the link http://www.sqlite.org/download.html version sqlite-3.6.23.so.gz (220.62 KiB). I am using fedora -9-i386. Have mounted a Shared drive on my pc to the fedora image.I copied the extracted sqlite db and

Re: [sqlite] Get a specific sequence of rows...

On 26 Mar 2010, at 9:00am, Fredrik Karlsson wrote: > I have a list of id:s stored in a field. I would now like to get some > information from a table by these id:s, but exactly in this order. So, > if I have a table > > 1 One > 2 Two > 3 Three > > and the sequence "3,1,2" stored somewhere, how

Re: [sqlite] Get a specific sequence of rows...

On Fri, 2010-03-26 at 10:00 +0100, Fredrik Karlsson wrote: > Hi, > > I have a list of id:s stored in a field. I would now like to get some > information from a table by these id:s, but exactly in this order. So, > if I have a table > > 1 One > 2 Two > 3 Three > > and the sequence "3,1,2" stored

Re: [sqlite] "out of memory" in ANALYZE with SQLITE_ENABLE_STAT2

Shane Harrelson wrote: > Thanks for reporting this. It should be corrected by this fix: > > http://www.sqlite.org/src/info/cbd054fa6b Thank you. It is indeed fixed. Martin -- Dr. Martin Wilck PRIMERGY System Software Engineer x86 Server Engineering Fujitsu Technology Solutions GmbH

[sqlite] Get a specific sequence of rows...

Hi, I have a list of id:s stored in a field. I would now like to get some information from a table by these id:s, but exactly in this order. So, if I have a table 1 One 2 Two 3 Three and the sequence "3,1,2" stored somewhere, how do I get a neat list like Three One Two ? I I can see a

Re: [sqlite] SQLite on 64-bit Windows O/S

On Wed, Mar 17, 2010 at 5:59 PM, Simon Slavin wrote: > > On 17 Mar 2010, at 4:04am, Roger Binns wrote: > >> Rashed Iqbal wrote: >>> Has anyone compiled and used SQLite on 64-bit Windows? Are there any >>> code changes that would be needed before compiling? Would the same DB