Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

2020-03-13 Thread Jim Dodgen
Another lurker here ... I have always preferred mailing lists and found forums to be too fat. That said, I like the fossil forum. It was referred to bring a "enginerish" style which is fine given the audience Kudos for its speed and light weight, No fluff just data. Jim "Jed" Dodgen

Re: [sqlite] multithreaded app with in-memory database and transactions

2020-02-13 Thread Jim Dodgen
I have often wondered what the performance difference is between /dev/shm and :memory: databases Jim "Jed" Dodgen j...@dodgen.us On Thu, Feb 13, 2020 at 4:48 PM Keith Medcalf wrote: > > On Thursday, 13 February, 2020 17:06, Jim Dodgen > wrote: > > >I have pla

Re: [sqlite] multithreaded app with in-memory database and transactions

2020-02-13 Thread Jim Dodgen
I have placed databases on/in /dev/shm and shared them across both threads and processes. Jim "Jed" Dodgen j...@dodgen.us On Thu, Feb 13, 2020 at 2:38 PM Keith Medcalf wrote: > > Correct. "memory" databases can only be shared between connections in the > same process, and then only by the

Re: [sqlite] New word to replace "serverless"

2020-01-29 Thread Jim Dodgen
I vote for ignoring the marketing types and stick with "serverless" Jim "Jed" Dodgen j...@dodgen.us On Wed, Jan 29, 2020 at 10:20 AM Thomas Kurz wrote: > I would not choose a new wording. "Serverless" is correct, and just > because others start using "serverless" in a wrong manner, I don't

Re: [sqlite] Opposite of SQLite

2019-10-10 Thread Jim Dodgen
IMS/DB Jim "Jed" Dodgen j...@dodgen.us On Thu, Oct 10, 2019 at 3:03 PM test user wrote: > CAHeavy > > Chaotic Answer Heavy > > On Thu, 10 Oct 2019 at 20:42, Simon Slavin wrote: > > > On 10 Oct 2019, at 7:55pm, Ned Fleming wrote: > > > > > SQLessLite > > > > SQDietStartsMonday > >

Re: [sqlite] Web hosting and perl DBD::SQLite?

2018-05-11 Thread Jim Dodgen
Any VPSes you suggest? *Jim Dodgen* On Fri, May 11, 2018 at 2:14 PM, Warren Young <war...@etr-usa.com> wrote: > On May 11, 2018, at 2:53 PM, Jim Dodgen <j...@dodgen.us> wrote: > > > > A little off topic, but my hosting company went a way. And after two

[sqlite] Web hosting and perl DBD::SQLite?

2018-05-11 Thread Jim Dodgen
A little off topic, but my hosting company went a way. And after two tries I need to find a hosting company who is not scared of SQLite, specifically have installed or will let me install DBD::Sqlite? *Jim Dodgen* ___ sqlite-users mailing list sqlite

Re: [sqlite] How many AUTOINCREMENT tables are in your schema?

2018-03-19 Thread Jim Dodgen
_ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- *Jim Dodgen* ___ sqlite-users mailing list sqlite-users@mailinglis

Re: [sqlite] Missing data on SELECT

2017-11-02 Thread Jim Dodgen
You are inserting rows with ProjID but not the primary key "id" which is rowid and automatically created. I think it is not a good practice to use rowid's like you are doing. If you had inserted the id it would be a different story. *Jim Dodgen* On Thu, Nov 2, 2017 at 5:26

Re: [sqlite] (no subject)

2017-10-06 Thread Jim Dodgen
Thanks I needed a Laugh, try clicking on one of the links at the bottom of your emails and unsubscribe. *Jim Dodgen* On Fri, Oct 6, 2017 at 7:41 PM, cindy estepp <cindyestep...@gmail.com> wrote: > stop emailing me i do not

[sqlite] about attach database

2015-12-15 Thread Jim Dodgen
You cannot attach to this list. If you can just paste into the body of the email or provide a link to the information *Jim Dodgen* On Tue, Dec 15, 2015 at 9:33 PM, ??? <2004wqg2008 at 163.com> wrote: > > After testing the Sqlite3_open and ATTACH DATABASE, >

[sqlite] Random performance issues with SQLite

