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

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] 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] 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

> > 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 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

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

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 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

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

> 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 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 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 > UNIQUE constraint

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 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

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

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

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: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

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: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: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

[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] 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] 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

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

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

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

> 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

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] 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

[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] 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

[sqlite] user defined function returning a result set

> > To do this, you'd have to create a virtual table that actually gets > instantiated per CSV file: > > CREATE VIRTUAL TABLE temp.file1 USING > csvFileReader('/path/to/my/file.csv'); > SELECT * FROM file1; > DROP TABLE file1; > > In the above, the xCreate method of the virtual

[sqlite] user defined function returning a result set

Hello, I think I have read on this mailing list that sqlite now has functions able to return rows. (but cannot find it anymore) I am interested about this new functionality. Would it be possible to see a very basic sample of it? Do you think we can implement a kind of CSV reader with this new

[sqlite] CSV excel import

Le jeudi 30 juillet 2015, Simon Slavin a ?crit : > > On 30 Jul 2015, at 9:57pm, Sylvain Pointeau <javascript:;>> wrote: > > > no it does not work double clicking on the csv to open it in excel, I am > > 100% sure (I just tried again), you have to go through the

[sqlite] CSV excel import

On Thu, Jul 30, 2015 at 10:52 PM, Simon Slavin wrote: > > On 30 Jul 2015, at 9:50pm, Sylvain Pointeau > wrote: > > > leading > > 0 are removed when opening a csv file by double clicking on it to open it > > in excel. > > This is documented behaviour in

[sqlite] CSV excel import

On Thu, Jul 30, 2015 at 9:00 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 07/30/2015 10:58 AM, Sylvain Pointeau wrote: > > is it possible? in a lot of cases, I cannot use sqlite (executable) > > because of the lack of a good CSV impor

[sqlite] CSV excel import

> > > ?I am replying to your original message rather that later ones because I'm > curious about the CSV file which is giving you a problem. Using the sqlite3 > command on Linux Fedora 22 (64 bit), I get the following (transcript): > > $sqlite3 > SQLite version 3.8.10.2 2015-05-20 18:17:19 > Enter

[sqlite] CSV excel import

Le jeudi 30 juillet 2015, John McKown a ?crit : > On Thu, Jul 30, 2015 at 1:48 PM, Sylvain Pointeau < > sylvain.pointeau at gmail.com <javascript:;>> wrote: > > > On Thu, Jul 30, 2015 at 8:44 PM, Peter Aronson <javascript:;>> wrote: > > >

[sqlite] CSV excel import

Le jeudi 30 juillet 2015, Simon Slavin a ?crit : > > On 30 Jul 2015, at 7:48pm, Sylvain Pointeau <javascript:;>> wrote: > > > really cool, but I would like to have a solution directly in the sqlite3 > > executable > > If you're talking about the SQLite she

[sqlite] CSV excel import

Le jeudi 30 juillet 2015, Scott Doctor a ?crit : > > A trick that works great most of the time with ODS is when exporting to > CSV select the option to quote all fields. One problem with CSV is that > many exports quote strings but not numbers. If everything is quoted then it > is much simpler

[sqlite] CSV excel import

On Thu, Jul 30, 2015 at 8:44 PM, Peter Aronson wrote: > Actually there exists an open source tool that convert Excel data into > SQLite tables -- the ogr2ogr command line tool of OSGeo's GDAL library ( > http://www.gdal.org/). You do need a version of GDAL built with the > SQLite and XLSX

[sqlite] CSV excel import

On Thu, Jul 30, 2015 at 8:43 PM, Adam Devita wrote: > Instead of trying to conform to MS-Excel's csv format, wouldn't it be > better to write an import from .xls (or .ods if that is an open > standard) directly? > > That way each cell's value can be bound to a position holder in a > query. No

[sqlite] CSV excel import

On Thu, Jul 30, 2015 at 8:32 PM, Bernardo Sulzbach < mafagafogigante at gmail.com> wrote: > > My point is that I have seen so many emails regarding this incorrect csv > import, that it would be so easy for us if it just simply works in the CLI > and delivered in standard in the sqlite3

[sqlite] CSV excel import

On Thu, Jul 30, 2015 at 8:17 PM, Luuk wrote: > On 30-7-2015 20:07, Richard Hipp wrote: > >> On 7/30/15, Sylvain Pointeau wrote: >> >>> I understood from the mailing list, that CSV is not a defined format, >>> then >>> let's propose another format

