Re: [sqlite] "natrual" join (not "natural")

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 31/10/12 07:27, Jonas Malaco Filho wrote: > Maybe there could be a strict switch. There is a ticket for a "lint" mode that would help catch common issues where there are possibly problems. This is another example of something appropriate for it

Re: [sqlite] "natrual" join (not "natural")

oh, that makes sense. Thanks for clarifying. Sam - We're Hiring! Seeking passionate Flex or C# developer in the Washington D.C. Contact care...@blinemedical.com On Wed, Oct 31, 2012 at 10:18 AM, Richard Hipp

[sqlite] Building SQLite 3.7.14.1 for OpenVMS

Hello and have a good time of day! Some time ago I've posted a patch which allowed to compile and use SQLite 3.7.9 under OpenVMS operating system: http://sqlite.1065341.n5.nabble.com/Port-of-SQLite-3-7-9-to-OpenVMS-td55734.html

Re: [sqlite] Automatically create a TreeNode?

Clemens, This is wonderful... I have no clue how it works, but it works. this "w2" table you are using, what is this and where do you get it from? In any case, thanks for your help. gert 2012/10/31 Clemens Ladisch > Gert Van Assche wrote: > > I have a table like this

Re: [sqlite] Automatically create a TreeNode?

Gert Van Assche wrote: > I have a table like this one: > > CREATE TABLE [WORLD] ([Continent] , [Region] , [Country] , [TreeNode] CHAR); > insert into [WORLD] values('America', null, null, '1'); > insert into [WORLD] values('America', 'North', null, '1.1'); > insert into [WORLD] values('America',

[sqlite] Automatically create a TreeNode?

All, I have a table like this one: CREATE TABLE [WORLD] ([Continent] , [Region] , [Country] , [TreeNode] CHAR); insert into [WORLD] values('America', null, null, '1'); insert into [WORLD] values('America', 'North', null, '1.1'); insert into [WORLD] values('America', 'Central', null, '1.2');

Re: [sqlite] Dump a memory DB

On 31 Oct 2012, at 2:25pm, Andrea Peri wrote: > From the sqlite3 console, is possible to dump on disk a memory DB ? Use the .dump command. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Dump a memory DB

You can use the .backup command: http://www.sqlite.org/sqlite.html *Jonas Malaco Filho* 2012/10/31 Andrea Peri > Hi, > > From the sqlite3 console, is possible to dump on disk a memory DB ? > > Thx, > > -- > - > Andrea Peri > . . . . . . . . . > qwerty

Re: [sqlite] "natrual" join (not "natural")

Maybe there could be a strict switch. It could also be useful for developing/testing stuff on SQLite that would later be sent to different a RDBMS or a custom SQL processor. *Jonas Malaco Filho* 2012/10/31 Richard Hipp > On Wed, Oct 31, 2012 at 10:13 AM, Ryan Johnson >

[sqlite] Dump a memory DB

Hi, >From the sqlite3 console, is possible to dump on disk a memory DB ? Thx, -- - Andrea Peri . . . . . . . . . qwerty àèìòù - ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] "natrual" join (not "natural")

On Wed, Oct 31, 2012 at 10:13 AM, Ryan Johnson wrote: > On 31/10/2012 9:54 AM, Samuel Neff wrote: > >> We wrote a query and intended to use a "natural" join but had a typo and >> wrote "natrual" join instead. We were surprised this query was processed >> without

Re: [sqlite] "natrual" join (not "natural")

On Wed, Oct 31, 2012 at 9:54 AM, Samuel Neff wrote: > We wrote a query and intended to use a "natural" join but had a typo and > wrote "natrual" join instead. We were surprised this query was processed > without error and performed a cross join. > > Example: > sqlite>

Re: [sqlite] "natrual" join (not "natural")

On 31/10/2012 9:54 AM, Samuel Neff wrote: We wrote a query and intended to use a "natural" join but had a typo and wrote "natrual" join instead. We were surprised this query was processed without error and performed a cross join. That must have been a delightful one to track down... It's due

[sqlite] "natrual" join (not "natural")

We wrote a query and intended to use a "natural" join but had a typo and wrote "natrual" join instead. We were surprised this query was processed without error and performed a cross join. Example: SQLite version 3.7.6.3 Enter ".help" for instructions Enter SQL statements terminated with a ";"

Re: [sqlite] light weight write barriers

On 30 Oct 2012, at 10:22pm, Vladislav Bolkhovitin wrote: > I fully understand your position. But "affordable" and "useful" are > completely orthogonal things. The "high end" features are very useful, if you > want to get high performance. Then ones, who can afford them, will

Re: [sqlite] light weight write barriers

Theodore Ts'o, on 10/27/2012 12:44 AM wrote: On Fri, Oct 26, 2012 at 09:54:53PM -0400, Vladislav Bolkhovitin wrote: What different in our positions is that you are considering storage as something you can connect to your desktop, while in my view storage is something, which stores data and

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

In my scenario there is just one master and most transactions are non-overlapping, but I can foresee a need for resolution of the occasional collision. You mention "other states". Can you explain further? Chris On Wed, 2012-10-31 at 11:40 +0700, David Barrett wrote: > Ah, to clarify, there is

Re: [sqlite] light weight write barriers

> I don't want to flame on this topic, but you are not right here. As far as I > can > see, a big chunk of Linux storage and file system developers are/were > employed by > the "gold-plated storage" manufacturers, starting from FusionIO, SGI and > Oracle. > > You know, RedHat from recent