2015-11-09 Thread Jim Dodgen
I am not a user of Norton but I expect it has the same features as others. In Windows Defender you can specify files to exclude and that may help. *Jim Dodgen* On Mon, Nov 9, 2015 at 8:44 AM, Richard Hipp wrote: > On 11/9/15, Brice Andr? wrote: > > OK, but if this

Re: [sqlite] Long lived prepared statements

2014-10-06 Thread Jim Dodgen
prepare. But because I have a reference to the handle holed away it is not really "finished" and that is why I am able to continue to use the prepared statement? Is this assumption correct? *Jim Dodgen* On Mon, Oct 6, 2014 at 12:08 AM, Mark Lawrence <no...@null.net> wrote: &g

Re: [sqlite] Long lived prepared statements

2014-10-04 Thread Jim Dodgen
tivity is going to leave a handle or some resource dangling *Jim Dodgen* On Sat, Oct 4, 2014 at 2:34 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 4 Oct 2014, at 10:08pm, Jim Dodgen <j...@dodgen.us> wrote: > > > What I do is to prepare a relatively lar

[sqlite] Long lived prepared statements

2014-10-04 Thread Jim Dodgen
I think I know the answer to this so I'm looking for some conformation. What I do is to prepare a relatively large and complex query. Then I run the same query forever never doing a finalize. My assumption is I will have no memory leakage. *Jim Dodgen

Re: [sqlite] Simple Select from IN - from a newbie.

2014-05-21 Thread Jim Dodgen
I fully agree a bad database design can impact you for the life of the application. If this is a class assignment and the instructor gave you this as a problem then I can understand "I cannot change it" otherwise fix it now or pay forever. *Jim Dodgen* On Wed, May 21, 2014 a

Re: [sqlite] Bug Report

2014-04-17 Thread Jim Dodgen
Ryan, The late Grace Hopper would be happy about your responce *Jim Dodgen* On Thu, Apr 17, 2014 at 10:40 AM, RSmith <rsm...@rsweb.co.za> wrote: > That is just the compiler trying to be helpful without being able to > completely grasp the code and can safely be ignored, b

Re: [sqlite] Unofficial poll

2012-09-23 Thread Jim Dodgen
On Sun, Sep 23, 2012 at 10:25 AM, Yuriy Kaminskiy <yum...@gmail.com> wrote: > Jim Dodgen wrote: >> I program mostly on Perl on Linux and it is a beautiful fit. Example >> is I can have a date field with a POSIX time value (or offset) in it >> or another date related va

Re: [sqlite] Unofficial poll

2012-09-23 Thread Jim Dodgen
_ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Jim Dodgen Watch our travels at: WinoTrips.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] "Bad CPU type in executable"?

2009-08-09 Thread Jim Dodgen
Anyway I can get gmail to post in the middle? :) (smiley face) -- Jim "Jed" Dodgen j...@dodgen.us ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Leading spaces in columns

2009-08-05 Thread Jim Dodgen
In what software is the select being executed? How do you know they are suppressed? On Wed, Aug 5, 2009 at 2:16 PM, Paul Claessen wrote: > I have a number of leading spaces in one of my sqlite columns, but SELECT > result suppresses them. > > Yet I see that the SqliteManager

Re: [sqlite] Installing SQLite

2009-07-23 Thread Jim Dodgen
This is not a simple tool. I is primarily designed to be embedded in applications. Your opinion about the quality of the *install* instructions leads people to believe that you may need a better understanding of the skill level required to use Sqlite. On Wed, Jul 22, 2009 at 1:43 PM, scabral

Re: [sqlite] [Columns] Keeping internal + beautified names?

2009-07-11 Thread Jim Dodgen
I would just use: SELECT id AS Identification FROM foobar On Sat, Jul 11, 2009 at 8:33 AM, Gilles Ganault wrote: > Hello > > Apart from using a table for this very purpose, is there a way to keep > internal names and beautified names for a table's column names? > >

Re: [sqlite] Updating a database by email

2009-07-10 Thread Jim Dodgen
not beyond the realm of possibilities. I back up via email, a nice protocol. I dump > tar > gzip > and email a small but important database to 6 people each day via a cron job. I don't remember exactly how but on unix boxes I have created user accounts that receive emails automatically and then