[sqlite] CSV excel import

On Thu, Jul 30, 2015 at 8:07 PM, Richard Hipp wrote: > > Then why don't you propose an import of CSV from Excel (or similar)? > > csv(excel) > An Excel-to-SQLite converter utility sounds like it would be a great > open-source project. Why don't you start it up? > -- > D. Richard Hipp > drh

[sqlite] CSV excel import

I understood from the mailing list, that CSV is not a defined format, then let's propose another format, well defined, the Excel one (which is in my experience a format to is good every time I had to exchange CSV files). Then why don't you propose an import of CSV from Excel (or similar)?

[sqlite] index for OR clause

On Mon, Jul 27, 2015 at 8:27 PM, R.Smith wrote: > > > On 2015-07-27 08:09 PM, Simon Slavin wrote: > >> On 27 Jul 2015, at 6:58pm, Sylvain Pointeau >> wrote: >> >> create table TEST ( >>> a TEXT NOT NULL, >>> a2 TEXT NOT NULL, >>> b

[sqlite] index for OR clause

Yes, having: create table TEST ( a TEXT NOT NULL, a2 TEXT NULL, b TEXT NOT NULL, c TEXT NOT NULL ); create index IDX_TEST_1 on TEST(c,b,a,a2); create index IDX_TEST_2 on TEST(c,b,a); create index IDX_TEST_3 on TEST(c,b,a2); sqlite> explain query plan select * from TEST where (a = '123' or

[sqlite] index for OR clause

EST USING INDEX IDX_TEST_3 (a2=? AND b=? AND c=?) thank you again On Mon, Jul 27, 2015 at 8:05 PM, Richard Hipp wrote: > On 7/27/15, Sylvain Pointeau wrote: > > Hello, > > > > I would like to know if this is possible to use an index in the following > > case: &g

[sqlite] index for OR clause

Hello, I would like to know if this is possible to use an index in the following case: select * from TEST where (a = '123' or a2='1234') and b = '456' and c='PP'; given the table: create table TEST ( a TEXT NOT NULL, a2 TEXT NOT NULL, b TEXT NOT NULL, c TEXT NOT NULL ); create index

Re: [sqlite] Variable values in Views

It is called parameterized view in sqlserver. Actually it is extremely useful in order to have a good reusability in the code. I was actually missing it in Oracle, although I found a workaround of using the pipelined functions. Unfortunately, it is missing in sqlite, as well as the merge

Re: [sqlite] lemon - %wildcar

Hello, Le samedi 26 juillet 2014, Richard Hipp a écrit : > > Historical note: I wrote Lemon back in the 80s (on a Sun3, IIRC) You were a visionary, Lemon is probably the only viable option for a parser generator in C/C++ at this moment. because > the $1,$2,$3 notation of

[sqlite] lemon - %wildcar

Hello, I would like to know if %wildcard is an undocumented feature on purpose, is this safe to use it? if yes, could it be added in the documentation? ps: I am pretty impressed by lemon, I am really having fun. Best regards, Sylvain ___ sqlite-users

Re: [sqlite] DELETE & INSERT vs. REPLACE

I second "Petite Abeille", the merge into (SQL 2003) would be more than useful. REPLACE should be avoided. On Wed, May 28, 2014 at 5:08 PM, Simon Slavin wrote: > > On 28 May 2014, at 3:55pm, Drago, William @ MWG - NARDAEAST > wrote: > > > Can

Re: [sqlite] "Common Table Expression"

I agree with David, CTE is just wonderful, a big help to avoid re-typing many times the same sub-query and a performance improvement as well. Yes we can workaround it but it is ugly and leads to un-maintainable code. I am using it every days in my job and I can just tell that it has been proven to

Re: [sqlite] SQL 2003 in sqlite

Hi, > INSERT (OR REPLACE/IGNORE) INTO table1 SELECT * FROM table2 > Do you have specific requirements for the UPDATE features of MERGE ? the issue with "insert or replace" is that it will match on primary keys, additionally (I am not 100% sure) it deletes first the row to replace it. we cannot

[sqlite] SQL 2003 in sqlite

Hello, The merge statement is really missing in sqlite... Is there any plan to integrate this SQL 2003 syntax in sqlite? Best regards, Sylvain ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Row Level Locking as in InnoDB

Hello, If I would have one wish, it would not be the row level locking but the merge syntax, so usefulf to update, insert or update in 1 command (no insert or replace is not an equivalent), and in general it would be good to implement the sql 2003. Just a wish. Best regards, Sylvain Le lundi

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] 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] Very slow processing of some SELECT statements

