[sqlite] sqlite-tools-win64-x64-3290000.zip missing

Dear Woman and Man! sqlite-tools-win64-x64-329.zip are missing. How to solve this problem? With kind Greetings! ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] CSV import does not handle fields with a comma surrounded by double

I don’t know about ‘valid’ csv, it has been a moving target for decades. White space as far as my recollection should not be considered in parsing a csv. My 2 cents. Pat... Sent from my iPhone > On May 21, 2019, at 9:28 AM, Richard Hipp wrote: > >> On 5/21/19, Faheem Mitha wrote: >> The

[sqlite] Strange Corruption Issue

I'm using sqlite in an embedded application, running on SSD. journal_mode=persist so that it is more resilient to loss of power. I'm seeing corruption. I'm using sqlite to log events on the system, and the corruption is well in the middle of a power session; not at the tail end of log when a

[sqlite] How do I insert a record in an SQLite table only if the row does not already exist?

together more complex queries. There are plenty of example on the internet of simple scripts, but it is difficult to know how to move beyond the basics. Any pointers to good sources of learning for this would be great. Kind wishes ~ Patrick ___ sqlite-users

Re: [sqlite] Commit ad601c7962 degrade performance in a client program

is the root cause. That was 2% on average. In certain long-running parts of a build that made heavy use of pseudo, that particular commit caused a slowdown of 326% - see https://www.mail-archive.com/openembedded-core@lists.openembedded.org/msg88109.html -- Best Regards, Patrick Ohly

Re: [sqlite] sqlite3_column_origin_name for INSERT and UPDATE

2016-06-17 18:26 GMT+02:00 Igor Tandetnik : > > select * from t1 where col1 = ?1+?2 and col2=?1-?2; > > What should be the expected output of your hypothetical generic way for a > statement like this? > > You seem to assume a one-to-one correspondence between columns and >

Re: [sqlite] sqlite3_column_origin_name for INSERT and UPDATE

2016-06-17 18:24 GMT+02:00 James K. Lowden : > > You are encoding type information in the name. If you move the type > information into the data, SQLite can manage the unit dimension. You > could use a CHECK constraint to require that speed was in m/s, or a > trigger

Re: [sqlite] sqlite3_column_origin_name for INSERT and UPDATE

> Le 17 juin 2016 à 13:35, Hick Gunter a écrit : > > Does > > .pragma table_info(); > > not solve your problem? > I indeed need PRAGMA table_info(), to get type names from column names. Let my rephrase my question: Find a generic way to retrieve column names and table

[sqlite] sqlite3_column_origin_name for INSERT and UPDATE

Hello, I am using function sqlite3_column_origin_name and friends in my SQLite3 C++ wrapper class to get table and column names in SELECT statements. I would like to have the same feature for INSERT and UPDATE statements: that is, find the table name and column names when writing to the

[sqlite] NOP INSERT still writes to the DB/journal

Hello, On Mon, Dec 7, 2015 at 5:05 PM, Patrick Donnelly wrote: > Update on this: > > On Mon, May 5, 2014 at 4:53 PM, Patrick Donnelly > wrote: >> Hi, >> >> I have an INSERT that looks like >> >> INSERT INTO T >> SELECT ... >> >&

[sqlite] NOP INSERT still writes to the DB/journal

On Mon, Dec 7, 2015 at 11:51 PM, Simon Slavin wrote: > > On 8 Dec 2015, at 12:19am, Patrick Donnelly wrote: > >> There are still writes: > > Because you have not defined any transactions, each of your INSERT commands > it getting wrapped in its own transaction. A tr

[sqlite] NOP INSERT still writes to the DB/journal

On Mon, Dec 7, 2015 at 5:31 PM, Igor Tandetnik wrote: > On 12/7/2015 5:05 PM, Patrick Donnelly wrote: >> >> No rows were inserted but there are several writes. This behavior >> seems to be caused by AUTOINCREMENT? > > > Could be creating sqlite_sequence table wh

[sqlite] NOP INSERT still writes to the DB/journal

Update on this: On Mon, May 5, 2014 at 4:53 PM, Patrick Donnelly wrote: > Hi, > > I have an INSERT that looks like > > INSERT INTO T > SELECT ... > > which I'm running numerous times a second that generally does nothing > because the SELECT returns no rows

[sqlite] misleading note in the documentation for WAL

