Re: [sqlite] FW: Questions about your "Performance Matters" talk re SQLite

Keith Medcalf Sent Saturday, January 04, 2020 3:29 PM >So I conclude that SERIALIZED/MULTITHREAD makes very little difference >and that MEMSTATUS ON/OFF makes a huge difference. Since the That's a potentially very useful observation! Is any of this available to JDBC users? Erik -

Re: [sqlite] FW: Questions about your "Performance Matters" talk re SQLite

out anticipated traffic volume. >-Original Message- >From: sqlite-users On >Behalf Of Doug >Sent: Saturday, 4 January, 2020 10:42 >To: 'SQLite mailing list' >Subject: Re: [sqlite] FW: Questions about your "Performance Matters" talk >re SQLite >

Re: [sqlite] FW: Questions about your "Performance Matters" talk re SQLite

> -Original Message- > From: sqlite-users > On Behalf Of J Decker > Sent: Saturday, January 04, 2020 4:11 AM > > Could wish there was a way to > pause execution without giving up execution context... What about? for (i=1000; i--; i>0); ___ sql

Re: [sqlite] FW: Questions about your "Performance Matters" talk re SQLite

; To: SQLite mailing list > Cc: em...@cs.umass.edu; curtsin...@grinnell.edu > Subject: Re: [sqlite] FW: Questions about your "Performance > Matters" talk re SQLite > > > > On Jan 2, 2020, at 11:54 AM, Doug wrote: > > > > I know there has been a lot of t

Re: [sqlite] FW: Questions about your "Performance Matters" talk re SQLite

On Sat, Jan 4, 2020 at 2:59 AM Howard Chu wrote: > Keith Medcalf wrote: > > > > Indeed turning off memstatus leads to a 500% (from ~3s to ~0.5s) > performance increase. > > Changing the threading mode or the indirection level of the mutexes > calls seems to have no significant effect. > > > Goes

Re: [sqlite] FW: Questions about your "Performance Matters" talk re SQLite

Keith Medcalf wrote: > > Indeed turning off memstatus leads to a 500% (from ~3s to ~0.5s) performance > increase. > Changing the threading mode or the indirection level of the mutexes calls > seems to have no significant effect. > Goes to show - publishing benchmark results without investigat

Re: [sqlite] FW: Questions about your "Performance Matters" talk re SQLite

> On Jan 2, 2020, at 11:54 AM, Doug wrote: > > I know there has been a lot of talk about what can and cannot be done with > the C calling interface because of compatibility issues and the myriad set of > wrappers on various forms. I’m having a hard time letting go of a possible > 25% performa

Re: [sqlite] FW: Questions about your "Performance Matters" talk re SQLite

Well, I told you I'm getting SQLITE_MISUSE so that kinda answers your side question? I am only interested in this topic for the performance gain so quoted. I need to create a personal test case(my use model) to verify these statements. Querying the config state is helpful for a dll wrapped database

Re: [sqlite] FW: Questions about your "Performance Matters" talk re SQLite

On 1/3/20, sky5w...@gmail.com wrote: > Is there a query function for these and other config settings? > I see no sqlite3_config_get() in sqlite3.h. There is no query function for the SQLITE_CONFIG_MEMSTATUS setting. -- D. Richard Hipp d...@sqlite.org _

Re: [sqlite] FW: Questions about your "Performance Matters" talk re SQLite

On Friday, 3 January, 2020 11:32, sky5w...@gmail.com wrote: > Is there a query function for these and other config settings? > I see no sqlite3_config_get() in sqlite3.h. No. There are config options to get specific config data where that might be useful. Otherwise, you simply set the config

Re: [sqlite] FW: Questions about your "Performance Matters" talk re SQLite

