Re: [sqlite] ICU collation

com>wrote: > On Tue, Dec 22, 2009 at 07:49:24AM -0500, Tim Romano wrote: > > On 12/22/2009 5:31 AM, Sylvain Pointeau wrote: > > > It cannot be done in the application layer... > > > > > You are wrong about that. I have written a full-text search application &

Re: [sqlite] ICU collation

yes this is what I meant in my previous email, but still another api to use ... It would have been easier if everything came from sqlite. (a new feature then? :-)) Best regards, Sylvain On Tue, Dec 22, 2009 at 7:54 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > Sylvain

Re: [sqlite] ICU collation

teps for my case. Many thanks Sylvain On Tue, Dec 22, 2009 at 8:46 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > Sylvain Pointeau > <sylvain.point...@gmail.com> wrote: > > yes this is what I meant in my previous email, > > but still another api to use ... >

Re: [sqlite] ICU collation

to not use ICU directly... anyway, I will do it, that's not a problem :-) relax, that's holidays soon :-P Best regards, Sylvain On Tue, Dec 22, 2009 at 11:00 PM, Igor Tandetnik <itandet...@mvps.org>wrote: > Sylvain Pointeau > <sylvain.point...@gmail.com> wrote: > > by

Re: [sqlite] Problem using sqlite in a C++/CLI .Net application

Hi, you can look at System.Data.SQLite and look at the sources. Best regards, Sylvain On Thu, Jan 28, 2010 at 12:23 AM, Edward Diener < eldlistmaili...@tropicsoft.com> wrote: > I am able to compile a C++/CLI .Net application using sqlite. But when > it links it

Re: [sqlite] Problem using sqlite in a C++/CLI .Net application

u, Jan 28, 2010 at 9:46 AM, Sylvain Pointeau < sylvain.point...@gmail.com> wrote: > Hi, > > you can look at System.Data.SQLite <http://sqlite.phxsoftware.com/> and > look at the sources. > > Best regards, > Sylvain > > > On Thu, Jan 28, 2010 at 12:23 AM,

Re: [sqlite] Problem using sqlite in a C++/CLI .Net application

n 29, 2010 at 1:00 AM, Edward Diener < eldlistmaili...@tropicsoft.com> wrote: > Sylvain Pointeau wrote: > > Hi again, > > > > as far as I know you cannot compile SQLite for C++/CLI directly, and I > > recently have some problem using C++/CLI in my Qt project. &g

Re: [sqlite] Problem using sqlite in a C++/CLI .Net application

Why don't you use sqlite as a dll? then you can download it already pre-compiled. I know this is not always possible (or wanted). Cheers, Sylvain On Fri, Jan 29, 2010 at 6:35 PM, Edward Diener < eldlistmaili...@tropicsoft.com> wrote: > Sylvain Pointeau wrote: > > Hello,

Re: [sqlite] Problem using sqlite in a C++/CLI .Net application

thank you for the feedback, good that there is no issue. best regards, Sylvain On Sat, Jan 30, 2010 at 4:19 AM, Edward Diener < eldlistmaili...@tropicsoft.com> wrote: > Sylvain Pointeau wrote: > > Why don't you use sqlite as a dll? > > I am using it as a DLL. The act

Re: [sqlite] parallelizing an update

a good thing would have been to generate one file with all the statements... if you do that then you run sqlite with this file surrounded by transaction begin/commit echo "begin transaction" >> update.sql sqlite3 -separator $'\t' sample.db 'select rowid, item from foo;' | while read rowid item ;

Re: [sqlite] parallelizing an update

be, how to modify the script to process the data in > with parallel processes? > > Regards, > - Robert > > On Sat, Jan 30, 2010 at 4:36 AM, Sylvain Pointeau > <sylvain.point...@gmail.com> wrote: > > a good thing would have been to generate one file with all the >

[sqlite] system.data.sqlite & encryption