a transaction before the next writer, then the log file will not be restarted? [I assume this is why SQLITE_CHECKPOINT_TRUNCATE was added?] [1] https://www.sqlite.org/c3ref/wal_checkpoint_v2.html [2] https://www.sqlite.org/wal.html -- Patrick Donnelly

[sqlite] Extremely long running END (EXCLUSIVE) TRANSACTION in WAL mode

automatic checkpoints are "passive" and so should not block the checkpointer? I don't see how the writer is being blocked for so long. Can anyone provide hints on how to further debug this? -- Patrick Donnelly

[sqlite] random row from group

n-standard solutions which aren't supported in sqlite. For example: select distinct on (id) id, attribute from like_this order by id, random() from http://stackoverflow.com/questions/16044828/select-random-row-for-each-group Any pointers would be appreciated! -- Patric

[sqlite] NOP INSERT still writes to the DB/journal

to eliminate the INSERT by using a SELECT first to check if there are no rows? Something like: CREATE TEMPORARY VIEW V AS SELECT ... SELECT COUNT(*) FROM V; /* If > 0 */ INSERT INTO T SELECT * FROM V; ? Thanks, -- Patrick Donnelly ___ sqlite-users mail

Re: [sqlite] Where did the release announcements go?

> > This is the right place to go. Here you find announcements of new > versions, planned updates and bug-fixes even before they arrive at > > Recent SQLite News No, I think they're all supposed to show up in sqlite-announce; not sqlite-users. 3.8.4.3 was announced in sqlite-announce. Very

[sqlite] Where did the release announcements go?

I depend on the sqlite-announce list to get updates on new releases. But it seems they haven't been posting there for the last couple releases. Why not? The archive shows the last announcement came for the 3.8.3.1 release. ___ sqlite-users mailing

Re: [sqlite] calculation of a fraction stored in a text column

Simon, > Date: Thu, 20 Feb 2014 14:04:59 + > From: Simon Slavin > > On 20 Feb 2014, at 1:56pm, Patrick Proniewski <pat...@patpro.net> wrote: > >> Thanks for you reply. In fact I would like the script to remain portable. >> I'm running all this on Mac O

Re: [sqlite] calculation of a fraction stored in a text column

AL equivalent to my strings: 1/200 is read as 0.005. Very handy. I'm going to redesign my database in order to include raw data aside human-readable data when I need it. thanks, Patrick ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] calculation of a fraction stored in a text column

hi Kevin, On 20 févr. 2014, at 14:11, Kevin Martin wrote: > > On 20 Feb 2014, at 12:54, Patrick Proniewski <pat...@patpro.net> wrote: > >> My problem is that my database holds too many different values for >> ExposureTime, so the resulting plot is unreadable. I

[sqlite] calculation of a fraction stored in a text column

uot;0.000166", "0.004" during my SELECT request for "binning"/sorting and counting purposes. I've started to work on an over-complex substr()+instr() combo that is not finished yet, but will probably be a dead-end. Is there a straightforward way to do this, instead of cond

Re: [sqlite] select/count/group by question

and Richard for your fast replies. It solved my problem. I thought about using sum() or total() but the ISO==100 part is something I would never have thought about. thanks again, Patrick ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] select/count/group by question

ult, without success. Full table with create statement is available here: http://patpro.net/~patpro/exifdata.sql.zip (106 kB). Any hint appreciated! Thanks, Patrick ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] logical to use sqlite to replace Berkeley DB ?

AND and add SQL functionality to the language. Thanks again-Patrick ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] logical to use sqlite to replace Berkeley DB ?

? Thanks for reading-Patrick ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] New Optimizations in 3.7.16 -- Explain please?

