Re: [sqlite] sqlite versus MySQL automatic defragmentation on SSDs?

> That said, I'd still welcome any quick summary of the differences between > sqlite and mysql when it comes to fragmentation. This is far from main differences between sqlite and mysql that you should consider if you want to choose between them unless of course your question is just about an

Re: [sqlite] sqlite versus MySQL automatic defragmentation on SSDs?

Thanks, this is really helpful! (And I lecture my employees about the evils of premature optimization all the time. In fact, I'll lecture anyone in earshot, so frequently that it's the butt of jokes.) That said, I'd still welcome any quick summary of the differences between sqlite and mysql

Re: [sqlite] Decimal point and localisation

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 27/10/12 12:43, Steinar Midtskogen wrote: > But why can't sqlite observe LC_NUMERIC for the output - no ambiguity > would then arise? Because the SQLite library does not know where the output is going. If you ask for a number to be provided as a

[sqlite] Decimal point and localisation

According to the documenation, "the "." character is always used as the decimal point even if the locale setting specifies "," for this role - the use of "," for the decimal point would result in syntactic ambiguity". But why can't sqlite observe LC_NUMERIC for the output - no ambiguity would

Re: [sqlite] sqlite versus MySQL automatic defragmentation on SSDs?

On Sat, Oct 27, 2012 at 6:38 AM, David Barrett wrote: > I'm trying to learn more about MySQL versus sqllite when it comes to > vacuuming and fragmentation, especially as it relates to SSD storage. Can > anybody summarize for me the differences? > > 1) My understanding is

Re: [sqlite] How to differentiate between sqlite database empty char* strings and DBNULL char* string?

Frank Chang wrote: > Good afternoon, Is it possible to differentiate between sqlite database > empty char* strings and DBNULL char* strings? If so, what is the est way to > do that? Thank you. You might be looking for sqlite3_column_type. -- Igor Tandetnik

Re: [sqlite] How to differentiate between sqlite database empty char* strings and DBNULL char* string?

On 27 Oct 2012, at 7:17pm, Frank Chang wrote: > Good afternoon, Is it possible to differentiate between sqlite database > empty char* strings and DBNULL char* strings? If so, what is the est way to > do that? I do not know what you mean by DBNULL. SQLite has a NULL

[sqlite] How to differentiate between sqlite database empty char* strings and DBNULL char* string?

Good afternoon, Is it possible to differentiate between sqlite database empty char* strings and DBNULL char* strings? If so, what is the est way to do that? Thank you. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] sqlite versus MySQL automatic defragmentation on SSDs?

On 27 Oct 2012, at 11:38am, David Barrett wrote: > I'm trying to learn more about MySQL versus sqllite when it comes to > vacuuming and fragmentation, especially as it relates to SSD storage. Rather than answer your questions point-by-point, I'm going to give you the

Re: [sqlite] statement prepares OK but step returns SQLITE_NOTADB

On 27 Oct 2012, at 6:36am, Dan Kennedy wrote: > On 10/27/2012 07:06 AM, Simon Slavin wrote: >> >> On 26 Oct 2012, at 11:05pm, Clemens Ladisch >> wrote: >> >>> Yes; sqlite3_finalize _always_ frees the statement. >> >> And if the statement is already

Re: [sqlite] light weight write barriers

Theodore Ts'o, on 10/25/2012 09:50 AM wrote: Yeah I don't buy that. One, flash is still too expensive. Two, the capital costs to build enough Silicon foundries to replace the current production volume of HDD's is way too expensive for any company to afford (the cloud providers are buying

Re: [sqlite] light weight write barriers

Theodore Ts'o, on 10/25/2012 01:14 AM wrote: On Tue, Oct 23, 2012 at 03:53:11PM -0400, Vladislav Bolkhovitin wrote: Yes, SCSI has full support for ordered/simple commands designed exactly for that task: to have steady flow of commands even in case when some of them are ordered. SCSI

Re: [sqlite] light weight write barriers

Nico Williams, on 10/24/2012 05:17 PM wrote: Yes, SCSI has full support for ordered/simple commands designed exactly for that task: [...] [...] But historically for some reason Linux storage developers were stuck with "barriers" concept, which is obviously not the same as ORDERED commands,

Re: [sqlite] Union all writting on /var/tmp

Thank you Simon. Your solution would work for the example i gave. Nevertheless my problem is still more complex because i also use SQLite as a generic streaming engine (yes i know, SQLite wasn't designed for doing things like that). Appart from input VTs (FILE) we also have output VTs like so

[sqlite] sqlite versus MySQL automatic defragmentation on SSDs?

I'm trying to learn more about MySQL versus sqllite when it comes to vacuuming and fragmentation, especially as it relates to SSD storage. Can anybody summarize for me the differences? 1) My understanding is sqlite, in general, has no automatic defragmentation: there is no process to gradually