Re: [sqlite] corrupt database recovery

2009-04-26 Thread Jim Dodgen
et the error, every row higher then >> X also returns an error. So as soon as I get an error, I stop trying to >> recover more rows. > > -- > Software first.  Software lasts! > ___ > sqlite-users mailing list > sqlite-users@sql

Re: [sqlite] pure Java SQLite browser/client?

2009-03-23 Thread Jim Dodgen
----- > From: Jim Dodgen > Sender: sqlite-users-boun...@sqlite.org > To: sqlite-users@sqlite.org > ReplyTo: General Discussion of SQLite Database > Sent: Mar 23, 2009 19:09 > Subject: [sqlite] pure Java SQLite browser/client? > > Anyone know of a pure Java client that can be u

[sqlite] pure Java SQLite browser/client?

2009-03-23 Thread Jim Dodgen
Anyone know of a pure Java client that can be used to browse and run SQL commands? -- Jim Dodgen j...@dodgen.us ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Newbie question

2009-03-18 Thread Jim Dodgen
> Thanx, > Dp. > ___________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Jim Dodgen j...@dodgen.us ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite Transaction Rate and speed...

2009-03-06 Thread Jim Dodgen
oo many users logged in for this account. Try again later. > Login failed. > ftp> > > ___________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Jim Dodgen j...@dodgen.us ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Best GUI?

2009-02-27 Thread Jim Dodgen
s mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> > Real men code in binary. Like CodeBlocks & good old 'sql' myself. > > Michael > ___________ > sqlite-

Re: [sqlite] Newb-ish performance questions

2009-02-22 Thread Jim Dodgen
e size throughout, thus a number of tests fail if that change > is made. Thus for Solaris I've held back on that change for now. > > Nico > -- > ___ > sqlite-users mailing list > sqlite-users@sqlite.or

Re: [sqlite] Newb-ish performance questions

2009-02-19 Thread Jim Dodgen
gle user, read only. > > > > TIA > > > > kimb > > > > > > > > > > ___ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mai

Re: [sqlite] Using SQLLite Crypt with Java

2009-01-31 Thread Jim Dodgen
567049 | 9845844936 | megha.vishwan...@ei-india.com > Educational Initiatives | www.ei-india.com > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > --

Re: [sqlite] SQLite version 3.6.10

2009-01-15 Thread Jim Dodgen
qlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > -- > Peace may sound simple-one beautiful word- but it requires everything > we have, every quality, every strength, every dream, every high ideal. > -Yehudi Menu

Re: [sqlite] request to become co-maintainer of DBD::SQLite

2009-01-14 Thread Jim Dodgen
> Basically I'm doing this because someone has to do it, and I'm as good a > default > person as any until someone better suited (eg, with more C-fu) comes > along and > takes my place. > > Matt, thank you in advance for a quick reply. > > To everyone, please don't actually submit patches to me until I announce > that > I'm ready to receive them, or just send them to RT as you already were. > > -- Darren Duncan > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Jim Dodgen j...@dodgen.us ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite version 3.6.8

2009-01-12 Thread Jim Dodgen
I am having better luck with the amalgamation that has been created by Audrey Tang. My production is still on 3.4 and testing on 3.6 with the amalgamation has been promising On Mon, Jan 12, 2009 at 8:14 PM, Darren Duncan <dar...@darrenduncan.net>wrote: > Jim Dodgen wrote: > > P

Re: [sqlite] SQLite version 3.6.8

2009-01-12 Thread Jim Dodgen
; -- Darren Duncan > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Jim Dodgen j...@dodgen.us ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Update if exists or Insert if exists

2009-01-09 Thread Jim Dodgen
//www.nabble.com/Update-if-exists-or-Insert-if-exists-tp21384054p21384054.html > Sent from the SQLite mailing list archive at Nabble.com. > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/lis

Re: [sqlite] SQLite with NAS storage

2009-01-07 Thread Jim Dodgen
gt; >> >> > >> >> > >> >> On Wed, Jan 7, 2009 at 1:31 PM, P Kishor <punk.k...@gmail.com> > wrote: > >> >> > On 1/6/09, Edward J. Yoon <edwardy...@apache.org> wrote: > >> >> >> > Do you have 20 million sqlite databases? > >> >