> Can someone give me a case where the new changes make a difference in > relation to the following two changes: > > (from http://www.sqlite.org/releaselog/3_7_16.html) > - Enhance virtual tables so that they can potentially use an index > when the WHERE clause contains the IN operator. > - Allow

[sqlite] Q: When to use sqlite3_shutdown ?

When is there a need to use sqlite3_shutdown? I don't really see a clear explanation of when/how its needed. Any tips, please? Thanks! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] New Optimizations in 3.7.16 -- Explain please?

Can someone give me a case where the new changes make a difference in relation to the following two changes: (from http://www.sqlite.org/releaselog/3_7_16.html) - Enhance virtual tables so that they can potentially use an index when the WHERE clause contains the IN operator. - Allow indices to be

Re: [sqlite] internals. IPC or disk write based?

r very helpful post. Actually for everything I want to do DB-wise, sqlite is perfect . I actually wanted to understand this to use in a totally different project using the Ada language. Have a great day-Patrick ___ sqlite-users mailing list sqlite

[sqlite] internals. IPC or disk write based?

Hi Everyone I bought the Apress book. There is a chapter on internals. I have tried to read what I could find on the net too but I am still mixed up about something. I don't know how sqlite interacts with visitors while maintaining state. If everything was read into memory it would be easy

[sqlite] Select into outfile C API

Is their a syntax similar to mysql's 'SELECT INTO OUTFILE' in the C API? I see the sqlite3 binary has an interactive .output parameter. Anything similar in the C API? TIA Pat... ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Select into outfile C API

Is their a syntax similar to mysql's 'SELECT INTO OUTFILE' in the C API? I see the sqlite3 binary has an interactive .output parameter. Anything similar in the C API? TIA Pat... ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Problem with a SELECT DISTINCT query in Version : 3.7.8

r the test : "test.db". Regards. Patrick. -- *Patrick Villette* *Innovation Net* courriel : patrick.ville...@innovation-net.fr ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] feed "endless" data into sqlite, thru a shell script

On 28 sept. 2011, at 13:38, Paul Linehan wrote: >> The granularity I'm looking for is between 1 second and 10 seconds. Cron is >> not >> an option here. > > I woke up this morning and there is a way that cron *_could_* do what you > want. You appear to have figured out a way that suits you, but

Re: [sqlite] feed "endless" data into sqlite, thru a shell script

On 27 sept. 2011, at 23:11, Scott Hess wrote: > On Tue, Sep 27, 2011 at 2:07 PM, Patrick Proniewski <pat...@patpro.net>wrote: > >> On 27 sept. 2011, at 20:18, Gabor Grothendieck wrote: >>> gawk has fflush() >> >> none of them is available out of th

Re: [sqlite] feed "endless" data into sqlite, thru a shell script

On 27 sept. 2011, at 20:44, Paul Linehan wrote: > 2011/9/27 Patrick Proniewski <pat...@patpro.net>: > >>> Take a look at a utility called dstat. > >> no, it's linux only. > > But it is written in Python - so it should be relatively > transportable.

Re: [sqlite] feed "endless" data into sqlite, thru a shell script

On 27 sept. 2011, at 20:41, Paul Linehan wrote: > 2011/9/27 Patrick Proniewski <pat...@patpro.net>: > >> That's what I do, but I think using a loop is ugly, and I would like to find >> a way >> to feed data continuously into sqlite. > > I can't see why you

Re: [sqlite] feed "endless" data into sqlite, thru a shell script

On 27 sept. 2011, at 20:18, Gabor Grothendieck wrote: > gawk has fflush() On 27 sept. 2011, at 20:29, Roger Andersson wrote: > stdbuf? > unbuffer? none of them is available out of the box on Mac OS X, or FreeBSD. gawk can be installed, but I'd rather use my "while true" loop instead of

Re: [sqlite] feed "endless" data into sqlite, thru a shell script

On 27 sept. 2011, at 20:14, David Garfield wrote: > Any entry in a pipe could be buffering. In a quick test here, awk is > buffering. To find the buffering, try using the pieces up to a given > stage with " | cat " added at the end. If this buffers, you've found > the problem. as far as my

Re: [sqlite] feed "endless" data into sqlite, thru a shell script

On 27 sept. 2011, at 20:04, Paul Linehan wrote: > 2011/9/27 Patrick Proniewski <pat...@patpro.net>: > > >> I'm facing a challenging problem. I want to log some data into an SQLite3 DB. >> Data come from a system command (iostat) in an endless steam, one row every

Re: [sqlite] feed "endless" data into sqlite, thru a shell script

On 27 sept. 2011, at 18:31, Roger Andersson wrote: > I do not know if tee makes any difference or if it's available on Mac? > http://unixhelp.ed.ac.uk/CGI/man-cgi?tee tee is available, but no more luck here, as it won't allow to disable the buffer. > iostat -d -w 10 disk0 | tee -a logfile >

Re: [sqlite] feed "endless" data into sqlite, thru a shell script

On 27 sept. 2011, at 13:44, Simon Slavin wrote: > On 27 Sep 2011, at 12:03pm, Patrick Proniewski wrote: > >> You're assuming I'm running Linux, but I'm running Mac OS X Server (or >> FreeBSD by the way), so no /proc here, and iostat is probably working >> d

Re: [sqlite] feed "endless" data into sqlite, thru a shell script

On 27 sept. 2011, at 08:31, Baptiste Daroussin wrote: > You don't need awk :) > > iostat -d -w 10 disk0 | while read a b c; do case $a in *[a-zA-Z]*) > continue ;; *) sqlite3 iostat.db "INSERT INTO io > VALUES(datetime('now', 'localtime'), \"$a\", \"$b\", \"$c\");" ;; > esac; done Ok, this

Re: [sqlite] feed "endless" data into sqlite, thru a shell script

On 27 sept. 2011, at 08:02, Stephan Beal wrote: > That's a tricky one, it seems. If you're not restricted to shell code, you > could possibly do this using perl, PHP, or similar. You could open a pipe > for iostat, read a line from the pipe, and feed that line to your db (not in > the form of a

Re: [sqlite] feed "endless" data into sqlite, thru a shell script

On 27 sept. 2011, at 12:58, Simon Slavin wrote: > On 27 Sep 2011, at 6:48am, Patrick Proniewski wrote: > >> I've tried various solutions with named pipes, file descriptors >> redirections… but none worked, because they all seem to require the data >> steam to

Re: [sqlite] feed "endless" data into sqlite, thru a shell script

On 27 sept. 2011, at 08:21, Roger Binns wrote: > The easiest solution is to just be patient and accept the data will be a > little delayed. that won't work for me, because my SQL command includes a datetime('now'). Any row input that is delayed won't be recorded with the proper datetime. That's

[sqlite] feed "endless" data into sqlite, thru a shell script

Hello, I'm facing a challenging problem. I want to log some data into an SQLite3 DB. Data come from a system command (iostat) in an endless steam, one row every X seconds: disk0 KB/t tps MB/s 4.02 2318 9.09 4.00 1237 4.83 6.63 979 6.34 46.30 15 0.69 30.58

[sqlite] System.Data.SQLite Release

Just wondering when the next release of System.Data.SQLite will be available. There's a bug, that was already reported and fixed, in the current release that badly breaks NHibernate / ActiveRecord. Patrick Earl ___ sqlite-users mailing list

Re: [sqlite] System.Data.SQLite Reserved Words Bug

Thanks for fixing that so quickly. Looking forward to a new release. Patrick Earl On Sat, Jul 9, 2011 at 2:39 PM, Joe Mistachkin <sql...@mistachkin.com> wrote: > > Patrick Earl wrote: >> >> System.Resources.MissingManifestResourceException was unhandled >>

[sqlite] System.Data.SQLite Reserved Words Bug

nContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() */ Thanks for your help with this. Patrick Earl ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Two Requests for System.Data.SQLite

my life easier. Patrick Earl ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug in sqlite3_bind_parameter_name

That's awesome. Thanks so much. :) ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug in sqlite3_bind_parameter_name

would hope that the SQLite syntax could be parsed by a regex for performance reasons. Patrick Earl On Wed, Jun 1, 2011 at 10:36 AM, Stephan Beal <sgb...@googlemail.com> wrote: > On Wed, Jun 1, 2011 at 6:24 PM, Patrick Earl <pate...@patearl.net> wrote: > >> From these,

Re: [sqlite] Bug in sqlite3_bind_parameter_name

"best" solution seems to be re-tokenizing the sql in the provider. Is there another work-around? It seems that implementing this at the database level would be the most efficient approach. Obviously re-tokenizing all the SQL would be expensive. Patrick Earl

Re: [sqlite] Bug in sqlite3_bind_parameter_name

tioned. I haven't analyzed the consequences of changing or disabling the check in some way. If somebody beats me to it, I'd be happy about that too. :) Patrick Earl ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-b

Re: [sqlite] Bug in sqlite3_bind_parameter_name

the work-arounds aren't major... I haven't had time to look at the picture in depth. Patrick Earl On Tue, May 31, 2011 at 12:47 PM, Jan Hudec <b...@ucw.cz> wrote: > On Tue, May 31, 2011 at 08:00:40 -0400, Richard Hipp wrote: >> On Mon, May 30, 2011 at 11:27 PM, Pat

[sqlite] Bug in sqlite3_bind_parameter_name

ugh nobody may care, this is currently preventing the NHibernate test suite from passing. Appreciate your help with this. :) Patrick Earl ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Lack of "decimal" support