Hi all, I am using System.data.sqlite from my .NET project, but I am planning to access my db from C/C++ and C# / C++/CI The point is that I want an encryted database, and I plan to use the extension from http://www.hwaci.com/sw/sqlite/prosupport.html#crypto how to use / implement this exension

Re: [sqlite] parallelizing an update

I would be very interested to see some benchmark, just to see. On Mon, Feb 1, 2010 at 5:16 PM, Nicolas Williams <nicolas.willi...@sun.com>wrote: > On Sat, Jan 30, 2010 at 10:36:56AM +0100, Sylvain Pointeau wrote: > > echo "begin transaction" >> update.sql

Re: [sqlite] parallelizing an update

Please just don't forget that sqlite lock the file at each update, running multiple processes will not improve at all the speed, I think it will be even worst. The only improvement you can do is to group your update in a single transaction, and avoid to run one process (sqlite3) for just 1 update.

Re: [sqlite] parallelizing an update

arg sorry I miss your LRP (Long Running Process), On Tue, Feb 2, 2010 at 11:55 PM, Sylvain Pointeau < sylvain.point...@gmail.com> wrote: > Please just don't forget that sqlite lock the file at each update, > running multiple processes will not improve at all the speed, I think it &g

Re: [sqlite] system.data.sqlite & encryption

ld probably ask this question on the System.data.sqlite > support forums at > > http://sqlite.phxsoftware.com/forums > > I'm not familiar with enough with their ADO .NET implementation to answer > your question. > > -Shane > > > On Sun, Jan 31, 2010 at 11:54 AM, Sylvain Pointeau

Re: [sqlite] system.data.sqlite & encryption

possibly modify) the > system.data.sqlite libraries for yourself, it should work. > > -Shane > > On Fri, Feb 5, 2010 at 5:05 AM, Sylvain Pointeau < > sylvain.point...@gmail.com > > wrote: > > > I posted on this forum > > http://sqlite.phxsoftware.com/forums/p

Re: [sqlite] Question on the VdbeCursor structure changes

I think, without to be 100% sure, that it is for the wrapper .NET System.Data.SQLite. I was myself in front of this code (to have this wrapper using the latest sqlite version). I ended up by removing all this code, meaning that if you don't call dispose() in your code, it will not be garbage

Re: [sqlite] ExecuteNonQuery() consuming memory

Hello, if you are using System.Data.Sqlite, please post your question to their forum: http://sqlite.phxsoftware.com/forums/ if you don't use this lib, I strongly recommend it to you. and my view on your problem is that you don't call dispose on the

Re: [sqlite] [server] HTTP + SQLite bundled as single EXE?

How do you authenticate to your http sqlite web server? is it not a security issue then? normally you would also need a server side language, so I would say apache is the only way to go, and also I don't understand why you need something specific to return JSON object. you can do it in 3 seconds

Re: [sqlite] [server] HTTP + SQLite bundled as single EXE?

On Mon, May 3, 2010 at 2:43 PM, Gilles Ganault <gilles.gana...@free.fr>wrote: > On Mon, 3 May 2010 14:41:10 +0200, Sylvain Pointeau > <sylvain.point...@gmail.com> wrote: > >How do you authenticate to your http sqlite web server? > >is it not a security issue then? > &g

Re: [sqlite] [server] HTTP + SQLite bundled as single EXE?

this is not clear for me. On Mon, May 3, 2010 at 2:49 PM, Gilles Ganault <gilles.gana...@free.fr>wrote: > On Mon, 3 May 2010 14:47:48 +0200, Sylvain Pointeau > <sylvain.point...@gmail.com> wrote: > >if you speak about MySQL or POSTGRESQL > >then you mean dat

Re: [sqlite] [server] HTTP + SQLite bundled as single EXE?

then? (there is no normalized protocole to do that) On Mon, May 3, 2010 at 2:50 PM, Sylvain Pointeau <sylvain.point...@gmail.com > wrote: > this is not clear for me. > > On Mon, May 3, 2010 at 2:49 PM, Gilles Ganault <gilles.gana...@free.fr>wrote: > >> On Mon, 3 Ma

