Re: [sqlite] What does "The use of the amalgamation is recommended for all applications." mean, precisely?

Just curious, what dev language are you using? *Jonas Malaco Filho* On 25/05/2012, at 17:57, Peter Haworth wrote: Just picking a random post to make my reply to. I truly wish I could get access to an external sqlite library to load at runtime. I use e devlopement language

Re: [sqlite] Duplicated Values - Occurrence Count

Nigel Verity wrote: Hi I'd be grateful for a little advice on SQL syntax, as supported by sqlite. I have a table containing, typically, around 50,000 records. Within the table one particular field will contain many occurrences of the same string value. I can produce a de-duplicated list of the

[sqlite] Duplicated Values - Occurrence Count

Hi I'd be grateful for a little advice on SQL syntax, as supported by sqlite. I have a table containing, typically, around 50,000 records. Within the table one particular field will contain many occurrences of the same string value. I can produce a de-duplicated list of the values from that

Re: [sqlite] Bug: SQLiteDataAdapter.FillSchema doesn't work with multiresult queries

Thanks for the report. This issue is being worked on here: https://system.data.sqlite.org/index.html/info/3aa50d8413 -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] What does "The use of the amalgamation is recommended for all applications." mean, precisely?

Just picking a random post to make my reply to. I truly wish I could get access to an external sqlite library to load at runtime. I use e devlopement language that has the sqlite library built into it so I am at the mercy of the language provider as to what is provided. Right now, they are

Re: [sqlite] Fossil code sprint. Was: DRH to be in Munich, Germany July 3rd, 2012

For those who missed the notice about Richard's visit the first time around: https://plus.google.com/104981852298046595282/posts/JhpKW3zXScj On Fri, May 25, 2012 at 9:45 PM, Richard Hipp wrote: > * User preferences stored in a cookie > Adding persistent user preferences on

[sqlite] Fossil code sprint. Was: DRH to be in Munich, Germany July 3rd, 2012

On Tue, May 15, 2012 at 12:20 PM, Stephan Beal wrote: > > Richard Hipp will be in Munich, Germany for a few days in July and has > graciously[1] offered to host a presentation and/or hacking session with > regards to sqlite and/or Fossil SCM. > My desire is to have a

Re: [sqlite] (no subject)

On Fri, 25 May 2012 14:56:24 -0400, Frank Chang wrote: > > http://swatim dot sw dot ohost dot de/gertycamp3.html Poisonous link, don't click. Frank, please perform a rigorous virus check on your machine(s), you may have been infected by a bot. -- Regards, Kees

[sqlite] Bug: SQLiteDataAdapter.FillSchema doesn't work with multiresult queries

How to reproduce: obtain any SQLite database with 2 or more tables in it (I used "CREATE TABLE a (x INTEGER PRIMARY KEY); CREATE TABLE b (y INTEGER PRIMARY KEY)"). Compile and run the following C# code: SQLiteConnectionStringBuilder connBuilder = new SQLiteConnectionStringBuilder();

Re: [sqlite] Improving performance of GROUP BY

On 25 May 2012, at 7:38pm, Udi Karni wrote: > I am running the following query - > > CREATE TABLE XYZ AS > SELECT ID, MIN (DATE) > FROM SOURCE-TABLE > WHERE CRITERIA > GROUP BY ID ; > > SOURCE-TABLE has 600 million rows, 2 million meet the WHERE criteria, and > get grouped

[sqlite] Improving performance of GROUP BY

I am running the following query - CREATE TABLE XYZ AS SELECT ID, MIN (DATE) FROM SOURCE-TABLE WHERE CRITERIA GROUP BY ID ; SOURCE-TABLE has 600 million rows, 2 million meet the WHERE criteria, and get grouped to 100,000 distinct IDs. There are no indexes as there is too much variety in the

Re: [sqlite] FW: Problem with SQLite when deployed.

On Fri, May 25, 2012 at 9:40 AM, Pavel Ivanov wrote: > Except that 64-bit executable cannot load 32-bit DLL and vice versa. > I'm not sure how this rule is applied to managed executables and DLLs > loading unmanaged DLLs. On a 64-bit machine managed executables run as 64-bit

Re: [sqlite] FW: Problem with SQLite when deployed.

> For device drivers, the 32 & 64 bit difference can be incompatible. For > other libraries, DLL functions are just like exe ones.  The 64 bit machine > should execute the 32 bit code. Except that 64-bit executable cannot load 32-bit DLL and vice versa. I'm not sure how this rule is applied to

Re: [sqlite] FW: Problem with SQLite when deployed.

Under normal circumstances, same directory as the exe is part of a default path of places Windows looks. I just ran my 32 bit code on a windows 7 64 bit machine. It worked ok ( It is just a count records in this table and display it on a test label. ). For device drivers, the 32 & 64 bit

[sqlite] Static linking. Was: Problem with SQLite when deployed.

