[sqlite] Appropriate Uses For SQLite

SQLite in GIS I had known about Spatialite, but I hadn't realized that QGIS was using SQLite (both indpendently and through Spatialite). "While PostGIS is generally used on a server to provide spatial database capabilities to multiple users at the same time, QGIS also supports the use of a file fo

[sqlite] Appropriate Uses For SQLite

On 25 Feb 2015, at 8:13pm, Jim Callahan wrote: > I first learned about SQLite in the Bioconductor branch of R. I figured if > they could handle massive genetic databases in SQLite, SQLite ought to be > able to handle a million (or even 12 million) voters in a voter file. I'm guessing that you'

[sqlite] Appropriate Uses For SQLite

Hi Dr. Hipp, group, > In a feeble effort to do "marketing", I am sure that nothing you do is "feeble"! > I have revised the "Appropriate > Uses For SQLite" webpage to move trendy buzzwords like "Internet of > Things" and "Edge of the Network" above the break. See: Nothing wrong with TLAs (s

[sqlite] Appropriate Uses For SQLite

This might give an impression of the scale of what the BioConductor people are doing. "The Gene Expression Omnibus (GEO) at the National Center for Biotechnology Information (NCBI) is the largest fully public repository [as of 2005] for high-throughput molecular abundance data, primarily gene expr

[sqlite] Appropriate Uses For SQLite

I first learned about SQLite in the Bioconductor branch of R. I figured if they could handle massive genetic databases in SQLite, SQLite ought to be able to handle a million (or even 12 million) voters in a voter file. Here is a brief article from 2006, "How to Use SQLite with R" by Seth Falcon. h

[sqlite] Appropriate Uses For SQLite

On Thu, 19 Feb 2015 07:21:17 -0800 Roger Binns wrote: > There is a lot that would have to be done with it: > > - - make the IR stable across releases > - - add more general instructions beyond only what is needed for SQL > - - expose an API that takes the IR > - - possibly redesign it to make st

[sqlite] Appropriate Uses For SQLite

On Thu, 19 Feb 2015 08:31:13 +0100 Olivier wrote: > Hello all, > > https://www.sqlite.org/whentouse.html : > "The amount of web traffic that SQLite can handle depends on how > heavily the website uses its database. Generally speaking, any site > that gets fewer than 100K hits/day should work fin

[sqlite] Appropriate Uses For SQLite

e and Data Dictionary; content-based partitioning) - Report generation - User-Defined tables (script output) -Urspr?ngliche Nachricht- Von: Richard Hipp [mailto:drh at sqlite.org] Gesendet: Mittwoch, 18. Februar 2015 15:34 An: General Discussion of SQLite Database Betreff: [sqlite] Appropriat

[sqlite] Appropriate Uses For SQLite

