[sqlite] concurrent users?
Hi, I've read many things, some conflicting, about concurrent users on a Sqlite database. The feeling I get is that Sqlite is good for a standalone desktop database, but should not be used in a concurrent user situation (like a website with many users). Is there a definitive answer? thanks! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
RE: [sqlite] Re: www.sqlite.org broken?
:( That's pretty sad -- some people need to go out and get real lives or something... -Original Message- From: D. Richard Hipp [mailto:[EMAIL PROTECTED] Sent: Monday, August 16, 2004 8:36 AM To: [EMAIL PROTECTED] Subject: [sqlite] Re: www.sqlite.org broken? Christian Smith wrote: > Richard, > Non of the cvstrac links work, so the bugs, wiki etc. are unavailable. > > Just in case you didn't know. > There is a denial-of-service attack underway from 210.120.128.117. I'm working on the problem now. Thanks -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
RE: [sqlite] Version 3.0.0 ALPHA now available
Question: Does or will 3.0 offer support for the ALTER TABLE command? Shawn -Original Message- From: D. Richard Hipp [mailto:[EMAIL PROTECTED] Sent: Friday, June 18, 2004 8:33 AM To: [EMAIL PROTECTED] Subject: [sqlite] Version 3.0.0 ALPHA now available Version 3.0.0 (alpha) of SQLite is now available on the website. http://www.sqlite.org/ http://www.sqlite.org/version3.html http://www.sqlite.org/capi3.html This is an alpha release intended for testing and evaluation only. Version 3 is not yet ready for production use. A file format and API freeze is scheduled for July 1. Users are encouraged to evaluate this release and make suggestions on how to improve the interface prior to that date. Anonymous CVS access has been reenabled. -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] what's the character limit of a single sql in sqlite?
Is there a reason you don't want to use a begin transaction, then insert everything, then end the transaction? It is extremely efficient to do this. Shawn -Original Message- From: Xuer [mailto:[EMAIL PROTECTED] Sent: Monday, June 14, 2004 11:56 PM To: [EMAIL PROTECTED] Subject: [sqlite] what's the character limit of a single sql in sqlite? could i use a long,long sql sentence to insert many items into a table once without limit? or there IS a limit so i have to accomplish it by doing it for multi times? thanks in advance.:) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] re: academic software licensing (delphi)
You do realize that you do not need BDE anymore to just use the TDataSet, right? Borland got rid of that requirement about 2 years ago (Around Delphi 6), if memory serves :) Other than that, I agree, the free edition is a totally acceptable choice. Shawn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 1:59 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [sqlite] re: academic software licensing (delphi) "you get to use all of the great database functionality that Borland's VCL offer" unless of course you think borland's data-aware components aren't so great.. imho, they are just unnecessary overhead, making things more complex than they should and limit you in usage of features that makes particulair sql databases so great. i agree that for vcl apps they may be ok, but as soon as 95% of your apps database interventions has nothing to do with user interaction, it is just a waist of resources and lines of code. there are several wrappers for sqlite available for delphi, which indeed may take some initial learning time instead of dropping some components on a form, but the results are there. i use sqlite in some dll's for example, i must not even think about having clients to install the BDE. in one app i need every bit of speed sqlite can offer, and even that is hardly enough (did some caching where possible, but even then sqlite is very rapidly a lot faster than your own non-indexed lookup table).. it entirely depends on the type of app you build, but even where i have user-forms filling some database content, i prefer to do it manually because you are far more flexible, and most of the time there are special conditions or checks that would be impossible (or very tough) to implement if all controls were data-aware. but, even if you favour data-aware, there is no need at all to use delphi or kylix professional editions. ZEOS components let you have data-aware (and borland-compatible) components that will work in the personal editions. I did not verify if they implement sqlite yet, but i bet they did and else they probably will do so soon. just my 2 cents.. rene Op vrijdag, juni 4. 2004 17:50:01 schreef "Shawn Anderson" <[EMAIL PROTECTED]> : > Yes, but it you right the component around TdataSet you get to use all > of the great database functionality that Borland's VCL offers, as well > as tons of 3rd party components. > > Shawn > > -Original Message- > From: Jay Macaulay [mailto:[EMAIL PROTECTED] > Sent: Friday, June 04, 2004 11:34 AM > To: [EMAIL PROTECTED] > Subject: Re: [sqlite] re: academic software licensing (delphi) > > > hi- > > > > i dont think delphi 7 personal edition will work with sqlite (not > > 100% sure though). > > i believe i need more than a tdataset that works with sqlite to get > > it to work with delphi 7 personal edition. > > there is an alternative however. http://ibobjects.com seems to be > > very generous with licensing of the products for a hobbyist as long > > as you abide by NOT writing commercial software. > > It looks like exactly what i was > > searching for. I will write the company and see if i can get the > > special license. Only thing is i will be using firebird if i go > > this route instead. They have a nice brand new manual at amazon (800 > > pages) on firebird databases. > > > > Just a quick note, you don't need a TDataSet to use sqlite. In fact I > avoid TDataSet because I have no need for everything it offers. I > just wrote my own code around the sqlite.dll and then wrote a > component around that to make it a bit more robust. Basically the > same way you'd do it in C. Delphi is a great language to learn if you > want to write up some quick apps in windows/linux. If you're looking > to distribute source code, then the most universally known language would be C obviously. > > > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] re: academic software licensing (delphi)
Yes, but it you right the component around TdataSet you get to use all of the great database functionality that Borland's VCL offers, as well as tons of 3rd party components. Shawn -Original Message- From: Jay Macaulay [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 11:34 AM To: [EMAIL PROTECTED] Subject: Re: [sqlite] re: academic software licensing (delphi) > hi- > > i dont think delphi 7 personal edition will work with sqlite (not 100% > sure though). > i believe i need more than a tdataset that works with sqlite to get it > to work with delphi 7 personal edition. > there is an alternative however. http://ibobjects.com seems to be very > generous with licensing of the products for a hobbyist as long as you > abide by NOT writing commercial software. > It looks like exactly what i was > searching for. I will write the company and see if i can get the > special license. Only thing is i will be using firebird if i go this > route instead. They have a nice brand new manual at amazon (800 pages) > on firebird databases. > Just a quick note, you don't need a TDataSet to use sqlite. In fact I avoid TDataSet because I have no need for everything it offers. I just wrote my own code around the sqlite.dll and then wrote a component around that to make it a bit more robust. Basically the same way you'd do it in C. Delphi is a great language to learn if you want to write up some quick apps in windows/linux. If you're looking to distribute source code, then the most universally known language would be C obviously. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] re: academic software licensing (delphi)
Question: Why not use the totally free version of C++Builder and just create a VCL component for SQLite -- the VCL component can then be used from either C++ Builder or Delphi. Shawn -Original Message- From: Fred Williams [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 10:18 AM To: [EMAIL PROTECTED] Subject: RE: [sqlite] re: academic software licensing (delphi) With personal edition of Delphi, you will have to rely on third party software to gain some of the functionality of the more expensive versions. With personal edition you should have all you need to develop an API level interface to SQLite, if you wish to remain totally "free." If you have any past programming experience, you will be doing productive work with Delphi long before two years. I'd guess two to three months if your not in a hurry. API interface development may take a little longer. Should you wish to go professional an upgrade to Delphi Professional will only cost you 300 - 400 dollars. When I quit professional development that was about an afternoon's work revenue, if I took off a little early :-) Fred > -Original Message- > From: jim mcnamara [mailto:[EMAIL PROTECTED] > Sent: Friday, June 04, 2004 5:26 AM > To: [EMAIL PROTECTED] > Subject: [sqlite] re: academic software licensing (delphi) > > > hi- > > i dont think delphi 7 personal edition will work with sqlite (not 100% > sure though). > i believe i need more than a tdataset that works with sqlite to get it > to work with delphi 7 personal edition. > there is an alternative however. http://ibobjects.com seems to be very > generous with licensing of the products for a hobbyist as long as you > abide by NOT writing commercial software. > It looks like exactly what i was > searching for. I will write the company and see if i can get the > special license. Only thing is i will be using firebird if i go this > route instead. They have a nice brand new manual at amazon (800 pages) > on firebird databases. > > I will see if i can go this route. I dont know if i can pull it off. > Nothing beats sqlite and its tcl bindings for ease of use that i have > ever ran across. I will have lots to learn and it wont be easy > (pascal language, code specific to delphi, ibo components, and > firebird). It will take about 2 years of learning before I probably > get the hang of it (if ever). > > thanks for everyones advice. > > goodbye, > jim > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] Newbie questions
I would be interested in the PDF file. Shawn -Original Message- From: Stéphane Rivière [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 10:22 AM To: D. Richard Hipp Cc: [EMAIL PROTECTED] Subject: Re: [sqlite] Newbie questions > place? What doe a descending index give you that you don't have with > an ascending index? Nothing for my objectives. I've just missed that point. Sorry. I've done a 141 pages /407 Kb PDF file from the SQLite web site, in order to merge the most important informations from it. I wonder if this PDF could be of some interests for others SQLite new users... --- I've also found the mailing list archives url in order to investigate about cursors (I'm a SQL newbie too). - I've seen forward cursors can be emulated by existing SQLite commands, so that a very good point. - But what about backward cursors ? (I can't use huge buffers because of tables sizes). Reading the sqlite odbc driver sources, it appears (to my weak knowledge) that this driver has a "SQL_CURSOR_FORWARD_ONLY" capability. (There is some cases backward cursors are useful for end-user needs). Do you have any idea/trick/workaround to solve this ? Thanks for your help. Anyway, SQLite appears to be a very fine piece of software. The design is original and the code is really clear and heavily commented. I'm definitly not a C expert but I feel I may learn a lot reading the SQLite sources. Regards -- Stephane Riviere Oleron Island - France http://stephane.rochebrune.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] Question about expected query result??
Thanks for the info :) I might have typo in the original email because all of these cols do exist in my database, and this query does in fact run -- which I agree is a little odd. I did run it with both ClientIP and ClientDomain in the GROUP BY -- it ran either way (bug?). I completely forgot about the HAVING clause, so I will give that a try. Thanks again :) Shawn -Original Message- From: Darren Duncan [mailto:[EMAIL PROTECTED] Sent: Friday, May 14, 2004 12:40 AM To: [EMAIL PROTECTED]; Shawn Anderson Subject: Re: [sqlite] Question about expected query result?? At 11:05 PM -0400 5/13/04, Shawn Anderson wrote: >When I run the following query, I get back 0 results -- anyone have any >thoughts? I am expecting to get back 3 records. > >SELECT > DISTINCT ClientIP, ClientDomain, COUNT(ClientDomain) AS >ClientDomainCount FROM > SMTPLog >WHERE > ClientDomainCount > 1 >GROUP BY > ClientIP >ORDER BY > ClientDomainCount DESC, ClientDomain ASC Actually, I'm surprised that you didn't get a parse/syntax error with that query, such as for referencing columns that don't exist. In any event, the problem is about order of execution. Expressions in the SELECT list are evaluated after the GROUP BY clause is evaluated, which is after FROM and WHERE are evaluated. If you want to filter your output based on the results of a group function, you need to put the search condition in the HAVING clause. HAVING looks like WHERE but it runs after GROUP BY. Moreover, if you want to use a field in the SELECT list when you have a GROUP BY clause, then that field has to be in the GROUP BY list. Its an error if you don't. And COUNT doesn't take any arguments anyway, besides '*', as they don't make sense. So try this: SELECT ClientIP, ClientDomain, COUNT(*) AS ClientDomainCount FROM SMTPLog GROUP BY ClientIP, ClientDomain HAVING ClientDomainCount > 1 ORDER BY ClientDomainCount DESC, ClientDomain ASC Does that work? -- Darren Duncan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] Question about expected query result??
I have the following table/data ClientIPClientDomain 63.149.28.33mail.serverlocation.com 63.149.28.33mail.serverlocation.com 63.149.28.33mail.serverlocation.com 63.149.28.33mail.serverlocation.com 211.141.67.7xmailserver.org 211.141.67.7xmailserver.org 211.141.67.7xmailserver.org 68.80.189.111 ravensorb 128.205.7.58acsu.buffalo.edu 66.35.250.206 sc8-sf-list1.sourceforge.net 128.205.7.57acsu.buffalo.edu 128.205.7.57acsu.buffalo.edu 128.205.7.57acsu.buffalo.edu 128.205.7.57acsu.buffalo.edu 128.205.7.57acsu.buffalo.edu 128.205.7.57acsu.buffalo.edu 128.205.7.57acsu.buffalo.edu 128.205.7.57acsu.buffalo.edu 128.205.7.57acsu.buffalo.edu 128.205.7.57acsu.buffalo.edu 68.85.92.99 eye-catcher.com When I run the following query, I get back 0 results -- anyone have any thoughts? I am expecting to get back 3 records. SELECT DISTINCT ClientIP, ClientDomain, COUNT(ClientDomain) AS ClientDomainCount FROM SMTPLog WHERE ClientDomainCount > 1 GROUP BY ClientIP ORDER BY ClientDomainCount DESC, ClientDomain ASC
RE: [sqlite] SQLite version 3 design question: '500'=500?
Question about support for new intrinsic types, any chance you can add support for DATETIME as well? I mean I really like the date time options available at the moment, but it would be nice if we could do SQL standard queries on datetime columns. Shawn - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] SQLite version 3 design question: '500'=500?
I agree, I would like to see compatibility with results from other SQL engines... Shawn -Original Message- From: Keith Herold [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 12, 2004 8:38 PM To: [EMAIL PROTECTED] Subject: RE: [sqlite] SQLite version 3 design question: '500'=500? In MS SQL 2000, through the query analyzer SELECT '500' = 500 returns 500 . SELECT 500 = '500' returns Server: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near '='. Beyond these, I have no preference on whether they are true or false; I am less worried about what the programming languages say as far as PERL, etc. . I would rather the return look like the majority vote on what the 'other' SQL engines/manufacturers do. --Keith > -Original Message- > From: D. Richard Hipp [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 12, 2004 5:20 PM > To: [EMAIL PROTECTED] > Subject: [sqlite] SQLite version 3 design question: '500'=500? > > > The development team is making progress on SQLite version 3.0. But > we've run across an interesting puzzle. What should be returned by > this: > > SELECT '500'=500; > > Is the result "0" or "1"? In other words, what happens when you > compare a number to a string that looks like that number. > Are they equal or not? > > Other languages return a mixture of results here. Strings and number > compare equal in AWK, Perl, PHP, Tcl, and SQLite version 2. String > and numbers are not equal in Python and Ruby. > > Based on my experience, I would choose to make strings and numbers > equal. But there are complications to that approach in SQLite 3.0. > SQLite 3 supports manifest typing with 4 basic types: NULL, NUMERIC, > TEXT, and BLOB. Objects sort in that order: NULLs first, followed by > NUMERICs in numerical order, then TEXT in a user-defined collating > sequence and finally BLOBs in memcmp() order. So '500' occurs at a > completely different place in the sort order from 500. If comparison > operators are to be consistent with sort order, the following must be > true: > > 500 < 600 > 600 < '500' > > But if that is the case, then clearly, '500' != 500. So unless > somebody can come up with a better idea, SQLite version 3.0 will > return "0" for the following: > > SELECT '500'=500; > > On the other hand, the following two statements will return "1" (or > true): > > SELECT '500'+0=500; > SELECT '500'=(500||''); > > Note that in other SQL engines, it is an error to compare a string to > an integer (I think - somebody please correct me if I am wrong) so we > cannot get any guidance there. > > Your thoughts? > -- > D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] Sort by TIMESTAMP?
On draw back to these is that they are pretty much non portable to other
RDBMS. But they look good...
Shawn
-Original Message-
From: Kurt Welgehausen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 11, 2004 11:50 AM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] Sort by TIMESTAMP?
> May try something like
>
> WHERE julianday(DBTimeStamp) < julianday('2004/4/4') but I might be
> wrong.
>
> Lloyd
Or, you could read the docs:
www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
especially the section labeled 'Time Strings'.
Regards
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] Sort by TIMESTAMP?
I'll give it a try, thanks :)
-Original Message-
From: Lloyd thomas [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 11, 2004 10:54 AM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] Sort by TIMESTAMP?
May try something like
WHERE julianday(DBTimeStamp) < julianday('2004/4/4') but I might be wrong.
Lloyd
- Original Message -
From: "Shawn Anderson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 11, 2004 3:33 PM
Subject: RE: [sqlite] Sort by TIMESTAMP?
> You right, I should have tried it :)
>
> A couple of other things that I am noticing;
> - it seems that a col created with TIMESTAMP, is dropping all time
> information and only storing date values
> - I cannot narrow a select down using a TIMESTAMP col for example,
> neither of the follow have any effect:
> WHERE DBTimeStamp < '4/4/2004' or
> WHERE DBTimeStamp < '2004/4/4'
>
> I am trying to do something that is not possible with SQLite?
>
> Thanks
> Shawn
>
> -Original Message-
> From: Will Leshner [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 11, 2004 10:23 AM
> To: Forum SQLite
> Subject: Re: [sqlite] Sort by TIMESTAMP?
>
>
> On May 11, 2004, at 7:17 AM, Shawn Anderson wrote:
>
> > Is it possible to do an ORDER BY on a col marked as TIMESTAMP and have
> > the order come back sorted correctly?
> >
>
> Sure. Try it out and see what happens.
>
>
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] Sort by TIMESTAMP?
You right, I should have tried it :) A couple of other things that I am noticing; - it seems that a col created with TIMESTAMP, is dropping all time information and only storing date values - I cannot narrow a select down using a TIMESTAMP col for example, neither of the follow have any effect: WHERE DBTimeStamp < '4/4/2004' or WHERE DBTimeStamp < '2004/4/4' I am trying to do something that is not possible with SQLite? Thanks Shawn -Original Message- From: Will Leshner [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 10:23 AM To: Forum SQLite Subject: Re: [sqlite] Sort by TIMESTAMP? On May 11, 2004, at 7:17 AM, Shawn Anderson wrote: > Is it possible to do an ORDER BY on a col marked as TIMESTAMP and have > the order come back sorted correctly? > Sure. Try it out and see what happens. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] Sort by TIMESTAMP?
Is it possible to do an ORDER BY on a col marked as TIMESTAMP and have the order come back sorted correctly? Shawn - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] Bulk insert or saving in memory database to file?
Howdy, I was wondering if anyone had any ideas on either of these options? Basically I have about 300 mb of data that I want to insert in a database using SQLite, and I am trying to find the most efficient way of doing it. My thoughts are either to find a fast bulk insert method, or maybe using an in memory database and then write it out at once to disk. Thoughts and suggestions are more than welcome. BTW, I am doing this on the windows platform if that matters. Thanks Shawn