We were just having a discussion on a different thread on the relative merits of static versus dynamic linking. Notice that if the application where statically linked (if that were possible in C#) then all the grief that Peter is having would have never come up. The application would just work,

Re: [sqlite] FW: Problem with SQLite when deployed.

I've just been trying some other things and it seems that the SQLite.Interop.dll file that I have copied to the 32-bit operating system is the 64-bit version. I think it will work if I make sure that the 32-bit versions of the DLLs are included in my install program. Will the 32-bit versions

Re: [sqlite] FW: Problem with SQLite when deployed.

Adam SQLite.Interop.dll is in the same directory as the application being run. But it probably isn't in the PC's search path. Peter Walburn Software Engineer E-mail: peter.walb...@omega-data.com Units 44-46 Howe Moss Avenue, Kirkhill Industrial Estate, Dyce, Aberdeen AB21 0GP Tel: +44

Re: [sqlite] FW: Problem with SQLite when deployed.

Simple thing first: Did you ensure that the SQLite.Interop.dll is in the path that the PC is searching? regards, Adam On Fri, May 25, 2012 at 10:57 AM, Peter Walburn < peter.walb...@omega-data.com> wrote: > Hi, > > I have an application written in C# .Net 4.0 Framework. I use SQLite > within

[sqlite] FW: Problem with SQLite when deployed.

Hi, I have an application written in C# .Net 4.0 Framework. I use SQLite within the application. I have recently updated from an older version of SQLite to the latest version as I have moved to .Net Framework 4.0 and I received error messages about Mixed Mode Frameworks. Anyway, I do the

[sqlite] Problem with SQLite when deployed.

Hi, I have an application written in C# .Net 4.0 Framework. I use SQLite within the application. I have recently updated from an older version of SQLite to the latest version as I have moved to .Net Framework 4.0 and I received error messages about Mixed Mode Frameworks. Anyway, I do the

Re: [sqlite] What does "The use of the amalgamation is recommended for all applications." mean, precisely?

Am 25.05.2012 14:27, schrieb Pavel Ivanov: >> With regard to the second issue, several experienced people, including >> Richard Hipp, have expressed the opinion in more than one occasion >> that statically linking sqlite avoids some problems that can happen >> otherwise. > > OTOH, all people

Re: [sqlite] SQLite SELECT performance problem

Hi Michael, Kreith, Jonas, Thanks for your response. I just tried to launch the binary manually, and it worked very fast. I didn't figure out by myself that i should've tried to launch the application outside of Visual Studio (I was thinking that in "Release" mode VS doesn't slow down the

Re: [sqlite] What does "The use of the amalgamation is recommended for all applications." mean, precisely?

On 25 May 2012, at 1:45pm, "Black, Michael (IS)" wrote: > We used to have tons of problems on Solaris due to shared libraries. > Numerous incompatibilities across multiple versions of Solaris. Static link > always worked. There are actually three options (depending

Re: [sqlite] What does "The use of the amalgamation is recommended for all applications." mean, precisely?

On the 3rd hand (Medusa here) those of us involved in mission critical apps refuse to let people arbitrarily update packages that are part of the "system". Things like the bug introduced in 3.7.12 being a prime example. It's called "Configuration Control". Some apps may depend on updated

Re: [sqlite] What does "The use of the amalgamation is recommended for all applications." mean, precisely?

On Fri, May 25, 2012 at 8:27 AM, Pavel Ivanov wrote: > > With regard to the second issue, several experienced people, including > > Richard Hipp, have expressed the opinion in more than one occasion > > that statically linking sqlite avoids some problems that can happen > >

Re: [sqlite] What does "The use of the amalgamation is recommended for all applications." mean, precisely?

> With regard to the second issue, several experienced people, including > Richard Hipp, have expressed the opinion in more than one occasion > that statically linking sqlite avoids some problems that can happen > otherwise. OTOH, all people involved in supporting Linux distributions advocate

Re: [sqlite] SQLite SELECT performance problem

Usng your sqlite3.exe CPU Time: user 2.156250 sys 2.078125 Using your sqlite3.console.exe CPU Time: user 1.375000 sys 0.140625 I'm afraid I don't see the problem since the pre-built is slower than your executable for me. Michael D. Black Senior Scientist Advanced Analytics Directorate

[sqlite] How to write and read the same sqlite3 DB in memory concurrently in two thread?

Now I am writing datas to sqlite3 DB in memory(":memory:") in a thread . And concurrently I want to read the datas of the same DB in memory too. but While i used the same object of sqlite3 to write and read, i had got the error:SQLITE_MISUSE. If i use the different objects of sqlite3 to write and

Re: [sqlite] What does "The use of the amalgamation is recommended for all applications." mean, precisely?

On Fri, May 25, 2012 at 9:03 AM, Sidney Cadot wrote: > What I was wondering is whether the SQLite docs (written by you, I > presume) express a preference for using SQLite3 via inclusion of the > source (amalgamation) into ones project, vs. using a pre-compiled > library (as

Re: [sqlite] What does "The use of the amalgamation is recommended for all applications." mean, precisely?

Hi, > I approve of your translation. That interpretation concerns the relative merits of using the separate sources vs the amalgamation, if I understand correctly. Barring special circumstances, the use of the amalgamation is the preferred way; that is understood. What I was wondering is