Re: [sqlite] System.Data.SQLite - issues

Manish Kukreti wrote: > > 1. SQLiteDataReader.GetString() method: > The method fails with "Invalid cast exception" when you try to retrieve > a number stored in a text field. > Do you have some example C# code and/or a database schema that demonstrates this issue? What is the declared data

Re: [sqlite] Vacuum command fails

My earlier email didnt went due to size limit. May be it might come later. Here is my summary What I understood after this exercise i.e executing VACUUM command is - It requires C: drive free space and not the drive where your application is running. Since PRAGMA temp_store_directory is

Re: [sqlite] Keeping a history of structured data

On 17 July 2014 21:43, Tristan Van Berkom wrote: > > Hi all, > > We've been pondering how to keep history of structured records without > storing the entirety of the structured record for each new revision, we > have some ideas on how to achieve this but I wanted to

Re: [sqlite] comma-separated string data

Hi, Say the scenario is column value = [1,2,33,45,66] u want to compare value x with the column and retrieve data then use the condition, value = 'x' OR value LIKE 'x,%' OR value LIKE '%,x,%' OR value LIKE '%,x' it should work in most of the cases (y) Thanks, Supriya -- View this message

Re: [sqlite] comma-separated string data

Hi, Say the scenario is column value = [1,2,33,45,66] u want to compare value x with the column and retrieve data then use the condition, value = 'x' OR value LIKE 'x,%' OR value LIKE '%,x,%' OR value LIKE '%,x' it should work in most of the cases (y) Thanks, Supriya -- View this message

[sqlite] [bug] Optimizer chooses suboptimal plan for correlated subqueries containing tables with zero rows

Hi, We encountered an issue in our system where we had two nearly identical subqueries in a statement, which differed only in one table (both of which had the same definition). One table had 4 rows, the other table had zero rows. The subquery with the 4-row table ran about 10,000 times

[sqlite] Copy rows in same table

Hi All, I want to copy a row in same table. How can I achieve this? Eg : Table(ID,name,place,comments) 1 ABD 121 None 2 ASD 141 None Now I want to copy the table ID 2 to new table ID 3using sqlite3 commands. -- Regards, Prashanth Anil Mascarenhas, +918904231492, Sankalp Semiconductor Pvt

Re: [sqlite] Vacuum command fails

On 2014/07/17 23:03, veeresh kumar wrote: I did google aswell :-)...I did set PRAGMA temp_store = 1 (PRAGMA temp_store = FILE). But it did not help. I get SQLITE_NOMEM error message. Might I offer one more possible (although probably not very likely) problem - I have just recently posted an

Re: [sqlite] Vacuum command fails

On 17 Jul 2014, at 10:03pm, veeresh kumar wrote: > I did google aswell :-)...I did set PRAGMA temp_store = 1 (PRAGMA temp_store > = FILE). But it did not help. I get SQLITE_NOMEM error message. What version of SQLite are you using ? The simplest way is probably to tell us

Re: [sqlite] Vacuum command fails

I did google aswell :-)...I did set PRAGMA temp_store = 1 (PRAGMA temp_store = FILE). But it did not help. I get SQLITE_NOMEM error message. Its not a space issue as I do have enough space in the hard drive. Whenver Vacuum command is executed, its using the RAM and thats were it goes out of

Re: [sqlite] Keeping a history of structured data

On 17 Jul 2014, at 8:43pm, Tristan Van Berkom wrote: > The objective is to keep a revisioned history of 'E' whenever 'E' has > changed, or any of it's 'P' counterparts have changed, ideally without > storing a duplicate row for the one 'E' and every one of its 'P's

Re: [sqlite] Vacuum command fails

On 17 Jul 2014, at 6:24pm, veeresh kumar wrote: > I tried to execute Vacuum on the sqlite database of size 14GB and it failed > with an error "out of memory". What kind of error is this ? Are you getting SQLITE_NOMEM returned from a SQLite call or is this being returned

Re: [sqlite] Vacuum command fails

Luuk wrote: >so, 0 means temp is written to disk. >Back to the the question. >How much free disk space is there? >I think you need more than 14Gb of free space if your database is 14Gb in size. >http://lmgtfy.com/?q=sqlite+vacuum+how+much+disk+space+is+needed=1 >"This means that when

Re: [sqlite] Vacuum command fails

On 17-7-2014 21:11, Roger Binns wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 17/07/14 10:42, veeresh kumar wrote: When i execute the command PRAGMA temp_store, it returned me 0. What is the ideal value that needs to be set? A quick google search would have found the answer:

[sqlite] Keeping a history of structured data

Hi all, We've been pondering how to keep history of structured records without storing the entirety of the structured record for each new revision, we have some ideas on how to achieve this but I wanted to consult this list in case we have overlooked some other strategies, and also just to see

Re: [sqlite] Vacuum command fails

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 17/07/14 10:42, veeresh kumar wrote: > When i execute the command PRAGMA temp_store, it returned me 0. What is > the ideal value that needs to be set? A quick google search would have found the answer:

Re: [sqlite] Setting boundaries in a search