On Tue, Oct 18, 2011 at 8:30 AM, Nick Gammon <n...@gammon.com.au> wrote: > > On 18/10/2011, at 4:46 PM, Sylvain Pointeau wrote: > > > Is it normal that fromuid of the table exits is STRING ? > > I think it should be TEXT to be surely processed as text and not float >

Re: [sqlite] Very slow processing of some SELECT statements

Is it normal that fromuid of the table exits is STRING ? I think it should be TEXT to be surely processed as text and not float ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] importing CSV data on command-line?

> > I have got to stop working until 3:00am. Your suggestion points to what I > did not verify. The original CSV is much richer with double quoting some > values. The following shows that setting the separator as I was within the > shell does not do what I was expecting: > > I made one that I

Re: [sqlite] SQLite and Java

> my program language is Java. And the www.sqlite.org not supply API for Java. What should I do? I think this one is the best http://code.google.com/p/sqlite-jdbc/ Best regards, Sylvain ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] problems on importing quoted csv files

I made one, as a command line tool. the announcement: http://spointeau.blogspot.com/2011/03/sylisa-csv2db-is-born.html the sources: https://gitorious.org/sylisa-csv2db/sylisa-csv2db Another option, you can also use the shell (in python) apsw http://apidoc.apsw.googlecode.com/hg/index.html

Re: [sqlite] C++ Sample Code

I wrote one wrapper, that can be compiled, like sqlite3, in your C++ program. It doesn't rely on any third library except sqlite3. The update of sqlite3 is just done by replacing the amalgamation files. https://gitorious.org/sylisa-dblite/sylisa-dblite It uses the syntax borrowed from soci++,

Re: [sqlite] completion of sql words

Hello, I just tried APSW on max os x, but how to get the auto-completion to work? it does not work for me... Best regards, Sylvain On Sat, Apr 9, 2011 at 11:50 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 04/09/2011 02:03 PM, Edzard

Re: [sqlite] SQLite version 3.7.5

Any news on System.Data.SQLite.org ? It was a so great news! When are the releases planned? Best regards, Sylvain ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Propose minor incompatible API change

I agree with this change because it doesn't change all well written programs. It just tries to correct all incorrectly written ones, which is a good thing for the end-users. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SQLite server

.@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Sylvain Pointeau > Sent: Wednesday, December 22, 2010 7:51 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] SQLite server > > Why not doing it with DCOM or Corba or what ever even the so

Re: [sqlite] SQLite server

Why not doing it with DCOM or Corba or what ever even the sockets? but hidden behind the same API of SQLite. The "real" sqlite lib will be on the server. is it called "remote procedure call"? ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SQLite server

and what about using a DCOM like technology to open a distant database? the sqlite API will stay the same but behind the scene, it will access your server using a DCOM like technology? ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] R: R: R: R: Lock problem opening a Sqlite db on a Samba/CIFS shared disk

What does it mean? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] R: R: R: Lock problem opening a Sqlite db on a Samba/CIFS shared disk

... and if you use the "unix-dotfile" as the VFS name in your open call. Does it work? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Assertion failure in SQLite 3.7.3 (new vs. 3.6.23.1)

stValues.sql sqlite> .read ./TestQuery.sql Assertion failed: (memIsValid([i])), function sqlite3VdbeExec, file sqlite3.c, line 64507. Abort trap On Sat, Dec 4, 2010 at 11:20 AM, Sylvain Pointeau < sylvain.point...@gmail.com> wrote: > I used: > CFLAGS='-arch i686 -arch x86_64' LDFLAG

Re: [sqlite] Assertion failure in SQLite 3.7.3 (new vs. 3.6.23.1)

I used: CFLAGS='-arch i686 -arch x86_64' LDFLAGS='-arch i686 -arch x86_64' ./configure --disable-dependency-tracking my compiler is: $ gcc --version i686-apple-darwin10-gcc-4.2.1 (GCC) 4.2.1 (Apple Inc. build 5664) Copyright (C) 2007 Free Software Foundation, Inc.

