[sqlite] Appropriate Uses For SQLite

/en/docs/user_manual/working_with_projections/working_with_projections.html For more information on the Spatialite family of projects: http://www.gaia-gis.it/gaia-sins/ Jim Callahan Orlando, FL On Wed, Feb 18, 2015 at 9:34 AM, Richard Hipp wrote: > In a feeble effort to do "marketing", I hav

[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

[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

[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

[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.

[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

[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

[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] Approp

[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,

[sqlite] Appropriate Uses For SQLite

rs-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 "marketing", I have revi

[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

[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

[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

[sqlite] Appropriate Uses For SQLite

p <mailto:drh at sqlite.org> > 18 f?vrier 2015 15:34 > 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.

[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

[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

[sqlite] Appropriate Uses For SQLite

e: Sqlite CAN very well serve as the DB > > engine for client/server applications, it just depend how > > the api is used. > > > > Marcus > > > > Am 2015-02-18 15:34, schrieb Richard Hipp: > > > >> In a feeble effort to do "marketing", I ha

[sqlite] Appropriate Uses For SQLite

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 > > Pl

[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

[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

[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,

[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

[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

[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

[sqlite] Appropriate Uses For SQLite

t/server applications, it just depend how > the api is used. > > Marcus > > Am 2015-02-18 15:34, schrieb Richard Hipp: > >> In a feeble effort to do "marketing", I have revised the "Appropriate >> Uses For SQLite" webpage to move trendy

[sqlite] Appropriate Uses For SQLite

Feb 18, 2015 9:34 AM, "Richard Hipp" wrote: > >> 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"

[sqlite] Appropriate Uses For SQLite

ws is done in compiled code rather than at an interpreted command line. On Feb 18, 2015 9:34 AM, "Richard Hipp" wrote: > In a feeble effort to do "marketing", I have revised the "Appropriate > Uses For SQLite" webpage to move trendy buzzwords like "Internet of

[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 "

[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

Re: [sqlite] appropriate Uses For SQLite

gt; Pavel > > On Thu, Sep 30, 2010 at 4:17 PM, Visnik <visnik+oldnab...@gmail.com> > wrote: >> >> 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 >>

Re: [sqlite] appropriate Uses For SQLite

gmail.com> wrote: > > 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

[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: "

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

RE: [sqlite] Appropriate uses for SQLite

] 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 application

Re: [sqlite] Appropriate uses for SQLite

: 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 r

RE: [sqlite] Appropriate uses for SQLite

] 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 --- Networking

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

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

Re: [sqlite] Appropriate uses for SQLite

<[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 this is correct, SQLite only

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

RE: [sqlite] Appropriate uses for SQLite

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 using netwo

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

RE: [sqlite] Appropriate uses for SQLite

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 loadbalancing

RE: [sqlite] Appropriate uses for SQLite

. 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 so, why not do

RE: [sqlite] Appropriate uses for SQLite

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 SQLite

RE: [sqlite] Appropriate uses for SQLite

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 system. It's *very* basic, even

RE: [sqlite] Appropriate uses for SQLite

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 sleepless nights. sqlite is in many

RE: [sqlite] Appropriate uses for SQLite

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 SQLite And this is when I'll

Re: [sqlite] Appropriate uses for SQLite

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 multiple servers, then why no

Re: [sqlite] Appropriate uses for 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 they do need

RE: [sqlite] Appropriate uses for SQLite

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 same

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

[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