On 2014/07/17 03:48, RSmith wrote: In a similar fashion I had made this system for basically loading CSV files into an SQLite DB, then running all kinds of rules on it//.. (btw: This app is freely shared if anyone needs something of the kind or fancy testing the above, just mail me) I

Re: [sqlite] Vacuum command fails

When i execute the command PRAGMA temp_store, it returned me 0. What is the ideal value that needs to be set? On Thursday, 17 July 2014 10:30 AM, Simon Slavin wrote: On 17 Jul 2014, at 6:24pm, veeresh kumar wrote: > I tried to execute Vacuum on

Re: [sqlite] An Explain Query Plan that I cannot explain

On 17 Jul 2014, at 6:34pm, Staffan Tylen wrote: > I'm unable to understand why T2 isn't using the index. Is it the fact that > the table T2 only has 2 rows so SQLite has decided that it's quicker with a > scan? Does doing an ANALYZE change anything ? Simon.

[sqlite] An Explain Query Plan that I cannot explain

I've got a view VJU covering 8 tables T1-T8. They all share a column C1 which is indexed in each table: CREATE VIEW VJU AS SELECT * FROM T1 LEFT JOIN T2 USING (C1) LEFT JOIN T3 USING (C1) LEFT JOIN T4 USING (C1) LEFT JOIN T5 USING (C1) LEFT JOIN T6 USING (C1) LEFT JOIN T7 USING (C1) LEFT JOIN T8

Re: [sqlite] Vacuum command fails

On 17 Jul 2014, at 6:24pm, veeresh kumar wrote: > I tried to execute Vacuum on the sqlite database of size 14GB and it failed > with an error "out of memory". I was under the impression that it copies the > database file and then performs vacuum on that file. Here it looks

[sqlite] Vacuum command fails

I tried to execute Vacuum on the sqlite database of size 14GB and it failed with an error "out of memory". I was under the impression that it copies the database file and then performs vacuum on that file. Here it looks like its using RAM. Appreciate your inputs from the experts.

Re: [sqlite] sqlite db transfer

Hi Sky, The read-only mode for opening the database is simply you telling the sqlite engine that you do not intend to write to this database and so it doesn't try to acquire write-locks on it during the life of that connection, and your connection cannot make changes to it in any way (even if

Re: [sqlite] sqlite db transfer

thank you.. how can i use sqlite_db_readonly function.. On Thu, Jul 17, 2014 at 5:40 PM, Sky Meena wrote: > i will explain.. i created a sqlite db.. now i should tranfer it also > transfered.. while opening a db it should ask password.. for that while > creating db i

Re: [sqlite] sqlite db transfer

i will explain.. i created a sqlite db.. now i should tranfer it also transfered.. while opening a db it should ask password.. for that while creating db i should enable some password or read only mode.. On Thu, Jul 17, 2014 at 4:27 PM, Kees Nuyt wrote: > On Thu, 17 Jul 2014

Re: [sqlite] Setting boundaries in a search

On Thu, 17 Jul 2014 13:06:36 +0530, Sky Meena wrote: > how to set a password to open a sqlite db in sqlite browser Answered in a different thread 2 minutes ago. -- Regards, Kees Nuyt >On Thu, Jul 17, 2014 at 7:18 AM, RSmith wrote: > >> >> On

Re: [sqlite] sqlite db transfer

On Thu, 17 Jul 2014 15:17:07 +0530, Sky Meena wrote: > i sent a sqlite db from server to client using c program .. in this how i > set a password for the db to open in sqlite browser... In short: you can't. SQLite does not implement SQL access control (GRANT/REVOKE).

Re: [sqlite] sqlite db transfer

On 17 Jul 2014, at 10:47am, Sky Meena wrote: > i sent a sqlite db from server to client using c program SQLite does not involve a server. It runs on one computer and takes instructions only from that computer. > .. in this how i > set a password for the db to open in

Re: [sqlite] sqlite & multi process usage

On 17 Jul 2014, at 10:10am, Micka wrote: > Well, > > All of my process are using Mutex to protect sqlite from concurrent access. > > That why I don't understand why I get SQLITE_BUSY error . > > Micka, > > > On Tue, Jul 8, 2014 at 11:44 PM, Simon Slavin

Re: [sqlite] sqlite db transfer

i sent a sqlite db from server to client using c program .. in this how i set a password for the db to open in sqlite browser... On Fri, May 9, 2014 at 6:05 PM, Simon Slavin wrote: > > On 9 May 2014, at 1:23pm, Sky Meena wrote: > > > i working in

Re: [sqlite] sqlite & multi process usage

Well, All of my process are using Mutex to protect sqlite from concurrent access. That why I don't understand why I get SQLITE_BUSY error . Micka, On Tue, Jul 8, 2014 at 11:44 PM, Simon Slavin wrote: > > On 8 Jul 2014, at 8:39pm, Micka wrote: >

Re: [sqlite] Setting boundaries in a search

how to set a password to open a sqlite db in sqlite browser On Thu, Jul 17, 2014 at 7:18 AM, RSmith wrote: > > On 2014/07/16 14:55, Rob Willett wrote: > > I’ll second what Simon says, I use the very same technique for a table >> with 4M+ records in and its so fast I

[sqlite] (no subject)

http://recycling-it.com/wp-content/themes/health.google.php ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users