Re: [sqlite] [server] HTTP + SQLite bundled as single EXE?

I would probably take mysql or postgresql, to be able to use the "prepared statements" and other facilities. I don't see any point to implement this kind of system. or same api as sqlite but the open is taking an url instead, but you have to re-write the api of sqlite. In this case, I can see the

[sqlite] sqlite on mac os x 64 bits

hello, I am generally doing: ./configure make sudo make install for having sqlite in my /usr/local/ directory. but is it 64 bits? or do I have to add a special option? Best regards, Sylvain ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] sqlite on mac os x 64 bits

ib/libsqlite3.dylib: Mach-O 64-bit dynamically linked shared library x86_64 so it is 64 bits by default... this is what I mean, in my opinion. Best regards, Sylvain On Tue, May 18, 2010 at 2:51 PM, Doug Currie <doug.cur...@gmail.com> wrote: > > On May 18, 2010, at 4:14 AM, Sylvain Po

[sqlite] issue with sqlite + user function + load dll implemented with Qt

hello, I am facing a very bizarre issue. I am on mac os x 64 bits. I needed a uuid() function that generates GUID. I created then a dll with Qt like: #include "/usr/local/include/sqlite3ext.h" SQLITE_EXTENSION_INIT1 #include #include extern "C" void sqlite3_uuid(sqlite3_context *context,

Re: [sqlite] issue with sqlite + user function + load dll implemented with Qt

cal/Trolltech/Qt-4.7.0/lib -L/usr/local/lib/ -framework QtCore -L/usr/local/Trolltech/Qt-4.7.0/lib I hope that it makes thing clearer. Best regards, Sylvain On Tue, May 18, 2010 at 7:40 PM, Sylvain Pointeau < sylvain.point...@gmail.com> wrote: > hello, > > I am facing a very bizarre

Re: [sqlite] Xcode warning on 3.7.10

On Mon, Jan 23, 2012 at 2:50 PM, Simon Slavin wrote: > > On 23 Jan 2012, at 5:49am, Tommy wrote: > > > After bringing the SQLite amalgamation into my library and compiling, > > Apple Xcode produced the following warning: > > > >

Re: [sqlite] Load SQLite from InputStream in Java as ReadOnly

It will not be possible with SQLite but it would be possible using H2. http://www.h2database.com/html/advanced.html#file_system maybe you could convert the sqlite to H2 somewhere in your process? Best regards, Sylvain ___ sqlite-users mailing list

Re: [sqlite] Import 5000 xml files in a sqlite database file

hello, I am not sure if Oxygen or another XML specialized software could do it, however it would be easy done using C or C++ or Java. Advantage is that it is then easy to automatize in a batch mode. I can propose you my services if you are interested. Best regards, Sylvain Le samedi 22 octobre

Re: [sqlite] sqlite with Java

On Sun, Mar 19, 2017 at 4:57 PM, Sylvain Pointeau < sylvain.point...@gmail.com> wrote: > Why don't you provide an up-to-date version? this lib seems dead when we >> look at the website, also why don't you put the sources on git it would be >> easier to contribute or raise a b

Re: [sqlite] sqlite with Java

> > Why don't you provide an up-to-date version? this lib seems dead when we > look at the website, also why don't you put the sources on git it would be > easier to contribute or raise a bug if any... > I tried to compile the latest version of sqlite 3.17 with the latest sources of sqlitejava

Re: [sqlite] sqlite with Java

On Sun, Mar 19, 2017 at 5:38 PM, Sylvain Pointeau < sylvain.point...@gmail.com> wrote: > On Sun, Mar 19, 2017 at 4:57 PM, Sylvain Pointeau < > sylvain.point...@gmail.com> wrote: > >> Why don't you provide an up-to-date version? this lib seems dead when we >>>