Re: [sqlite] Assertion failure in SQLite 3.7.3 (new vs. 3.6.23.1)

Hi, I am on macosx sqlite 3.7.3 $ /usr/local/bin/sqlite3 test.db3 SQLite version 3.7.3 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .read ./testSchema.sql sqlite> .read ./TestValues.sql sqlite> .read ./TestQuery.sql Otterbourne Golf Course|Jane Doe|Assumed

Re: [sqlite] WAL and multiple writers?

Are you sure that you are not keeping a transaction in the message sender? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Compile SQlite 32 and 64 bits universal with ICU support on MacOSX

Hello, I met today a difficult situation where I wanted to have SQLite 32 and 64 bits with the ICU support, Unfortunately ICU does not support the universal 32 and 64 bits... but using lipo and a bit of manual work, we have it working! I wrote the detailed procedure on my blog

Re: [sqlite] linux ubuntu 3.7.01 installs sqlite3 3.6.22

I learned something today :-) I added /usr/local/lib to my /etc/ld.so.conf then run "sudo ldconfig" then I could use the latest sqlite3 in my /usr/local/ directory ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] linux ubuntu 3.7.01 installs sqlite3 3.6.22

... my fault, the programs are taking the lib from /usr/lib before /usr/local/lib it is not doing this way on my macosx, I am searching now how to specify to take first the /usr/local/lib when executing, even for /usr/local/bin/sqlite3 ___ sqlite-users

Re: [sqlite] linux ubuntu 3.7.01 installs sqlite3 3.6.22

I just installed the sources (not the amalgamation ones) and it works fine. what's wrong with the amalgamation package? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] linux ubuntu 3.7.01 installs sqlite3 3.6.22

I don't know if it is important, but I am running ubuntu 10.04 64 bit ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] linux ubuntu 3.7.01 installs sqlite3 3.6.22

I made a small c program for testing the libs... #include #include int main() { printf("version %s\n",sqlite3_libversion()); return 0; } it returns 3.6.22 why do I compile and install a previous version? (is it linked to ubuntu?) best regards, Sylvain >

[sqlite] linux ubuntu 3.7.01 installs sqlite3 3.6.22

Hi, I downloaded, compiled and installed the sqlite3 3.7.01 from the sources (amalgamation). however I have the sqlite3 version 3.6.22 installed in /usr/local/bin when I do "make install" >.libs/sqlite3 --version 3.6.22 however something strange, it creates a sqlite3 on the folder (same level

Re: [sqlite] Accessing an sqlite db from two different programs

to not block all users with updates. On Tue, Jun 29, 2010 at 6:54 PM, Greg Burd <greg.b...@oracle.com> wrote: > Why "the smallest update possible"? > > -grge > > > -----Original Message- > > From: Sylvain Pointeau [mailto:sylvain.point...@gmail.com]

Re: [sqlite] Accessing an sqlite db from two different programs

absolutely no problem with sqlite. ensure you are doing smallest update as possible. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite and Qt

On Wed, Jun 16, 2010 at 3:42 PM, Sam Carleton > > The error was between the keyboard and the chair... Once the SQLite > DLL was moved into the Qt bin directory, all worked as expected. > > :-) > Thus the answer to my question would seem to be: Qt will simply use >

Re: [sqlite] Locking issue on NFS filesystem

> int sqlite3_open_v2( > const char *filename, /* Database filename (UTF-8) */ > sqlite3 **ppDb, /* OUT: SQLite db handle */ > int flags, /* Flags */ > const char *zVfs/* Name of VFS module to use */ > ); > > With the last argument "unix-dotfile". > > Does it

Re: [sqlite] SQLite and Qt

the lib, I thought I might ask before running down > that rat whole;) > > Sam > > On Wed, Jun 9, 2010 at 4:20 AM, Sylvain Pointeau > <sylvain.point...@gmail.com> wrote: > > > > build your qt sqlite as a plugin > > then recompile this plugin with the version

Re: [sqlite] SQLite and Qt

build your qt sqlite as a plugin then recompile this plugin with the version you want. http://doc.trolltech.com/4.6/sql-driver.html#qsqlite-for-sqlite-version-3-and-above best regards, Sylvain On Wed, Jun 9,

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

  1   2   >