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
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
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
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
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
> >
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
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
_
> 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
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
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
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,
>
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
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
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
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
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
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
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
_
> 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
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
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
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
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?
>
>
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
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
-----
> 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
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
> 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
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
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-
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
gle user, read only.
> >
> > TIA
> >
> > kimb
> >
> >
> >
> >
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mai
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
>
--
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
> 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
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
; -- 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
//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
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?
> >> >
;
> > Without more details on your use case, people will only get
> > general advice like the above.
> >
> >>Thanks.
> >
> > Hope this helps.
> > --
> > ( Kees Nuyt
> > )
> > c[_]
> > _
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
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
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@
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
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]
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]
___
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
(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]
___
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
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
>
>
>
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
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
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
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...
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
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
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
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
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
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
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
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,
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
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
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
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
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]>:
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
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
> >
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
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"
---
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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,
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.
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
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
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
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
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,
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
$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"
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
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
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
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
you only need DBD::SQLite it is self contained
Quoting Leander Gillard <[EMAIL PROTECTED]>:
> Quick question I need answered to send to the sysadmin but do I need to both
>
> download and install sqlite and also use the DBD::SQLite module when coding
> in perl??
>
> I think this is true,
1 - 100 of 108 matches
Mail list logo