Re: [sqlite] SQLite with NAS storage

2009-01-06 Thread Jim Dodgen
; > > Without more details on your use case, people will only get > > general advice like the above. > > > >>Thanks. > > > > Hope this helps. > > -- > > ( Kees Nuyt > > ) > > c[_] > > _

Re: [sqlite] [perl] unable to open database file

2008-12-18 Thread Jim Dodgen
2. I try to chmod 777 -R directory. > > But the error is still exist. How to debug the program? > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-u

Re: [sqlite] TCL Sqlite busy errorcode

2008-12-18 Thread Jim Dodgen
site that mentioned that Sqlite busy crashes a TCL proc > instead of returning an error code of 5. Is this true? > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-use

Re: [sqlite] problem with INTEGER PRIMARY KEY ASC AUTOINCREMENT column

2008-10-21 Thread Jim Dodgen
d automatically? > > Thanks, > Ken > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Jim Dodgen [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@

Re: [sqlite] best language match for SQLite?

2008-09-16 Thread Jim Dodgen
1020093175mrt/direct/01/ > _______ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Jim Dodgen [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Using Sqlite in place of BDB

2008-09-10 Thread Jim Dodgen
have an API that would lend itself well to key/value > pairs? > > Thanks! > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Jim Dodgen [EMAIL PROTECTED]

Re: [sqlite] Entity Relationship Diagram Tool for SQLite

2008-09-03 Thread Jim Dodgen
ing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Jim Dodgen [EMAIL PROTECTED] ___

[sqlite] SQL POSITION function?

2008-09-02 Thread Jim Dodgen
Any plans on adding a string matching function like the SQL99 (E021-11) "POSITION" -- Jim Dodgen [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Importing table

2008-06-17 Thread Jim Dodgen
(see > http://www.sqlite.org/datatype3.html for more details). > > HTH > Dennis Cote > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Jim Dodgen [EMAIL PROTECTED] ___

Re: [sqlite] Connections

2008-05-30 Thread Jim Dodgen
sqlite is serverless and does not have connections in the traditional sense. The database is just a file and the number of programs that can have the file open is dependent upon the operating system. Hildemaro Carrasquel wrote: > Hello.- > > How many connections can i have in sqlite

Re: [sqlite] development vs production

2008-05-10 Thread Jim Dodgen
SQLite is rock solid. Also I don't think it wise to develop on a different DBMS that the one you are going to use in production. sebastian stephenson wrote: > I see that sqlite is great for development but for production would > that be a bright idea? > see ya > > sebey > > >

Re: [sqlite] DBD::SQLite::Amalgamation?

2008-03-31 Thread Jim Dodgen
On 3/31/08, P Kishor <[EMAIL PROTECTED]> wrote: > On 3/30/08, Jim Dodgen <[EMAIL PROTECTED]> wrote: > > Any Perl people out there using this yet (version 3.5.7)? > > > > I'm continually having problems when doing "make test" > > > > It

Re: [sqlite] DBD::SQLite::Amalgamation?

2008-03-31 Thread Jim Dodgen
Humm... I'll keep looking. thanks On 3/30/08, Jim Dodgen <[EMAIL PROTECTED]> wrote: > Any Perl people out there using this yet (version 3.5.7)? > > I'm continually having problems when doing "make test" > > It hangs forever and never completes > > I have trie

[sqlite] DBD::SQLite::Amalgamation?

2008-03-30 Thread Jim Dodgen
Any Perl people out there using this yet (version 3.5.7)? I'm continually having problems when doing "make test" It hangs forever and never completes I have tried this on multiple boxes running both Fedora and Redhat ES, all 64 bit. ___ sqlite-users

[sqlite] build system type... x86_64-unknown-linux-gnu

2008-02-11 Thread Jim Dodgen
I get this when I configure from the source tarball for 3.5.6 Is this importaint? Can I fix it? ./configure checking build system type... x86_64-unknown-linux-gnu checking host system type... x86_64-unknown-linux-gnu checking for gcc... gcc checking for C compiler default output file name...

Re: [sqlite] How to specify regular expression in a query?

2008-01-25 Thread Jim Dodgen
your example only needs a "like" not a regex. not having your schema i'll show a loose example: select id, flilepath from movies where filepath like "%MyMovie.%"; Bharath Booshan L wrote: Hello list, I have to perform a search something similar to this ID FilePath 1

Re: [sqlite] DBD::SQLite for 3.5.4?

2008-01-25 Thread Jim Dodgen
libsqlite3.so.0 => /usr/lib/libsqlite3.so.0 (0xb7ed7000) libc.so.6 => /lib/libc.so.6 (0xb7da7000) libpthread.so.0 => /lib/libpthread.so.0 (0xb7d9) /lib/ld-linux.so.2 (0x4100) On Jan 26, 2008 12:00 AM, Jim Dodgen <[EMAIL PROTECTED]> wrote: than

Re: [sqlite] DBD::SQLite for 3.5.4?

2008-01-25 Thread Jim Dodgen
you are correct. sorry to offend Karsten Bräckelmann wrote: On Thu, 2008-01-24 at 19:41 -0800, Jim Dodgen wrote: sorry I attached another email by accident, it's content is not related to my question No, you pretty much did so on purpose. You *replied* to a previous post, which

Re: [sqlite] DBD::SQLite for 3.5.4?

2008-01-25 Thread Jim Dodgen
l 3.5.4 in /usr/local/lib, you should set SQLITE_LOCATION=/usr/local/lib/ On Jan 25, 2008 5:13 AM, Jim Dodgen <[EMAIL PROTECTED]> wrote: I have tend to build the DBD::SQLite from source, when ever I have built with it looking for sqlite libs it reports a old version older than 3.3.9 or so

Re: [sqlite] DBD::SQLite for 3.5.4?

2008-01-24 Thread Jim Dodgen
read.so.0 (0xb7d7) /lib/ld-linux.so.2 (0x4100) On Jan 25, 2008 4:41 AM, Jim Dodgen <[EMAIL PROTECTED]> wrote: sorry I attached another email by accident, it's content is not related to my question Jim Jim Dodgen wrote: the latest DBD::SQLite (a Perl module) was

Re: [sqlite] DBD::SQLite for 3.5.4?

2008-01-24 Thread Jim Dodgen
sorry I attached another email by accident, it's content is not related to my question Jim Jim Dodgen wrote: the latest DBD::SQLite (a Perl module) was buit with 3.4.2 I have attempted to get a version up to 3.5.2 with no success so far. anyone have any success yet? If so what

[sqlite] DBD::SQLite for 3.5.4?

2008-01-24 Thread Jim Dodgen
the latest DBD::SQLite (a Perl module) was buit with 3.4.2 I have attempted to get a version up to 3.5.2 with no success so far. anyone have any success yet? If so what is the magic. Jim John Stanton wrote: Using Apache is the problem. The connections are not persistent so caching is

Re: [sqlite] Next Version of SQLite

2008-01-13 Thread Jim Dodgen
this was a true complement and nothing else. P Kishor wrote: On 1/13/08, Joe Wilson <[EMAIL PROTECTED]> wrote: --- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote: There are people on this mailing list (ex: Joe Wilson) who appear to read every line of every change that we make to SQLite,

Re: [sqlite] Memory Usage

2007-11-18 Thread Jim Dodgen
One other note, just about all real-time systems limit the dynamic allocation of memory because you lose the deterministic behavior, typically all memory is allocated when the task starts, memory is usually managed internally in standard sized chunks. Also for long running tasks

Re: [sqlite] command

2007-08-30 Thread Jim Dodgen
Also I recommend you get a very basic SQL database book. Quoting John Stanton <[EMAIL PROTECTED]>: > nishit sharma wrote: > > i have given some text in a database file as > > America|england| and many more. > > now i want to replace some text with new text how > > this is possible. Also my

Re: [sqlite] Are parenthesis really needed?

2007-08-24 Thread Jim Dodgen
I don't think so: for example logical operations need to be contained like in a ON or WHERE clause example" WHERE ((a = "X" AND b = "Y") OR z = "W") AND x = "foo" if you remove the parenthesis then it will evaluate differently Bruno S. Oliveira wrote: Hi there, Is there any sort of

Re: [sqlite] UNION?

2007-08-08 Thread Jim Dodgen
would have been nice to see the double parentheses in your example ... I have seen MS Access as well being overly parenthesized, what does the SQL92 standard say about that? Jim Lee Crain wrote: Richard, Thanks for suggesting it but no, I don't think invisible control characters are

Re: [sqlite] Best Match Query

2007-08-06 Thread Jim Dodgen
or with a "like" operator sqlite> create table x (t); sqlite> insert into x values (442); sqlite> insert into x values (44); sqlite> insert into x values (4454); select * from x where 4429845 like t||"%" order by length(t) desc limit 1; 442 Quoting RaghavendraK 70574 <[EMAIL PROTECTED]>:

Re: [sqlite] UI question

2007-08-02 Thread Jim Dodgen
also if the semicolon does not get you back to the prompt you may have an open quoted string so try a "; to close it and get you back. Quoting Dan Kennedy <[EMAIL PROTECTED]>: > On Thu, 2007-08-02 at 08:21 -0600, Scott Derrick wrote: > > This is probably a stupid question but has frustrated

Re: [sqlite] Database designer for SQLite

2007-06-13 Thread Jim Dodgen
I use dezign from www.datanamic.com They don't have a template for sqlite but it is easy make one. Quoting Paul KOENIG <[EMAIL PROTECTED]>: > > > Début du message réexpédié : > > > De : Paul KOENIG <[EMAIL PROTECTED]> > > Date : 13 juin 2007 16:26:56 HAEC > > À : sqlite-users@sqlite.org > >

Re: [sqlite] replace function?

2007-05-15 Thread Jim Dodgen
that would make sence, thanks. Quoting Joe Wilson <[EMAIL PROTECTED]>: > No error when run with most recent SQLite. > replace() may not have existed in 3.3.7. > > --- Jim Dodgen <[EMAIL PROTECTED]> wrote: > > I get an error in version 3.3.7 when using the repl

[sqlite] replace function?

2007-05-14 Thread Jim Dodgen
I get an error in version 3.3.7 when using the replace function as defined here: http://sqlite.org/lang_expr.html "replace(X,Y,Z) Return a string formed by substituting string Z for every occurrance of string Y in string X. The BINARY collating sequence is used for comparison" ---

[sqlite] nevermind: [sqlite] DBD::SQLite 1.13 and v 3.3.15

2007-04-11 Thread Jim Dodgen
I figured it out, i needed to pass a parm to Makefile.Pl to force it to use the local SQLite source. Jim Dodgen wrote: Im having a problem geting the perl DBD working with 3.3.15 I integrated the 3.3.15 source with the perl module and all seemed ok. all is fine with the command line version

[sqlite] DBD::SQLite 1.13 and v 3.3.15

2007-04-11 Thread Jim Dodgen
Im having a problem geting the perl DBD working with 3.3.15 I integrated the 3.3.15 source with the perl module and all seemed ok. all is fine with the command line version (sqlite3) but when I run a perl script i get this: --- cut here --- [EMAIL PROTECTED] perl]# ./sqlite_version.pl

[sqlite] Java wrapper for both windows and linux

2007-03-28 Thread Jim Dodgen
Hello, first off I am not a java guy. I'm a perl C guy. I am getting involved in a upcoming project that needs a java wrapper that will work for both windows and linux. Any preferences? - To unsubscribe, send email

Re: [sqlite] ANN: SQLcc another open source Database manager

2007-03-17 Thread Jim Dodgen
It is working now. Stef Mientki wrote: Jim Dodgen wrote: Server not found I get "Firefox can't find the server at oase.uci.kun.nl." when I click on: http://oase.uci.kun.nl/~mientki/data_www/pic/jalcc/help/jalcc_sqlite.html very weird, it's a server directly

Re: [sqlite] ANN: SQLcc another open source Database manager

2007-03-16 Thread Jim Dodgen
Server not found I get "Firefox can't find the server at oase.uci.kun.nl." when I click on: http://oase.uci.kun.nl/~mientki/data_www/pic/jalcc/help/jalcc_sqlite.html Stef Mientki wrote: Although there are already a lot of database manager, I couldn't find a free (preferable

Re: [sqlite] PayPal Policy Alert

2007-02-01 Thread Jim Dodgen
Ha!! PayPal wrote: Dear sqlite-users@sqlite.org, We recently noticed one or more attempts to log in to your account from a foreign IP address. If you recently accessed your account while traveling, the unusual log in attempts may have been initiated by you. However, if you did not initiate

Re: [sqlite] combining multiple queries

2006-12-14 Thread Jim Dodgen
two tings I would do. 1. further normalize your tag field make it a table keyed by id and tag join to this in your query 2. for genre = "comedy" OR genre = "drama" I would genre IN ("comedy", "drama") you might consider further normalizing genre, to reduce duplication and also allow

Re: [sqlite] ip2long

2006-12-04 Thread Jim Dodgen
I would break each octet into separate fields then compare octet by octet Kevin Waterson wrote: How can I SELECT an IP within a range? All my IP's are stored as 1.2.3.4 but I need to check if each is within a range of long IP's. Can this be done with SQLite? or do I need some sort of external

Re: [sqlite] unsigned shorts in bindInt on ARM

2006-10-20 Thread Jim Dodgen
I suspect a little vs. big endian problem. chetana bhargav wrote: Hi, I saw a strnage problem using unsigned shorts, not sure if any one saw that, I was using an unsigned short for binding it to integer, the lint wasn't complaining and everything seem to go ahead fine, when I tested that on

Re: [sqlite] See table structure

2006-10-20 Thread Jim Dodgen
from the command line in sqlite3: .schema Lloyd wrote: Hi List, In SQLite, to see the table structure which command can I use? (as in Oracle's desc ) Thanks, Lloyd __ Scanned and protected by Email scanner

Re: [sqlite] Segfault on second invalid command

2006-10-06 Thread Jim Dodgen
I do see you problem has gone aways on further emails. the two versions do not interact. SQLite is mostly backward compatible that is you can use newer versions of the software on older versions of the database. But not the reverse. Stephan Brunner wrote: Hi Jim, [description and

Re: [sqlite] Segfault on second invalid command

2006-10-05 Thread Jim Dodgen
This might be related to DBD::SQLite 1.13 defaulting to SQLite 3.3.7? I tend to try and keep my PERL and SQLite Command line at the same version. Quoting Stephan Brunner <[EMAIL PROTECTED]>: > Hi all, > > I hit a problem using SQLite 3.2.8 with perl 5.8.7 and DBD::SQLite 1.13, > ubuntu

Re: [sqlite] Major projects using SQLite

2006-07-14 Thread Jim Dodgen
I am using SQLite for a internal project. I has been under heavy use for over 18 months. It is a CGI application/web service constructed of 31,000 lines of PERL and embedded SQL. It has worked flawlessly. Even upgrades (currently 3.3.5) have been pretty smooth. SQLite rules! thanks to DRH

Re: [sqlite] Update with two tables

2006-05-09 Thread Jim Dodgen
I use this technique frequently and provided things are properly indexed it runs very fast. Quoting Unit 5 <[EMAIL PROTECTED]>: > --- Jim Dodgen <[EMAIL PROTECTED]> wrote: > > > this should work. > > > > UPDATE T1 > > SET T1.colA = (select T

Re: [sqlite] Update with two tables

2006-05-08 Thread Jim Dodgen
this should work. UPDATE T1 SET T1.colA = (select T2.colA from T2 where T1.colC = T2.colC), T1.colB = (select T2.colB from T2 where T1.colC = T2.colC) WHERE EXISTS (select * from T2 where T1.colC = T2.colC); Unit 5 wrote: Hello, I am trying to update values of some columns in a table

Re: [sqlite] Re: what is faster?

2006-04-15 Thread Jim Dodgen
The idea of putting a table per database is a little odd, I expect that is why you did not get an instant answer. typically database table are interrelated and therefore need to be joined to provide useful information. Given that there are some good reasons why you might want to keep some

Re: [sqlite] Update A table

2006-04-05 Thread Jim Dodgen
the way I do it is: update table1 set table1.f1 = (select table2.f1 from table2 WHERE table1.f0 = table2.f0) where exists (select * from table2 WHERE table1.f0 = table2.f0); Francisco Tapia wrote: I want to update data from table1 to table2, i seems I cannot get this to work right,

Re: AW: [sqlite] Bad performance with large joins?

2006-03-25 Thread Jim Dodgen
As has been stated in the past SQLite is a small foot print RDBMS, one of the things keeping it small is that it does not have a large query optimizer. One of the things that can happen is if you have lots of indexes the optimizer may pick something non optimum My tricks are as follows: 1.

Re: [sqlite] Performance & database design

2006-03-22 Thread Jim Dodgen
Back in my past I used Oracle OCI and did "array" inserts where you would load an array for each column to be inserted. bind the arrays to the insert statement and then do a big insert. It was a quite fast way to load data. Joe Wilson wrote: Some people on the list have noted that inserting

[sqlite] retreving the column names for a query (PERL)

2006-03-22 Thread Jim Dodgen
for a query like select * from a join b on a.x = b.z anyone know how to get all the column names of the fields that would be returned from the query? I am using the DBD::SQLite PERL module Thanks Jim

Re: [sqlite] performance statistics

2006-03-01 Thread Jim Dodgen
Quoting [EMAIL PROTECTED]: > > I anticipate 2 bottlenecks... > > 1. My anticipated bottleneck under postgres is that the DB-writing app. > must parse incoming bursts of data and store in the DB. The machine > sending this data is seeing a delay in processing. Debugging has shown > that the

Re: [sqlite] Managing trees in the database

2006-02-19 Thread Jim Dodgen
Jim C. Nasby wrote: On Thu, Feb 16, 2006 at 08:23:43PM +0100, Philipp Kn?sel wrote: SanjayK schrieb: Since SQLite is perfect for use in single-user desktop utility applications and since such applications typically store hierarchial data (tree) in a single table, it would be nice to

Re: [sqlite] Disable index?

2006-02-19 Thread Jim Dodgen
one simple trick I first started using with oracle and also use with sqlite is to do the following on the where clause for numerics where filda = fldb+0 for strings where flda = fldb||"" this would cause a index on fldb to be ignored during optimization Jim Dennis Cote wrote: On 2/18/06,

Re: [sqlite] problem with blobs (perl code)

2005-12-01 Thread Jim Dodgen
Perl is mostly typeless, or more correctly has late dynamic binding. No way to tell between a scalar used as a string, or a blob. I see no down side in having to specify the SQL_BLOB type when access a BLOB field, I just would help to have know that. JIm Dodgen Quoting [EMAIL PROTECTED

Re: [sqlite] problem with blobs (perl code) workaround

2005-11-30 Thread Jim Dodgen
$sth->finish; } --- complete test program --- #!/usr/bin/perl -w # # jim dodgen 2005 use Carp; use DBI; use DBI qw(:sql_types); use strict; my %attr = (PrintError => 1, RaiseError => 0, AutoCommit => 0); my $dbh = DBI->connect("dbi:SQLite:slurp.db"

[sqlite] problem with blobs (perl code)

2005-11-30 Thread Jim Dodgen
I am having a problem with blobs, I seem to insert ok but only get three (3) bytes when I query it back. yes I am setting LongReadLen. any ideas? thanks Jim I'm using sqlite 3.2.7, 1.09 and of the perl module also code and test results are below. also when I use the command line sqlite3 I

Re: [sqlite] howto exit ?

2005-11-03 Thread Jim Dodgen
the ...> indicates uou are continuing a statement, from you r example it looks like you are lost. at this point you need to do what is needed to complete a statement, even though the statement is garbage, try typing a ; (to end a sql statemtent. you could be inside a quote so type a "; or '; to

Re: [sqlite] Does SQLite have a fulltext search like MySQL?

2005-07-05 Thread Jim Dodgen
look at the glob command it works like like except uses the unix file name globbing style of matching not quite a grep select * from table where a glob '[abc]foobar*'; At 06:47 PM 7/5/2005, you wrote: like this? select * from table where a like '%abc%'; SQLite also makes it easy to write

Re: [sqlite] Relationship between 2 tables

2005-05-17 Thread Jim Dodgen
I use triggers to do this. Quoting Jay Sprenkle <[EMAIL PROTECTED]>: > On 5/17/05, Svetlik Slavomir <[EMAIL PROTECTED]> wrote: > > Hi, I am new in this forum, but not in SQLite3. I successfully used > > SQLite3.dll with Rapid-Q (very good programming language - clone of > > Q-Basic), basic

  1   2   >