Is there a query function for these and other config settings? I see no sqlite3_config_get() in sqlite3.h. On Fri, Jan 3, 2020 at 11:36 AM Keith Medcalf wrote: > On Friday, 3 January, 2020 09:30, sky5w...@gmail.com wrote: > > >I get SQLITE_MISUSE when attempting > >sqlite3_config(SQLITE_CONFIG_M

Re: [sqlite] FW: Questions about your "Performance Matters" talk re SQLite

> Indeed turning off memstatus leads to a 500% (from ~3s to ~0.5s) performance increase. > Changing the threading mode or the indirection level of the mutexes calls seems to have no significant effect. That is quite significant. Looking at the code, it seems the mutex requirement is mostly for the

Re: [sqlite] FW: Questions about your "Performance Matters" talk re SQLite

On Friday, 3 January, 2020 09:30, sky5w...@gmail.com wrote: >I get SQLITE_MISUSE when attempting >sqlite3_config(SQLITE_CONFIG_MEMSTATUS, 0); >immediately after opening a db connection? >My connection has THREADSAFE = 1. That is correct. You must configure the library before it is initialized, n

Re: [sqlite] FW: Questions about your "Performance Matters" talk re SQLite

Original Message- > >From: sqlite-users On > >Behalf Of Richard Hipp > >Sent: Thursday, 2 January, 2020 16:00 > >To: SQLite mailing list > >Subject: Re: [sqlite] FW: Questions about your "Performance Matters" talk > >re SQLite > > > >O

Re: [sqlite] FW: Questions about your "Performance Matters" talk re SQLite

about anticipated traffic volume. >-Original Message- >From: sqlite-users On >Behalf Of Richard Hipp >Sent: Thursday, 2 January, 2020 16:00 >To: SQLite mailing list >Subject: Re: [sqlite] FW: Questions about your "Performance Matters" talk >re SQLite > >O

Re: [sqlite] FW: Questions about your "Performance Matters" talk re SQLite

On 1/2/20, Barry Smith wrote: > One thing that really stands is “creates 64 threads that operate on > independent tables in the sqlite database, performing operations that should > be almost entirely independent.” > Looking at the main.c file (https://github.com/plasma-umass/coz/blob/master/bench

Re: [sqlite] FW: Questions about your "Performance Matters" talk re SQLite

One thing that really stands is “creates 64 threads that operate on independent tables in the sqlite database, performing operations that should be almost entirely independent.” But that’s not how SQLite works - at least not when writing data. SQLite takes a lock on the entire database, there i

[sqlite] FW: Questions about your "Performance Matters" talk re SQLite

I asked for some information from Emery Berger about his video talk on performance where he said they got a 25% improvement in SQLite performance. Here is the reply I got back. I know there has been a lot of talk about what can and cannot be done with the C calling interface because of compa

Re: [sqlite] FW: Why aren't there date/time parsing built-in functions in SQLite

t;-Original Message- >From: sqlite-users On Behalf >Of Dominique Devienne >Sent: Tuesday, 10 September, 2019 05:54 >To: SQLite mailing list >Subject: Re: [sqlite] FW: Why aren't there date/time parsing built-in >functions in SQLite > >On Tue, Sep 10, 2019 at 1:

Re: [sqlite] FW: Why aren't there date/time parsing built-in functions in SQLite

Dominique Devienne, on Tuesday, September 10, 2019 07:53 AM, wrote... > > As DRH mentioned recently about a different piece of doc, I suspect that > doc hasn't been updated in years, Is that a hint? :-) josé ___ sqlite-users mailing list sqlite-users@m

Re: [sqlite] FW: Why aren't there date/time parsing built-in functions in SQLite

On Tue, Sep 10, 2019 at 1:27 PM Keith Medcalf wrote: > Also, note that you have to use the 'unixepoch' modifier with the time > function so that it knows the value is seconds, not days, since floats are by default days and integers are by default > seconds. [...] In my quick reading of the doc

[sqlite] FW: Why aren't there date/time parsing built-in functions in SQLite

Also, note that you have to use the 'unixepoch' modifier with the time function so that it knows the value is seconds, not days, since floats are by default days and integers are by default seconds. The 'unixepoch' modifier tells the internal datetime functions that the provided value is relat

[sqlite] FW: Problem building DLL on Windows - no exported symbols

Forwarded for documentation purposes in case someone else has the same question ... -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. -Original Message- From: Keith Medcalf Sent: Wednesday, 28 August, 2019 11:57 To:

[sqlite] Fw: multi-multi join/bridge table, table creation questions

Sent with [ProtonMail](https://protonmail.com) Secure Email. ‐‐‐ Original Message ‐‐‐ On Wednesday, August 14, 2019 8:54 AM, dboland9 wrote: > I'm doing a Python app (not that the language really matters - just for > context) that uses SQLite to store data. I have a many-to-many (MTM)

Re: [sqlite] FW: [sqlite-announce] Version 3.29.0

On 7/11/19, David Raymond wrote: > I don't think I'd ever seen the quirks page > (https://sqlite.org/quirks.html) before. Is that new-ish? It's been around for a little more than a year. See https://www.sqlite.org/docsrc/finfo?ss=c&name=pages%2Fquirks.in -- D. Richard Hipp d...@sqlite.org _

[sqlite] FW: [sqlite-announce] Version 3.29.0

And there was great rejoicing: "1. Added the SQLITE_DBCONFIG_DQS_DML and SQLITE_DBCONFIG_DQS_DDL actions to sqlite3_db_config() for activating and deactivating the double-quoted string literal misfeature. Both default to "on" for legacy compatibility, but developers are encouraged to turn them

[sqlite] Fw: Sqlite Crash in sqlite3DbMallocRawNN.

sqlite-users@mailinglists.sqlite.org From: Hegde, Deepakakumar (D.) Sent: Tuesday, November 13, 2018 3:48 PM To: 'SQLite mailing list'; General Discussion of SQLite Database Subject: Sqlite Crash in sqlite3DbMallocRawNN. Hi All, We are facing a problem in whic

[sqlite] FW: [sqlite-announce] SQLite version 3.22.0

You guys put into the default CLI the Ctrl-C stopping the statement but staying in the session behavior. Sweet! -Original Message- From: sqlite-announce [mailto:sqlite-announce-boun...@sqlite.org] On Behalf Of D.Richard Hipp Sent: Monday, January 22, 2018 3:48 PM To: sqlite-annou...@ma

Re: [sqlite] FW: PRAGMA journal_size_limit prevents -wal growth or only size outside a transaction?

On 09/12/2017 09:24 AM, Joe Mistachkin wrote: -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Howard Kapustein Sent: Monday, September 11, 2017 2:53 PM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] PRAGMA journal_si

[sqlite] Fw: how are you?

Hi friend! I've read an article recently nd it reminded me of you, please read it here and tell me your thoughts Good wishes, ronny.dierckx ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

[sqlite] Fw: new message

Hello! You have a new message, please read james.ander at tiscali.co.uk

[sqlite] Fw: new message

Hello! You have a new message, please read james.ander at tiscali.co.uk

[sqlite] Fw: new important message

Hello! New message, please read james.ander at tiscali.co.uk

[sqlite] Fw: new important message

Hello! New message, please read n7yg at n7yg.com

[sqlite] Fw: new important message

Hello! New message, please read james.ander at tiscali.co.uk

[sqlite] Fw: new message

Hey! Open message ronny.dierckx at telenet.be

[sqlite] Fw: important message

Hello! New message, please read ronny.dierckx at telenet.be

[sqlite] Fw: important message

Hello! New message, please read ronny.dierckx at telenet.be

[sqlite] Fw: new message

Hello! New message, please read ronny.dierckx at telenet.be

[sqlite] Fw: very important message

Hello! New message, please read ronny.dierckx at telenet.be

[sqlite] Fw: new message

Hello! New message, please read ronny.dierckx at telenet.be

[sqlite] Fw: new message

Hello! New message, please read ronny.dierckx at telenet.be

[sqlite] Fw: SQLlite with Gui4Cli

I apologize! I sent this (very incomplete) question to the wrong forum late at night after some very frustrating hours searching for a solution! Please ignore it. I found my answer on the Gui4Cli site (SQL3.dll) and can now hopefully proceed to produce Gui4Cli apps using a sqlite3 database. I

[sqlite] FW: SQLite 4 compilation errors in Windows

I have recently downloaded SQLite4 sources and successfully produced both SQLite4 binary and SQLlite4.c/h sources for Ubuntu 15.04 using gcc 4.9.2. I used the following sources http://www.sqlite.org/src4/vinfo?name=90c09b04513a4087 Howe

[sqlite] FW: SQLite (1.0.97) access via LAN

Takashi Fukuda wrote: > > string dataFile = "PC-Name\\C\\FolderName\\data.db > " ; > > // > > // For x32 target compilation with System.Data.SQLite-x32-1.0.97.dll (.NET4) > > // The application works fine. > > // > > // For x64 target compilation with System.Data.SQLite-x64-1.0.97.dll

[sqlite] FW: SQLite (1.0.97) access via LAN

What happens if you map a network drive to \\PC-Name\C\FolderName (say drive X:) and then try to open the file as x:\data.db ? Adam On Thu, Jun 25, 2015 at 10:24 AM, Takashi Fukuda wrote: > Donald Griggs tried to help this problem, and we looked at the Jean C's > advice. However the problem rem

[sqlite] FW: SQLite (1.0.97) access via LAN

Donald Griggs tried to help this problem, and we looked at the Jean C's advice. However the problem remains. The actual codes using are as follows: === string dataFile = "PC-Name\\C\\FolderName\\data.db " ; // // For x32 target co

[sqlite] FW: Very poor SQLite performance when using Win8.1 + Intel RAID1

- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Keith Medcalf Sent: donderdag 26 maart 2015 2:29 To: General Discussion of SQLite Database Subject: Re: [sqlite] FW: Very poor SQLite performance when using Win8.1 + Intel RAID1

[sqlite] FW: Very poor SQLite performance when using Win8.1 + Intel RAID1

This discussion, and you guys, are amazing. I am learning so much! On Wed, Mar 25, 2015 at 8:56 PM, Keith Medcalf wrote: > > On Wednesday, 25 March, 2015 10:42, Simon Slavin > said: > > >On 25 Mar 2015, at 1:47pm, Rob van der Stel < > RvanderStel at benelux.tokheim.com> wrote: > > >> One open

[sqlite] FW: Very poor SQLite performance when using Win8.1 + Intel RAID1

On 2015-03-25 03:47 PM, Rob van der Stel wrote: > One open issue for me remains however. Can I assume that the FlushFileBuffers > API that SQLite uses still causes cache to be written to disk even though the > 'automatic write-cache flushing' of Windows is turned off ? Depends what you mean:

[sqlite] FW: Very poor SQLite performance when using Win8.1 + Intel RAID1

On Wednesday, 25 March, 2015 10:42, Simon Slavin said: >On 25 Mar 2015, at 1:47pm, Rob van der Stel benelux.tokheim.com> wrote: >> One open issue for me remains however. Can I assume that the >> FlushFileBuffers API that SQLite uses still causes cache to be >> written to disk even though the '

[sqlite] FW: Very poor SQLite performance when using Win8.1 + Intel RAID1

On Wednesday, 25 March, 2015 07:47, Rob van der Stel said: >The naming in WinXP and Win81 is such that a mistake is easily made, the >corresponding options are namely: > >a1) WinXP: 'Optimize for for performance' -- this corresponds to >a2) Win81: 'Enable write cache on the device' > >b

[sqlite] FW: Very poor SQLite performance when using Win8.1 + Intel RAID1

On 25 Mar 2015, at 1:47pm, Rob van der Stel wrote: > One open issue for me remains however. Can I assume that the FlushFileBuffers > API that SQLite uses still causes cache to be written to disk even though the > 'automatic write-cache flushing' of Windows is turned off ? I can't answer your

[sqlite] FW: Very poor SQLite performance when using Win8.1 + Intel RAID1

Hello, I received several useful remarks and suggestions upon my post regarding the SQLite performance with Win8.1 + Intel RAID1. Especially the reminder that my fast System 1 (WinXP) was probably too fast for actual ACID made me look further into several cache options that windows and the RAID

[sqlite] FW: Core dump with shared cache enabled

Hello, While doing some profiling in python, I ran into a crash in sqlite3. The workflow was pretty simple – one thread doing writes, another doing reads (of course, these are python threads, so it’s only “sort-of” concurrent). This workflow worked fine with the shared cache disabled, but when

Re: [sqlite] Fw: Database is locked exceptions

You're in the right place, it just wasn't obvious to Simon (or me) from the previously sent data that it was a C#/.NET question vs a C API question. On Thu, Oct 30, 2014 at 11:46 AM, Mike McWhinney wrote: > I thought the SQLite mailing list included traffic that discussed > System.Data.SQLite >

Re: [sqlite] Fw: Database is locked exceptions

Mike McWhinney > > I thought the SQLite mailing list included traffic that discussed System.Data.SQLite > Yes, it does. This mailing list *IS* the appropriate place to for discussion of System.Data.SQLite. -- Joe Mistachkin ___ sqlite-users mailing l

Re: [sqlite] Fw: Database is locked exceptions

I thought the SQLite mailing list included traffic that discussed System.Data.SQLite I am not sure if there are any forums specifically for the ADO .NET provider and support. I will google to see if I can find the proper reference. Mike On Thursday, October 30, 2014 12:00 PM, Simon Slavin w

Re: [sqlite] Fw: Database is locked exceptions

Mike McWhinney wrote: > > I have continued to receive the locking erros. The latest connection string > I have as follows: > > public static string OMconnectionString = "URI=file:oslermedicine.db; busy > timeout=1; Pooling=True; Max Pool Size=100;"; > In the connection string, please use "Def

Re: [sqlite] Fw: Database is locked exceptions

On 30 Oct 2014, at 4:13pm, Mike McWhinney wrote: > I have continued to receive the locking erros. The latest connection string I > have as follows: > > public static string OMconnectionString = "URI=file:oslermedicine.db; busy > timeout=1; Pooling=True; Max Pool Size=100;"; > > > > Are

[sqlite] Fw: Database is locked exceptions

I have continued to receive the locking erros. The latest connection string I have as follows: public static string OMconnectionString = "URI=file:oslermedicine.db; busy timeout=1; Pooling=True; Max Pool Size=100;"; Are there any other parameters that will increase the timeout when the

Re: [sqlite] FW: I'm trying to figure out how to ...

On 18 Sep 2014, at 9:38am, RSmith wrote: > Thanks Keith for taking the time, I imagine this is a topic you are > passionate about and I think it should be published somewhere as an article > because it will save lives of beginner DBA/Programmers for millenia to come - > I have certainly born

Re: [sqlite] FW: I'm trying to figure out how to ...

On 2014/09/18 08:18, Keith Medcalf wrote: ...long article... Thanks Keith for taking the time, I imagine this is a topic you are passionate about and I think it should be published somewhere as an article because it will save lives of beginner DBA/Programmers for millenia to come - I have cer

[sqlite] FW: I'm trying to figure out how to ...

Read only scrollable snapshot cursors can be easily implemented in the same way as they are implemented in other database engines. You just have to do the work yourself. Example: cn = sqlite3.connection(...) cr = cr.cursor() # create the scrollable cursor cr.execute('create temporary table

Re: [sqlite] FW: GUI INfo

Maxine Nietz writes: > > Is this the way to post a question? You are doing fine, but here is a link I send to new listserv users sometimes: http://www.catb.org/esr/faqs/smart-questions.html ___ sqlite-users mailing list sqlite-users@sqlite.org h

Re: [sqlite] FW: GUI INfo

On 9 Sep 2014, at 8:58pm, Maxine Nietz wrote: > Is this the way to post a question? Yes. We expect you to have made an effort to answer your question before you post. You should have a vague idea where to find things on this site: for example. If your question is

[sqlite] FW: GUI INfo

Is this the way to post a question? Max From: Maxine Nietz [mailto:nevada...@sbcglobal.net] Sent: Monday, September 8, 2014 9:55 AM To: 'sqlite-users@sqlite.org' Subject: GUI INfo I am an experienced Access VBA programmer. I know about the SQLite commands to create and manipulate data

Re: [sqlite] FW: how best to determine # of rows in a table

Sorry, the count thing was actually Mark Halegua's question. -- Darren Duncan On 2014-08-27, 8:58 PM, Darren Duncan wrote: On 2014-08-27, 8:41 PM, Keith Medcalf wrote: this may seem like a small issue, but I'm not sure if the solutions I've found on the web will do what I want in a low memory s

Re: [sqlite] FW: how best to determine # of rows in a table

On 2014-08-27, 8:41 PM, Keith Medcalf wrote: this may seem like a small issue, but I'm not sure if the solutions I've found on the web will do what I want in a low memory situation. I'd like to iterate through a table one row at a time. I can do that in pysqlite, but I don't see a method for de

[sqlite] FW: how best to determine # of rows in a table

> this may seem like a small issue, but I'm not sure if the solutions I've > found on the web will do what I want in a low memory situation. I'd like to > iterate through a table one row at a time. I can do that in pysqlite, but I > don't see a method for determining I'm at the end of the file

Re: [sqlite] FW: Bug in division?

> Interesting. It makes NO sense to return 0 when dividing two integers. > Never took a C/C++ class? John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] FW: Bug in division?