Re: [sqlite] sqlite with Java

> > > IMO it is no good idea to discuss specific issues of an only indirectly > SQLite related > library on this mailing list OK yes I agree, where can we discuss about it? > ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] sqlite with Java

> Now I'm a little bit confused. You asked for an SEE enabled SQLite Java > binding. This requires you to 1. obtain your SEE license from DRH's company > and 2. to use the SEE sources and compile/link them to > {lib,}sqlite_jni.{dll,so} > for your target platform. > Don't be confused, I know all

Re: [sqlite] sqlite with Java

> OK yes I agree, where can we discuss about it? > > For information, we continued this discussion privately. I succeed to build this library and I will use it in my project. Additionally I would be glad contribute if Christian needs my help. Furthermore, I will assess my need to have SSE, and if

[sqlite] sqlite with Java

Dear all, I would like to use sqlite from Java, but I am also looking to buy SSE. however which library would you recommend? how to integrate SSE? ps: it would be splendid if you could provide the java libs, similar to the .net version. Best regard, Sylvain

Re: [sqlite] sqlite with Java

I don't really want to use odbc in Java. I was thinking of https://github.com/xerial/sqlite-jdbc but how to use SSE in this case? seems the build is not so easy. with the sqlite odbc module > > http://www.ch-werner.de/sqliteodbc > ___ sqlite-users

Re: [sqlite] sqlite with Java

On Sat, Mar 18, 2017 at 1:04 PM, Christian Werner < christian.wer...@t-online.de> wrote: > Could it be updated to the latest version of sqlite, seems it is pretty >> outdated now. >> > > Totally outdated but still compiling even with most recent SQLite 3 (and 2) > versions and having autoconf

Re: [sqlite] sqlite with Java

Le sam. 18 mars 2017 à 09:53, Christian Werner <christian.wer...@t-online.de> a écrit : > On 03/18/2017 06:21 AM, Sylvain Pointeau wrote: > > I don't really want to use odbc in Java. I was thinking of > > https://github.com/xerial/sqlite-jdbc > > but how to use SSE in

Re: [sqlite] sequencer

ok thank you for the confirmation, I will try implementing it in a dll using UD functions and put it on github. Le mer. 2 août 2017 à 20:56, Richard Hipp <d...@sqlite.org> a écrit : > On 8/2/17, Sylvain Pointeau <sylvain.point...@gmail.com> wrote: > > > > is it really

Re: [sqlite] sequencer

illiams <n...@cryptonector.com> a écrit : > On Wed, Aug 02, 2017 at 06:10:52PM +0000, Sylvain Pointeau wrote: > > for a general case, I would need to persist the counter into a table > (for a > > specified sequencer) and doing the nextval inside a mutex lock > > > &g

Re: [sqlite] sequencer

On Thu, 3 Aug 2017 at 08:04, Hick Gunter wrote: > A sequence is very easily implemented as a virtual table that keeps the > current values in a separate table my_sequences (name text primary key, > initial integer, current integer, increment integer). > > (...) Or whatever else

Re: [sqlite] sequencer