Strongly agree with using the R package Sqldf. I used both RSQLite and Sqldf, both worked extremely well (and I am both a lazy and picky end user). Sqldf had the advantage that it took you all the way to your destination the workhorse R object the data frame (R can define new objects, but the data

[sqlite] Appropriate Uses For SQLite

> https://www.sqlite.org/whentouse.html : I am currently relying on SQLite as main database engine for blockchain explorers, that's usually between 1 and 2 millions http queries per day, pretty much all of them hitting more than 60 GB of SQLite databases. There is a mix of simple table queries, co

[sqlite] Appropriate Uses For SQLite

ssage- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Wednesday, February 18, 2015 2:34 PM To: General Discussion of SQLite Database Subject: [sqlite] Appropriate Uses For SQLite In a feeble effort to do &quo

[sqlite] Appropriate Uses For SQLite

On Wed, Feb 18, 2015 at 9:53 AM, Richard Hipp wrote: > On 2/18/15, Jim Callahan wrote: >> I would mention the open source statistical language R in the "data >> analysis" section. > > I've heard of R but never tried to use it myself. Is an SQLite > interface built into R, sure enough? Or is tha

[sqlite] Appropriate Uses For SQLite

On 2/19/15, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 02/18/2015 01:28 PM, Jay Kreibich wrote: >> SQLite kind of already does this, if you consider VDBE instructions >> to be an IR. > > There is a lot that would have to be done with it: > > - - make the IR stable

[sqlite] Appropriate Uses For SQLite

Dr Hipp; If you're doing a PR stunt, you should take a lot of these emails and put them on a "What users say" page and link them to the email thread (If it is accessible by the public -- I get this list in my email). That way you'd get real comments about the stability of SQLite against real worl

[sqlite] Appropriate Uses For SQLite

> Simon Slavin > 19 f?vrier 2015 08:54 > > It may be a note in whentouse.html should distinguish between > situations where the database is frequently written-to and situations > where you have data which is rarely changed. The lack of writes means > that a lot

[sqlite] Appropriate Uses For SQLite

Hello all, https://www.sqlite.org/whentouse.html : "The amount of web traffic that SQLite can handle depends on how heavily the website uses its database. Generally speaking, any site that gets fewer than 100K hits/day should work fine with SQLite. The 100K hits/day figure is a conservative est

[sqlite] Appropriate Uses For SQLite

On 19 Feb 2015, at 7:31am, Olivier quoted: > it would be interesting to put *all* sqlite.org pages in the database, even > if it is useless. This would test with 500K HTTP requests per day. It will > then be possible to modify this paragraph and indicate that Sqlite smoothly > manages the 500

[sqlite] Appropriate Uses For SQLite

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/18/2015 01:28 PM, Jay Kreibich wrote: > SQLite kind of already does this, if you consider VDBE instructions > to be an IR. There is a lot that would have to be done with it: - - make the IR stable across releases - - add more general instructi

[sqlite] Appropriate Uses For SQLite

I have found SQLite is uniquely suited to server-based applications of all kinds. Wrapped in a simple custom server it is an outstandingly performant ultra-lightweight engine that can easily service multiple clients. The ability to spin up multiple instances of the library against the same file is

[sqlite] Appropriate Uses For SQLite

We use sqlite as the db engine inside a server application with a number of clients that connect to the server. Sqlite works just beatiful here and I wish these statements "sqlite shall not be used for client/server things" would be worded less generally. In fact when we mention sqlite as our db en

[sqlite] Appropriate Uses For SQLite

But the great thing about SQLite is you don't have to go logical form in light weight apps. http://search.cpan.org/dist/ORLite/lib/ORLite.pm ORLite does a half-and-half approach that generates the easy parts of the SQL with very little code, but avoids the code weight needed to generate all of it

[sqlite] Appropriate Uses For SQLite

I think that IR would be something like first order predicate logic, to which SQL and the relational calculus is closely related. Now that we have WITH and recursive queries, you've basically got a bottom-up evaluation of the declarative subset of Prolog (if you ignore issues relating to logic vari

[sqlite] Appropriate Uses For SQLite

I agree with you, and am not suggesting getting rid of it, but rather making it "pluggable" like many parts of the back end. Right now, roughly speaking, I'm doing: logical form -> SQL -> execution of logical form, and SQL seems to me to just be an arbitrary hoop that I have to jump through, comp

[sqlite] Appropriate Uses For SQLite

On Feb 18, 2015, at 3:13 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 02/18/2015 11:43 AM, Richard Hipp wrote: >> but I think the truth is we are probably stuck with SQL for a while >> yet. > > In theory there could be an intermediate representation form (lik

[sqlite] Appropriate Uses For SQLite

On 2/18/15, Darko Volaric wrote: > The only thing I'd change about SQLite is the SQL bit. Most people agree that the SQL language is a bit of a mess. But so is the Qwerty keyboard layout. The problem is that the improvement you get by moving to something else is less than the pain of making the

[sqlite] Appropriate Uses For SQLite

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/18/2015 11:43 AM, Richard Hipp wrote: > but I think the truth is we are probably stuck with SQL for a while > yet. In theory there could be an intermediate representation form (like compilers do) that is publicly available, with the (now optiona

[sqlite] Appropriate Uses For SQLite

I second this notion. I think SQLite is uniquely suited to server based applications of all kinds. Its light footprint and the fact that it's a library rather than a full system gives it a flexibility and raw performance that other systems cannot. We use it at the core of each node in a distributed

[sqlite] Appropriate Uses For SQLite

On 2/18/15, Jim Callahan wrote: > I would mention the open source statistical language R in the "data > analysis" section. I've heard of R but never tried to use it myself. Is an SQLite interface built into R, sure enough? Or is that something that has to be added in separately? > The interfa

[sqlite] Appropriate Uses For SQLite

I would mention the open source statistical language R in the "data analysis" section. The interface in the RSqlite package is much better and faster than any of the Python interfaces in that the interface fully understands queries as tables and that the looping for the return of rows is done in co

[sqlite] Appropriate Uses For SQLite

On Wed, Feb 18, 2015 at 8:53 AM, Richard Hipp wrote: > On 2/18/15, Jim Callahan wrote: > > I would mention the open source statistical language R in the "data > > analysis" section. > > I've heard of R but never tried to use it myself. Is an SQLite > interface built into R, sure enough? Or is

[sqlite] Appropriate Uses For SQLite

In a feeble effort to do "marketing", I have revised the "Appropriate Uses For SQLite" webpage to move trendy buzzwords like "Internet of Things" and "Edge of the Network" above the break. See: https://www.sqlite.org/whentouse.html Please be my "focus group", and provide feedback, comments,

[sqlite] Appropriate Uses For SQLite

On Wed, 18 Feb 2015, Richard Hipp wrote: > Please be my "focus group", and provide feedback, comments, suggestions, > and/or criticism about the revised document. Send your remarks back to > this mailing list, or directly to me at the email in the signature. Richard, It is clear and well orga

Re: [sqlite] appropriate Uses For SQLite

Thanks for the info. it has helped clarify some things for me. I think I will stick with MySQL with this application as it is going to be a networked app. If I do one that does not need to be on a network i will dive into SQLlite. thanks again. Pavel Ivanov-2 wrote: > > There's no contradict

Re: [sqlite] appropriate Uses For SQLite

There's no contradiction in those citations. First talks about website with some 100K hits/day. Website means application running on some dedicated server, clients send HTTP requests to your application and application processes it working with locally stored database. Second citation is talking ab

[sqlite] appropriate Uses For SQLite

I am looking into the best method for implementing a database for a small application that I will most likely be building it in Adobe Air. I looked at "Appropriate Uses For SQLite" on the the SQLite.org website and I got some conflicting info. for Example I saw the following: "SQLite usually wi

RE: [sqlite] Appropriate uses for SQLite

I'm late too, but here you have my opinion At 02:03 05/02/2007, you wrote: FWIW I don't interpret any posts on this thread as an attempt to change SQLite, either. But there seems to be some who see value in more clearly defining *when* SQLite *does* work. I guess that there is a lot of enthusias

Re: [sqlite] Appropriate uses for SQLite

Thank you for your thorough replies to my supplementary remarks on this topic. It seems to me clear now that it is best not to take a careful disclaimer etc (on site networking support) as typically/generally indicating a limitation on usefulness of sqlite. Rather it is a matter of taking care &

Re: [sqlite] Appropriate uses for SQLite

Hey, sorry I'm a little late on this one (as usual). On 2/3/07, David M X Green <[EMAIL PROTECTED]> wrote: I am new to this but are these issues those of trying to get it to do what sqlite it > is not designed for. I quote the book The Definitive Guide to SQLite - Chapter 1 --- Networking " ..

Re: [sqlite] Appropriate uses for SQLite

On Feb 2, 2007, at 8:59 AM, Clark Christensen wrote: FWIW, I'm not convinced Samba has locking working correctly. Using a very recent Samba version, I managed to corrupt a SQLite database last fall by (I think) doing simultaneous writes from the Linux host box, and my WinXP client box (via

RE: [sqlite] Appropriate uses for SQLite

PROTECTED] Sent: Monday, 5 February 2007 3:08 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Appropriate uses for SQLite We used Sqlite in a web server successfully. It is embedded in a custom written web server which provides multithreaded access and application language support (an a

Re: [sqlite] Appropriate uses for SQLite

ite.org Subject: Re: [sqlite] Appropriate uses for SQLite I am new to this but are these issues those of trying to get it to do what sqlite it is not designed for. I quote the book The Definitive Guide to SQLite - Chapter 1 --- Networking " Again, most of these limitations are intention

RE: [sqlite] Appropriate uses for SQLite

EMAIL PROTECTED] Sent: Sunday, 4 February 2007 1:17 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Appropriate uses for SQLite I am new to this but are these issues those of trying to get it to do what sqlite it is not designed for. I quote the book The Definitive Guide to SQLite - Chapter 1

Re: [sqlite] Appropriate uses for SQLite

I am new to this but are these issues those of trying to get it to do what sqlite it is not designed for. I quote the book The Definitive Guide to SQLite - Chapter 1 --- Networking " Again, most of these limitations are intentional—they are a result of SQLite’s design. Supporting high writ

Re: [sqlite] Appropriate uses for SQLite

Scott Hess wrote: On 2/2/07, Dennis Cote <[EMAIL PROTECTED]> wrote: [EMAIL PROTECTED] wrote: > The problem is, not many network filesystems work correctly. I'm sure someone knows which versions of NFS have working file locking, at least under Linux. I doubt it is this easy. You need to line

Re: [sqlite] Appropriate uses for SQLite

On 2/2/07, Dennis Cote <[EMAIL PROTECTED]> wrote: [EMAIL PROTECTED] wrote: > The problem is, not many network filesystems work correctly. I'm sure someone knows which versions of NFS have working file locking, at least under Linux. I doubt it is this easy. You need to line up a bunch of thing

Re: [sqlite] Appropriate uses for SQLite

Message From: Dennis Cote <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Friday, February 2, 2007 7:49:55 AM Subject: Re: [sqlite] Appropriate uses for SQLite [EMAIL PROTECTED] wrote: > The problem is, not many network filesystems work correctly. Hi All, If my understanding of thi

Re: [sqlite] Appropriate uses for SQLite

Dennis Cote wrote: [EMAIL PROTECTED] wrote: The problem is, not many network filesystems work correctly. Hi All, If my understanding of this is correct, SQLite only requires that the network file system has; reliable data transport and working file locking. This has primarily been an issue

Re: [sqlite] Appropriate uses for SQLite

[EMAIL PROTECTED] wrote: The problem is, not many network filesystems work correctly. Hi All, If my understanding of this is correct, SQLite only requires that the network file system has; reliable data transport and working file locking. This has primarily been an issue on older implementat

RE: [sqlite] Appropriate uses for SQLite

1:34 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Appropriate uses for SQLite "Anil Gulati -X \(agulati - Michael Page at Cisco\)" <[EMAIL PROTECTED]> wrote: > > I am trying to decide whether I can use SQLite for a website that runs > on 4 load-balanced servers usin

Re: [sqlite] Appropriate uses for SQLite

"Anil Gulati -X \(agulati - Michael Page at Cisco\)" <[EMAIL PROTECTED]> wrote: > > I am trying to decide whether I can use SQLite for a website that runs > on 4 load-balanced servers using networked file storage mounted by all > servers for common data access. This sounds like a job for a clien

RE: [sqlite] Appropriate uses for SQLite

tency question, Wayne. Anil. -Original Message- From: WB Stow [mailto:[EMAIL PROTECTED] Sent: Friday, 2 February 2007 1:12 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Appropriate uses for SQLite I think that he said that he is running one website on four different servers using loadbala

RE: [sqlite] Appropriate uses for SQLite

ace that effort. Thanks Eric. Anil. -Original Message- From: Eric Pankoke [mailto:[EMAIL PROTECTED] Sent: Friday, 2 February 2007 1:08 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Appropriate uses for SQLite By separate files, do you mean that each user has their own data store? If

RE: [sqlite] Appropriate uses for SQLite

hilip Butler [mailto:[EMAIL PROTECTED] Sent: Thursday, February 01, 2007 7:39 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Appropriate uses for SQLite I am not an expert on SQLite - but if you are running separate websites from your multiple servers, then why not use 4 instances of S

RE: [sqlite] Appropriate uses for SQLite

8:27 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Appropriate uses for SQLite That's what I'm talking about! It's good to get the perspective from your setup, Phil. I'm beginning to get the picture. I am starting to think that I should stick to an enhancement of my current s

RE: [sqlite] Appropriate uses for SQLite

OTECTED] Sent: Friday, 2 February 2007 12:24 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Appropriate uses for SQLite I'd be _extremely_ leery of doing this on a network store. In theory, it should work just fine, but bridging theory and practice may very well cost you many sleepl

RE: [sqlite] Appropriate uses for SQLite

ms almost impossible when data is in separate files with no compression, etc. Thanks for taking the time. Anil. -Original Message- From: Philip Butler [mailto:[EMAIL PROTECTED] Sent: Friday, 2 February 2007 12:16 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Appropriate uses for SQLi

Re: [sqlite] Appropriate uses for SQLite

essage- > From: Philip Butler [mailto:[EMAIL PROTECTED] > Sent: Friday, 2 February 2007 11:39 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Appropriate uses for SQLite > > I am not an expert on SQLite - but if you are running separate > websites > from your

Re: [sqlite] Appropriate uses for SQLite

9 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Appropriate uses for SQLite I am not an expert on SQLite - but if you are running separate websites from your multiple servers, then why not use 4 instances of SQLite ?? That is unless the websites need to share the same database/tables. If

RE: [sqlite] Appropriate uses for SQLite

e.org Subject: Re: [sqlite] Appropriate uses for SQLite I am not an expert on SQLite - but if you are running separate websites from your multiple servers, then why not use 4 instances of SQLite ?? That is unless the websites need to share the same database/tables. If they do need to share the

Re: [sqlite] Appropriate uses for SQLite

I am not an expert on SQLite - but if you are running separate websites from your multiple servers, then why not use 4 instances of SQLite ?? That is unless the websites need to share the same database/tables. If they do need to share the same database/tables, then PostgreSQL or MySQL ma

[sqlite] Appropriate uses for SQLite

Hi SQLite users Thank you for your attention - I am just hoping for some clarification of usability of SQLite. Referring to: http://www.sqlite.org/whentouse.html - SQLite works well in websites - Other RDBMS may work better for Client/Server applications - SQLite will work over a network file syst