low for custom type storage and operators. Patrick Earl ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Lack of "decimal" support

have to build significant numeric infrastructure into your program to emulate the missing numeric infrastructure in SQLite. Patrick Earl On Sat, Mar 26, 2011 at 9:52 PM, BareFeetWare <list@barefeetware.com> wrote: > On 27/03/2011, at 2:09 PM, Patrick Earl wrote: >

Re: [sqlite] Lack of "decimal" support

cases, but please understand that I'm looking for solutions that don't require the framework to understand the user's intentions any more than "I want to work with base-10 numbers up to a certain precision/scale." Patrick Earl On Sat, Mar 26, 2011 at 8:43 PM, Gerry Snyder &

Re: [sqlite] Lack of "decimal" support

er if there was just native support for base-10 numbers. :) Patrick Earl On Sat, Mar 26, 2011 at 8:15 PM, BareFeetWare <list@barefeetware.com> wrote: > On 27/03/2011, at 12:39 PM, Patrick Earl wrote: > >> Base-10 numbers are frequently used in financial calculations bec

Re: [sqlite] Lack of "decimal" support

appropriately licensed library. Perhaps an author from a numeric library would be willing to donate their work to the SQLite project. Patrick Earl On Sat, Mar 26, 2011 at 7:43 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 27 Mar 2011, at 2:39am, Patrick Earl wrote:

[sqlite] SQLite & NHibernate

that SQLite could participate in a transaction across multiple databases. Perhaps implementing two phase commit would help with this. Thanks for your consideration. Patrick Earl ___ sqlite-users mailing list sqlite-users@sqlite.org http://s

[sqlite] Lack of "decimal" support

consideration. Patrick Earl ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Foreign constraints and table recreation

://patearl.net/files/broken4.txt This problem (or some variation thereof) has been making me crazy for the past three days. So nice to finally have a reasonable looking test case. :) Patrick Earl ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Foreign constraints and table recreation

temporary copies of databases > only to originally delete and replace the originals ? The simplified example I provided had no changes to the tables, but in the real scenario, at least one of the tables will need some sort of modification. Thanks for the detailed rep

Re: [sqlite] Foreign constraints and table recreation

being done by the DB to modify the table is quite time consuming. Thanks for your help with this. Patrick Earl On Mon, May 10, 2010 at 5:18 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 10 May 2010, at 7:34am, Patrick Earl wrote: > >>    PRAGMA foreign_keys

[sqlite] Foreign constraints and table recreation

, Patrick Earl ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Newbie problem using special column name

sql. You will have to make sure that you enclose the > column name every time you (or somone other) uses ist. Thanks. Unfortunately I don't have a choice. An application I don't have control over expects such strange table names. p...@rick > > Martin > > Patrick Ben Koe

[sqlite] Newbie problem using special column name

Can I add a column name containing a dash "-" and if yes, how would I do that? I am asking because I fail to add a column name that contains a dash "-" and I don't know if I cause the problem (easy solution) or if its something else causing this to fail. Here's what I try: sqlite> create

[sqlite] best language match for SQLite?

? I love Python but I LOVE SQLite, I would learn another language just to use it better-Patrick ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

RE: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14?

of at least a reply. - Patrick Bennett -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, April 30, 2007 5:46 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14? Martin Jenkins

RE: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14?