Le ven. 4 août 2017 à 02:42, Nico Williams <n...@cryptonector.com> a écrit : > On Fri, Aug 04, 2017 at 12:35:56AM +0200, Sylvain Pointeau wrote: > > void sp_seq_init(sqlite3_context *context, int argc, sqlite3_value > **argv) { > > int rc = 0; > > sqlite3

Re: [sqlite] sequencer

Hello, please find below my implementation of a sequence, I am open for any critic! Best regards, Sylvain --- #include "sqlite3ext.h" SQLITE_EXTENSION_INIT1 void sp_seq_init(sqlite3_context *context, int argc, sqlite3_value

Re: [sqlite] sequencer

On Fri, Aug 4, 2017 at 7:41 AM, petern wrote: > Sylvain, are you happy with the performance? > > Maybe you are using it differently but, from my tests, the DEFAULT clause > is ignored for PRIMARY KEY columns. I had to use an ordinary column with > UNIQUE constraint

Re: [sqlite] sequencer

On Fri, Aug 4, 2017 at 9:21 AM, Sylvain Pointeau <sylvain.point...@gmail.com > wrote: > On Fri, Aug 4, 2017 at 7:41 AM, petern <peter.nichvolo...@gmail.com> > wrote: > >> Sylvain, are you happy with the performance? >> >> Maybe you are using it differently

Re: [sqlite] Version 3.20.0 coming soon...

I wonder how SQLITE_PREPARE_PERSISTENT can be used in a jdbc driver. Do you have any idea? (seems like there is no possibility to know about it from the jdbc API) is it better to always set this flag or to never do it? ___ sqlite-users mailing list

Re: [sqlite] sequencer

> > You're welcome. Thanks for posting this on github. Make sure there's a > license, preferably a nice and friendly one such as a BSD license, or > else put it in the public domain like SQLite3 is -- but it's your code, > so you do what you like with it. > I will put a BSD license and it will

Re: [sqlite] sequencer

On Fri, Aug 4, 2017 at 9:16 PM, Nico Williams <n...@cryptonector.com> wrote: > On Fri, Aug 04, 2017 at 09:09:10PM +0200, Sylvain Pointeau wrote: > > I programmed the currval using a temp table, but the performance dropped > > slightly > > > > sqlite> WITH T(i)

Re: [sqlite] sequencer

On Fri, Aug 4, 2017 at 6:24 PM, Nico Williams <n...@cryptonector.com> wrote: > On Fri, Aug 04, 2017 at 06:06:55PM +0200, Sylvain Pointeau wrote: > > Please find below the last source code, I removed the check on the table > > (NOT NULL on both sql_val and seq_inc) >

Re: [sqlite] sequencer

t;, 1, SQLITE_UTF8, 0, sp_seq_nextval, 0, 0); sqlite3_create_function(db, "seq_currval", 1, SQLITE_UTF8, 0, sp_seq_currval, 0, 0); return 0; } On Fri, Aug 4, 2017 at 8:18 PM, Nico Williams <n...@cryptonector.com> wrote: > On Fri, Aug 04, 2017 at 08:04:38PM +0200, Sylvai

Re: [sqlite] sequencer

On Fri, Aug 4, 2017 at 10:01 PM, Nico Williams <n...@cryptonector.com> wrote: > On Fri, Aug 04, 2017 at 09:55:03PM +0200, Sylvain Pointeau wrote: > > On Fri, Aug 4, 2017 at 9:16 PM, Nico Williams <n...@cryptonector.com> > wrote: > > > In general

[sqlite] sequencer

Dear all, I am currently using H2 and I use sequencers like: CREATE SEQUENCE IF NOT EXISTS SEQ_1 START WITH 12123; insert into MYTABLE(SPECIFIED_NUMBER, OTHERINFO) values (seq_1.nextval, 'other info') I would like to move to sqlite, but what would be your advice for the sequencer values? Is it

Re: [sqlite] sequencer

On Wed, Aug 2, 2017 at 5:27 PM, Peter Da Silva < peter.dasi...@flightaware.com> wrote: > Have a look at https://sqlite.org/autoinc.html > Yes I am aware of autoinc but this is not what I can use, because I need to specify exactly the sequence (as start number and increment). Additionally I can

Re: [sqlite] sequencer

ing > the sequence; > your statement where you’re using the sequence, except using something > like (SELECT value FROM super_sequences WHERE id=’SEQ_1’); > COMMIT; > > On 8/2/17, 11:20 AM, "sqlite-users on behalf of Sylvain Pointeau" < > sqlite-users-boun...@

Re: [sqlite] sequencer