I think the OP might be seeing the list via one of those connected sites and not getting the feedback. Maybe send a direct mail to him. On 2014/05/06 14:48, John Drescher wrote: Any reason I haven't heard back about this bug? You did not get the rest of the discussion on your post? It is not a

Re: [sqlite] FW: Bug in division?

> Any reason I haven't heard back about this bug? You did not get the rest of the discussion on your post? It is not a bug but an implementation allowed behavior and has to do with integer division. John ___ sqlite-users mailing list sqlite-users@sqlite

[sqlite] FW: Bug in division?

Any reason I haven't heard back about this bug? Thanks _ From: Gene Connor [mailto:neothreeei...@hotmail.com] Sent: Wednesday, April 30, 2014 12:21 AM To: sqlite-users@sqlite.org Subject: Bug in division? SELECT DISTINCT 2/4 AS RESULT FROM TABLE; returns 0 SELECT DISTINCT 2/4.0 AS

Re: [sqlite] FW: Need Help with Golf Handicap Calculation

te-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of James K. Lowden >Sent: Sunday, February 09, 2014 6:04 PM >To: sqlite-users@sqlite.org >Subject: Re: [sqlite] FW: Need Help with Golf Handicap Calculation > >On Sat, 8 Feb 2014 19:47:44 + >Ed Tenholde

