Re: [sqlite] Messages posted on Nabble not getting to list

On 2016-05-27 2:34 AM, Tim Streater wrote: On 27 May 2016 at 08:56, Darren Duncan wrote: On 2016-05-26 9:00 PM, Balaji Ramanathan wrote: The main advantage of forums, and I follow a bunch of them, is that I choose when I want to stop my regular day job and be

Re: [sqlite] Messages posted on Nabble not getting to list

On 2016-05-27 2:28 PM, Balaji Ramanathan wrote: But when I was debating between MySQL and SQLite for my project, I almost didn't choose SQLite because of the archaic look and feel of the sqlite.org website and support options available there. For the love of all that's good, don't choose MySQL

Re: [sqlite] Messages posted on Nabble not getting to list

> Flash for the sake of flash is not good, but sometimes you have to > show people that you and your product are keeping up with the times, not > already obsolete before you even download it and start using it. Can you explain why you think "flash", as you put it, means that something is

Re: [sqlite] Messages posted on Nabble not getting to list

> I think there are two different use cases for a mailing list such as this, > and they're each better served by different access method; either email or > forums. > One use case is the individual with a long-term interest in a > project/technology. Because of the long-term interest, an email

Re: [sqlite] Messages posted on Nabble not getting to list

On 5/27/2016 1:23 AM, Jean-Christophe Deschamps wrote: At 03:46 27/05/2016, you wrote: If SQLite goes this route, I will probably (as with the others) stop reading it too. Seconded. Thirded. I have mostly given up on the email lists that have converted to forums. There are two left that

Re: [sqlite] Messages posted on Nabble not getting to list

FWIW, I like the look of the website. ) Sent from my iPhone > On May 27, 2016, at 5:47 PM, Scott Robison wrote: > > On Fri, May 27, 2016 at 3:28 PM, Balaji Ramanathan < > balaji.ramanat...@gmail.com> wrote: > >> Ryan Smith wrore: >>> A valid point indeed - for

Re: [sqlite] Messages posted on Nabble not getting to list

On Fri, May 27, 2016 at 3:28 PM, Balaji Ramanathan < balaji.ramanat...@gmail.com> wrote: > Ryan Smith wrore: > >A valid point indeed - for most of us this is simply achieved by e-mail > f>iltering or perhaps using a different mail account. > >As an aside - If your company makes software that uses

Re: [sqlite] Messages posted on Nabble not getting to list

Ryan Smith wrore: >A valid point indeed - for most of us this is simply achieved by e-mail f>iltering or perhaps using a different mail account. >As an aside - If your company makes software that uses SQLite in any >way, you should probably receive the SQLite forum mails somewhere into a >folder

Re: [sqlite] SELECT the "middle" of a large ordered table

NEAT! yeah i'll definitely have to recompile and check that out - the nLt column sounds interesting!? [1] But I'm not sure what the end game would be - any sample of ANALYZE results wouldn't generalize to any other containers of a similar size - so I'd be looking at always running with a sqlite3

Re: [sqlite] SELECT the "middle" of a large ordered table

On 27 May 2016, at 9:02pm, Clay Gerrard wrote: > Is there a more obvious way to find this "middle" of a large ordered query > in an indexed table? Just estimating between the min and max doesn't > always seem to represent a good split since the distribution of prefixes

Re: [sqlite] Messages posted on Nabble not getting to list

On Fri, May 27, 2016 at 2:10 PM, Simon Slavin wrote: > > On 27 May 2016, at 7:50pm, Scott Robison wrote: > > > I'd like to see some sort of hybridized approach myself (for my own > > projects, not advocating for SQLite), where those who want email

Re: [sqlite] Messages posted on Nabble not getting to list

On 27 May 2016, at 7:50pm, Scott Robison wrote: > I'd like to see some sort of hybridized approach myself (for my own > projects, not advocating for SQLite), where those who want email only can > use email only, but there is still an official web based official history

[sqlite] SELECT the "middle" of a large ordered table

The OpenStack Object Storage system uses sqlite3 databases as the "metadata" storage layer for it's "containers" and "accounts" - similar in a function to AWS S3 "buckets". Each "object" in the system is recorded by a row in it's "container". Given a the API URI for an object:

Re: [sqlite] Messages posted on Nabble not getting to list

On Fri, May 27, 2016 at 4:43 AM, Jonathan Moules < jonathan-li...@lightpear.com> wrote: > I think there are two different use cases for a mailing list such as this, > and they're each better served by different access method; either email or > forums. > > One use case is the individual with a

Re: [sqlite] Savepoint Questions

On 5/27/16, Paul Medynski wrote: > > begin transaction; > ... Work A ... > savepoint Foo; > ... Work B ... > savepoint Foo;<--- Allowed by #1 > ... Work C ... > rollback to savepoint Foo;<--- Rolls back Work C, but leaves the >

[sqlite] Savepoint Questions

Hello all, I have some questions and comments about savepoints, documented here: https://www.sqlite.org/lang_savepoint.html Here are some excerpts from that documentation that are relevant to my questions/comments: 1. "The SAVEPOINT command starts a new transaction with a name. The