On Wed, Aug 2, 2017 at 5:43 PM, Peter Da Silva < peter.dasi...@flightaware.com> wrote: > Hence the suggestion to script a transaction. For example, in pseudocode: > > BEGIN; > SELECT value, increment from super_sequences where table = :table and > column = :column; > INSERT INTO :table (id,

Re: [sqlite] sequencer

On Wed, Aug 2, 2017 at 5:56 PM, Simon Slavin wrote: > > > On 2 Aug 2017, at 4:54pm, Peter Da Silva > wrote: > > > Can’t you do the same basic logic then use (SELECT value FROM > super_sequences WHERE id=’SEQ_1’) instead of SEQ_1.nextval? > >

Re: [sqlite] sequencer

On Wed, Aug 2, 2017 at 5:54 PM, Peter Da Silva < peter.dasi...@flightaware.com> wrote: > Can’t you do the same basic logic then use (SELECT value FROM > super_sequences WHERE id=’SEQ_1’) instead of SEQ_1.nextval? > > > insert into mytable (MY_NO, MY_INFO) > SELECT SEQ_1.nextval, a.INFO

Re: [sqlite] sequencer

Thank you Nico! for a general case, I would need to persist the counter into a table (for a specified sequencer) and doing the nextval inside a mutex lock Is it possible to insert/ select from a UDF if the statements are serialized? or should I use the virtual tables? (should we store the

Re: [sqlite] sequencer

On Fri, Aug 4, 2017 at 9:21 AM, Sylvain Pointeau <sylvain.point...@gmail.com > wrote: > On Fri, Aug 4, 2017 at 7:41 AM, petern <peter.nichvolo...@gmail.com> > wrote: > >> Sylvain, are you happy with the performance? >> >> Maybe you are using it differently

Re: [sqlite] sequencer

> On Fri, Aug 4, 2017 at 7:41 AM, petern >> wrote: >> >>> Sylvain, are you happy with the performance? >>> >>> Maybe you are using it differently but, from my tests, the DEFAULT clause >>> is ignored for PRIMARY KEY columns. I had to use an ordinary column >>> with

Re: [sqlite] sequencer

On Fri, Aug 4, 2017 at 6:03 PM, petern wrote: > About the H2 test. That tester actually uses 10e6 is 10 x 10^6, 10 million > rows. When I wrote you I forgot I bumped it up to 10 million since 1 > million was only half a second on the native case. Give that a try

Re: [sqlite] sequencer

Please find below the last source code, I removed the check on the table (NOT NULL on both sql_val and seq_inc) sqlite> WITH T(i) AS (SELECT (1)i UNION ALL SELECT i+1 FROM T WHERE i<100) INSERT INTO seq_test(seq_num) SELECT seq_nextval('seq1') from T; Run Time: real 18.829 user 16.146103 sys

Re: [sqlite] sequencer

regards, Sylvain On Fri, Aug 4, 2017 at 10:44 PM, Sylvain Pointeau < sylvain.point...@gmail.com> wrote: > You're welcome. Thanks for posting this on github. Make sure there's a >> license, preferably a nice and friendly one such as a BSD license, or >> else put it in t

Re: [sqlite] sequencer

On Sun, Aug 6, 2017 at 6:34 PM, Sylvain Pointeau <sylvain.point...@gmail.com > wrote: > Dear all, > > you can now find the code on github with a BSD3 license, as well as a > release providing the dll for windows > > forgot to add the link :-) https://github.com/spo

Re: [sqlite] UPSERT available in pre-release

I full agree with Petite Abeille. This upsert is quite limited, we can only insert one row on conflict update one row. Even so it is a big improvement versus the insert or replace, this is far from the merge from the SQL standard where we can insert or update multiple rows in one query. I am

Re: [sqlite] JDBC driver experience

Hi, Le mer. 18 avr. 2018 à 21:34, Richard Hipp a écrit : > Are you using SQLite with JDBC? If so, can you please answer a few > questions below? > > You can post on this mailing list or send your reply directly to me. > > 1. Which JDBC are you using? I am using xerial and

<    1   2