Re: [sqlite] FW: Need Help with Golf Handicap Calculation

...@sqlite.org] On Behalf Of James K. Lowden Sent: Sunday, February 09, 2014 6:04 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] FW: Need Help with Golf Handicap Calculation On Sat, 8 Feb 2014 19:47:44 + Ed Tenholder wrote: > Query: SELECT MAX(ScoreDate),AVG((Score-Rating)*(113.0/Slope))*

Re: [sqlite] FW: Need Help with Golf Handicap Calculation

On Sat, 8 Feb 2014 19:47:44 + Ed Tenholder wrote: > Query: SELECT MAX(ScoreDate),AVG((Score-Rating)*(113.0/Slope))*.96 > FROM (SELECT * FROM (SELECT * FROM (SELECT > ScoreDate,Score,Rating,Slope FROM Scores WHERE Player="Joe Smith" > ORDER BY ScoreDate ASC LIMIT 3) ORDER BY ScoreDate DESC L

[sqlite] FW: Need Help with Golf Handicap Calculation

From: Ed Tenholder Sent: Saturday, February 08, 2014 1:44 PM To: 'sqlite-users@sqlite.org' Subject: Need Help with Golf Handicap Calculation I’m just trying to learn SQL, and after lots of google searches and reading posts on this email list, I’ve gotten pretty close. Table: CREATE TABL

Re: [sqlite] Fw: System.Data.SQLite.dll

On Thu, Jan 16, 2014 at 11:18 PM, Joe Mistachkin wrote: > > RadSolution wrote: > > > > The version info for this file states that it is version 91.0.77.0 dated > 31/01/2012 12:59 > > This is used in several of our legacy systems (without any problems that > I'm aware of). > > > > Judging from some

Re: [sqlite] Fw: System.Data.SQLite.dll

RadSolution wrote: > > The version info for this file states that it is version 91.0.77.0 dated 31/01/2012 12:59 > This is used in several of our legacy systems (without any problems that I'm aware of). > Judging from some of the version information in the file, it looks like the source code ma

[sqlite] Fw: System.Data.SQLite.dll

  Hello, The company I work for uses a version of the DLL called System.Data.SQLite.dll. The version info for this file states that it is version 91.0.77.0 dated 31/01/2012 12:59 This is used in several of our legacy systems (without any problems that I'm aware of). I have looked on the web

[sqlite] Fw: Timestamps from different timezones

Hello Christopher, > You absolutely cannot do this automatically unless you know > the source of > each timestamp, any maybe not even then. > Just as a f'rinstance, there are at least 3 different meanings > for EST, and > 2 of them are in the same country: > try -0500, +1000, +1100 for a star

[sqlite] FW: sqlite-users Digest, Vol 70, Issue 16

Joe, Thank You, Thank You, that is exactly what I needed. I couldn't think of how to debug this, so with your suggestion, I put a try block in my code and wrote the stack trace out to a text file and that gave me exactly what I needed. I was missing a dll, but it ended up having nothing to do wi

Re: [sqlite] FW: problem sqlite3 c++ please

Is this a repeated post? You cannot use shell commands as Sql statements in c api. Write your own export routine. Here is one I wrote. https://github.com/fnoyanisi/sqlite3_capi_extensions On 06/06/2013, at 11:02 PM, Maxime Gerum wrote: > > Hello, i’m french, sorry if i make errors of langag

[sqlite] FW: problem sqlite3 c++ please

Hello, i’m french, sorry if i make errors of langage In my school project, i use sqlite3 with c++, i can make any request such as create table or select *from, no problems. But i would export my database in a csv file, in sqlite3> .mode csv

[sqlite] FW: problem sqlite3 c++ please

Hello, i’m french, sorry if i make errors of langage In my school project, i use sqlite3 with c++, i can make any request such as create table or select *from, no problems. But i would export my database in a csv file, in sqlite3> .mode csv

Re: [sqlite] Fw: problem sqlite3 c++ please

Subject: Re: [sqlite] Fw: problem sqlite3 c++ please Hi, The command you entered, starting with dot, are sqlite shell commands, i.e. if you need similar functionality, you either * need to check SQLite C/C++ API documentation for a fucntion  or * need to implement your own function

Re: [sqlite] Fw: problem sqlite3 c++ please

: "sqlite-users@sqlite.org" Sent: Thursday, May 30, 2013 12:01 AM Subject: [sqlite] Fw: problem sqlite3 c++ please Hello, i’m french, sorry if i make errors of langage In my school project, i use sqlite3 with c++, i can make any request such as create table or select *from, no proble

Re: [sqlite] Fw: problem sqlite3 c++ please

On Wed, May 29, 2013 at 4:31 PM, Maxime Gerum wrote: > > it works, but in c++, if i make request[4]= ”.mode csv” > .mode is a command from the shell program sqlite3, and is not valid SQL. The C API only knows SQL, so you'll have to write the import/export code yourself or steal it from the shell

[sqlite] Fw: problem sqlite3 c++ please

Hello, i’m french, sorry if i make errors of langage In my school project, i use sqlite3 with c++, i can make any request such as create table or select *from, no problems. But i would export my database in a csv file, in sqlite3> .mode csv

[sqlite] FW: Exact content of a column in a row

Original reply sent from incorrect email address. -Original Message- From: David Wellman [mailto:david.well...@ward-analytics.com] Sent: 28 May 2013 14:25 To: 'General Discussion of SQLite Database' Subject: RE: [sqlite] Exact content of a column in a row Dear all, Many thanks for your

[sqlite] FW:

http://www.horsecenter.com.br/i4jsow.php ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Fw: Fw: Is there a command to lock a database for a short while (0.25 sec, say)

On Wed, 24 Apr 2013 16:35:21 +0200 "J Trahair" wrote: > I've found that either one of these will lock the database: > > mstrSQL = "PRAGMA locking_mode = EXCLUSIVE;BEGIN EXCLUSIVE;" > mstrSQL = "PRAGMA locking_mode = EXCLUSIVE;BEGIN > EXCLUSIVE;COMMIT;" > > and that clos

[sqlite] Fw: Fw: Is there a command to lock a database for a short while (0.25 sec, say)

I've found that either one of these will lock the database: mstrSQL = "PRAGMA locking_mode = EXCLUSIVE;BEGIN EXCLUSIVE;" mstrSQL = "PRAGMA locking_mode = EXCLUSIVE;BEGIN EXCLUSIVE;COMMIT;" and that closing the connection a little while later (eg. 0.25sec) mcmd

Re: [sqlite] Fw: Is there a command to lock a database for a short while (0.25 sec, say)

On 24 Apr 2013, at 11:58am, "J Trahair" wrote: > I had closed the connection after the COMMIT, but it works great if I don't. Your problem is not with closing the connection but with the COMMIT. The BEGIN goes with the COMMIT. When you go 'BEGIN EXCLUSIVE' you do have your exclusive lock, b

Re: [sqlite] Fw: Is there a command to lock a database for a short while (0.25 sec, say)

I had closed the connection after the COMMIT, but it works great if I don't. Thank you for that! I like the kitchen analogy, but it's more like 'Form an orderly queue for the electric citrus juicer' instead of all crowding round it and trying to juice 6 oranges and 4 lemons at once. In the end,

Re: [sqlite] Fw: Is there a command to lock a database for a short while (0.25 sec, say)

On Wed, 24 Apr 2013 11:19:32 +0200 "J Trahair" wrote: > Thanks for the replies so far. > > I've been trying to get the database to lock - I am using a program I > developed which runs on 2 of my computers but connected to the same SQLite > database: > > mstrSQL = "PRAGMA locking_m

[sqlite] Fw: Is there a command to lock a database for a short while (0.25 sec, say)

Thanks for the replies so far. I've been trying to get the database to lock - I am using a program I developed which runs on 2 of my computers but connected to the same SQLite database: mstrSQL = "PRAGMA locking_mode = EXCLUSIVE;BEGIN EXCLUSIVE;UPDATE Utilities SET OwnersName = '" &

Re: [sqlite] FW: How to add SQLite SDK/dll to WP 8 project

Hi, Suresh Official SQLite is not supported on .NET managed-code for Windows Phone 8 currently. Use LINQ to SQL. (Local Database) http://code.msdn.microsoft.com/wpapps/Local-Database-Sample-57b1614c Or use another library like 'csharp-sqlite'. http://code.google.com/p/csharp-sqlite/ Official SQ

[sqlite] FW: Invalid Code gemerated for Virtual Table Join with OR clause

Von: Hick Gunter Gesendet: Montag, 03. Dezember 2012 15:28 An: 'Richard Hipp' Betreff: AW: [sqlite] Invalid Code gemerated for Virtual Table Join with OR clause Thank you for your reply. As indicated in the second message, I have located the code where the erro

  1   2   3   >