Re: [sqlite] DB Partitioning and Performance

Thanks for the reply Simon. We have database pooling since our databases are read only and we wanted to take advantage of multithreading. Each database connection had the temp view defined, but I saw a huge performance drop when it came to queries. I’m going to try sub-selects for now with

[sqlite] Messages posted on Nabble not getting to list

At 03:46 27/05/2016, you wrote: >If SQLite goes this route, I will probably (as with the others) stop >reading it too. Seconded.

Re: [sqlite] Messages posted on Nabble not getting to list

On 2016/05/27 6:00 AM, Balaji Ramanathan wrote: Interesting. I have no idea what a facebook-style interface looks like since I don't have a facebook account. The main advantage of forums, and I follow a bunch of them, is that I choose when I want to stop my regular day job and be distracted

Re: [sqlite] DB Partitioning and Performance

On 2016/05/27 4:17 AM, Michael Hari wrote: I have a database that contains 2014,2015 and 2016’s worth of data broken down by year and quarter. In total, this db was 2.36 GB. Because of a replication requirement where the DB has to be under 2 GB, I’ve split the DB into 3 smaller databases by

Re: [sqlite] DB Partitioning and Performance

On 27 May 2016, at 3:17am, Michael Hari wrote: > I have a database that contains 2014,2015 and 2016’s worth of data broken > down by year and quarter. In total, this db was 2.36 GB. Because of a > replication requirement where the DB has to be under 2 GB, I’ve split

Re: [sqlite] Messages posted on Nabble not getting to list

I'm a big time die hard fan of "text only". I'm an information consumer, and not someone who likes being distracted by meaningless visual effects. My Linux consoles are all (mostly) white on black, my 5-monitor Windows desktop looks like Windows 2000, and my 3-monitor work machine follows that

Re: [sqlite] [System.Data.SQLite.DLL] Cannot access sqlite database on remote computer

Hi Joe, Adding two extra backslashes worked a treat. Many thanks for replying. Would never have occurred to me to try that. No other Windows program uses that convention, so seems 'alien' to me. Again, thanks! Chris On Thu, May 26, 2016 at 6:17 PM, Chris Locke

Re: [sqlite] Messages posted on Nabble not getting to list

Theres another reason - consistency. Just look back thorugh this thread and see how things are quoted, often differently depending on the mail client used - much easier to read when a quote is nicely formatted in a highlighted box. Then (just from this thread) there is formatting of dates - all

Re: [sqlite] Messages posted on Nabble not getting to list

I think there are two different use cases for a mailing list such as this, and they're each better served by different access method; either email or forums. One use case is the individual with a long-term interest in a project/technology. Because of the long-term interest, an email list (which

Re: [sqlite] Messages posted on Nabble not getting to list

I agree with Tim. I filter all my SQLite messages to its own folder and read as needed. I prefer this method to a forum as I can then keep the messages with me. I’m often off the internet and its good to have them for reading. Also I can look back through them and get hints and tips about

Re: [sqlite] Messages posted on Nabble not getting to list

On 27 May 2016 at 08:56, Darren Duncan wrote: > On 2016-05-26 9:00 PM, Balaji Ramanathan wrote: >> The main advantage of forums, and I follow a bunch of them, is that I choose >> when I want to stop my regular day job and be distracted by them rather than >> emails

Re: [sqlite] Messages posted on Nabble not getting to list

On 2016-05-26 9:00 PM, Balaji Ramanathan wrote: The main advantage of forums, and I follow a bunch of them, is that I choose when I want to stop my regular day job and be distracted by them rather than emails coming in and distracting me all the time. That's not an argument for web forums,

[sqlite] The usage of SQLITE_ENABLE_ATOMIC_WRITE?

What’s the usage ofSQLITE_ENABLE_ATOMIC_WRITE macro? I can’t find any document or comment about it. How can I make sure whether I should open it? Will it reduce the corruption of SQLite or increase the performance? ___ sqlite-users mailing list

Re: [sqlite] Messages posted on Nabble not getting to list

I'm a developer and I much prefer the forum approach. I don't get to read all of the threads on here because I do have a specific interest in a subset of the SQLite subject. I like the ability to subscribe to a thread and get updates when someone replies I like to be able to embed graphics (I

Re: [sqlite] Write-Ahead Logging -- documentation error

> On 26/05/2016, at 3:17 AM, Jeffrey Mattox wrote: > > This page: > https://www.sqlite.org/wal.html > Contains the phrase, "... the checkpoint must stop when it reaches a page in > the WAL that is past the read mark of any current reader." > > The term, "read mark" is not

Re: [sqlite] Fastest way to add many simple rows to a table?

@Keith yes, a custom table-valued function should be faster, as it would alleviate the roundtrip through json, though that json round-tripping accounts to only about 10-20% of the CPU time AFAICT. @Richard and others: executing individual insert statements always give lower performance than using

Re: [sqlite] What could be the cause of a zero length database file?

> Having an sqlite connection open on a deleted file can also happen in posix > land... Section 2.4 of "How to Corrupt" claims it can't happen on windows, I > guess that's technically true as in this scenario the file was deleted before > being opened, but it might be worth mentioning anyway