Ok, thanks for pointing that out. I wasn't sure who maintained the binary distribution and based on the recent list activity, I assumed someone who was responsible would've already replied. Patrick -Original Message- From: Martin Jenkins [mailto:[EMAIL PROTECTED] Sent: Monday, April

RE: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14?

No comment at all? That's three users asking for this now. :( Patrick -Original Message- From: Clark Christensen [mailto:[EMAIL PROTECTED] Sent: Friday, April 27, 2007 11:12 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] May I ask why the source distribution mechanism

[sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14?

. If this is how it's going to be from now on, I'll just have to adjust, but if there wasn't any specific reason for changing, you can count this as a vote for the 'old' way. :) Cheers... Patrick Bennett - To unsubscribe, send

[sqlite] help with understanding the C interface

to pass it to the close or other functions within sqlite3. -- = knot in cables caused data stream to become twisted and kinked. http://groups.google.com/group/lispstl http://www.cwelug.org/ Patrick Pippen

[sqlite] using auto increment in java

I am working on a Java program that uses SQLite for its database. I am using auto increment on some of my inserts and am wondering if there is some easy way to retrieve the auto incremented rowid right after inserting. I realize that there is a C++ function that does just that , but googling did

[sqlite] Missing files?

Hello SQLite Community, I found the package and want to test it, it seems very cool indeed from what I hear. So I downloaded the tar-ball of the complete source for version 3.3.4 and tried to compile it. This tar-ball is missing the following files: sqlite3.h, parse.h and opcodes.h The "pure C"

RE: [sqlite] Segmentation fault on large selects

. With the performance improvements I'd much rather be on the latest version. One side note: when I did compile using 32 bit it worked fine on version 3.2.1 but that wasn't an option I could use on those machines. Thanks, Patrick -Original Message- From: scunacc [mailto:[EMAIL PROTECTED

[sqlite] difference between sqlite3_reset() and sqlite3_clear_bindings()

Can someone please explain the difference between sqlite3_reset() and sqlite3_clear_bindings() and when would I use one over the other. I've read the 3.2.2 docs and it's not 100% clear to me. Thanks

Re: [sqlite] using sqlite as a temporary database to process lots of data

I am currently using SQLite to process @ 400 million records (and climbing) a day by reading files, importing them into SQLite, and summarizing. The summed data goes into Oracle. This is a production application that is very stable. Holding the data in SQLite in memory as opposed to a C struct

[sqlite] PRAGMA page_size problems

ose is. 2. Why did my process crash at row 24xx when I didn't override the default? 3. What should happen if I try to set it above the Max default of 8192? Thanks, Patrick

Re: [sqlite] BLOB read/write in chunks?

Ran across this this morning ... removed in 3.0 (10) Are there any known size limits to SQLite databases? As of version 2.7.4, SQLite can handle databases up to 241 bytes (2 terabytes) in size on both Windows and Unix. Older version of SQLite were limited to databases of 231 bytes (2

Re: [sqlite] how to COPY FROM stdin in 3.x?

Is this also true for for in memory databases? - Original Message - From: "D. Richard Hipp" <[EMAIL PROTECTED]> To: Sent: Wednesday, May 04, 2005 5:03 PM Subject: Re: [sqlite] how to COPY FROM stdin in 3.x? On Wed, 2005-05-04 at 13:49 -0700, Darren Duncan

Re: [sqlite] OT: General SQL Question

ey" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Saturday, April 30, 2005 7:36 AM Subject: Re: [sqlite] OT: General SQL Question well audititems has a field parentauditid which links into audits. Audits has a supplierid field which is the key on suppliers.. From

Re: [sqlite] OT: General SQL Question

It is possible depending on the make up of the tables. post the table structures and index / keys and I'll help - Original Message - From: "Dan Keeley" <[EMAIL PROTECTED]> To: Sent: Saturday, April 30, 2005 6:38 AM Subject: [sqlite] OT: General SQL Question

Re: [sqlite] does sqlite run on 64 bit?

This is HPUX 11.11 and I'm using the tcllib. gcc 3.4.3. - Original Message - From: "Ulrik Petersen" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Friday, April 29, 2005 6:32 PM Subject: Re: [sqlite] does sqlite run on 64 bit? Hi Patrick, Patrick

[sqlite] does sqlite run on 64 bit?

Has anyone been successful running SQLite on a 64 bit platform? If so, what platform? Using C libs or TCLSQLite? I am having limited success and need guidance. Thanks

[sqlite] memory fault in TCLSQLLite on HPUX 11.11 64 bit creating table

Hello, I am consistantly getting a memory fault in sqlite both through the tclsqlite shared library and the sqlite3 executable when I try to create a table. I have tried both sqlite 3.2.1 and 2.8.16. The TCL Versions tried are 8.4.6 and 8.4.9. I have had success on 32bit HPUX 11.11 but when

[sqlite] Improving text search using LIKE '%string to search%'

in database, but are very very long with 50 texts in database. Is exist any method to improve this kind of search ? -- Patrick Peccatte - Soft Experience