Re: [sqlite] SQLite clusters?

2013-09-18 Thread JFC Morfin
te-users- > boun...@sqlite.org] Im Auftrag von Jason H > Gesendet: Montag, 16. September 2013 23:04 > An: sqlite-users@sqlite.org > Betreff: [sqlite] SQLite clusters? > > I'm transitioning my job from embedded space to Hadoop space. I was > wondering if it is possible to come

Re: [sqlite] SQLite clusters?

2013-09-17 Thread Eduardo Morras
On Tue, 17 Sep 2013 22:19:57 +0200 Paolo Bolzoni wrote: > > We have an app that uses SQLite, running in 4 servers, with 0mq (nanomsg > > soon) to get locking exclusive on writes on all databases and pass data > > sending raw sql inserts, updates and deletes. We

Re: [sqlite] SQLite clusters?

2013-09-17 Thread Paolo Bolzoni
I did not know that, I will look more into it. Thanks! On Tue, Sep 17, 2013 at 10:36 PM, Petite Abeille wrote: > > On Sep 17, 2013, at 10:19 PM, Paolo Bolzoni > wrote: > >> Sorry for the out topic, but why you want to leave 0mq? We

Re: [sqlite] SQLite clusters?

2013-09-17 Thread Petite Abeille
On Sep 17, 2013, at 10:19 PM, Paolo Bolzoni wrote: > Sorry for the out topic, but why you want to leave 0mq? We always found it > great... Isn't nanomsg the successor of ZeroMQ? I.e. same guy, same project, mark 4 or 5?

Re: [sqlite] SQLite clusters?

2013-09-17 Thread Paolo Bolzoni
> We have an app that uses SQLite, running in 4 servers, with 0mq (nanomsg > soon) to get locking exclusive on writes on all databases and pass data > sending raw sql inserts, updates and deletes. We don't have lot of nor big > writes, never use triggers that modify data or calculate secundary

Re: [sqlite] SQLite clusters?

2013-09-17 Thread Jason H
! From: Eduardo Morras <emorr...@yahoo.es> To: sqlite-users@sqlite.org Cc: Jason H <scorp...@yahoo.com>; General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Tuesday, September 17, 2013 11:35 AM Subject: Re: [sqlite] SQLite clusters?

Re: [sqlite] SQLite clusters?

2013-09-17 Thread Jason H
. :-) From: Markus Schaber <m.scha...@codesys.com> To: Jason H <scorp...@yahoo.com>; General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Tuesday, September 17, 2013 9:36 AM Subject: AW: [sqlite] SQLite clusters? Hi

Re: [sqlite] SQLite clusters?

2013-09-17 Thread Gerry Snyder
On 9/17/2013 8:51 AM, Tony Papadimitriou wrote: A "temp" view, however, can access table from different DBs. - Thank you. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite clusters?

2013-09-17 Thread Eduardo Morras
On Tue, 17 Sep 2013 06:58:06 -0700 (PDT) Jason H wrote: > That's the whole point of using SQLite, it's not 'big iron' - it's a bunch of > iron filings working together. You can get a nice surprise with SQLite when you feed it with the same RAM amount you put on MySQL

Re: [sqlite] SQLite clusters?

2013-09-17 Thread Eduardo Morras
On Mon, 16 Sep 2013 14:04:13 -0700 (PDT) Jason H wrote: > I'm transitioning my job from embedded space to Hadoop space. I was wondering > if it is possible to come up with a SQLite cluster adaptation. > > I will give you a crash course in hadoop. Basically we get a very

Re: [sqlite] SQLite clusters?

2013-09-17 Thread Gerry Snyder
On 9/17/2013 6:24 AM, Simon Slavin wrote: Just a quick couple of things you didn't mention that might help. You probably already know about them but you mentioned ATTACH and didn't mention them so I thought I might niggle you. First, look into VIEWs. You can save any SELECT as a VIEW, then

Re: [sqlite] SQLite clusters?

2013-09-17 Thread Tony Papadimitriou
A "temp" view, however, can access table from different DBs. -Original Message- From: Gerry Snyder I was under the impression that a view is limited to the tables in the db file where it resides, and have received error messages whenever I tried to access another file's tables.

Re: [sqlite] SQLite clusters?

2013-09-17 Thread Markus Schaber
org] Im Auftrag von Jason H > Gesendet: Montag, 16. September 2013 23:04 > An: sqlite-users@sqlite.org > Betreff: [sqlite] SQLite clusters? > > I'm transitioning my job from embedded space to Hadoop space. I was > wondering if it is possible to come up with a SQLite cluster >

Re: [sqlite] SQLite clusters?

2013-09-17 Thread Simon Slavin
On 16 Sep 2013, at 10:04pm, Jason H wrote: > As the table is viewed though, it is void as a join between the key and all > column families. What denotes a column family (cf) is not specified, however > the idea is to group columns into cfs by usage. That is cf1 is your

[sqlite] SQLite clusters?

2013-09-17 Thread Jason H
I'm transitioning my job from embedded space to Hadoop space. I was wondering if it is possible to come up with a SQLite cluster adaptation. I will give you a crash course in hadoop. Basically we get a very large CSV, which is chopped up into 64MB chunks, and distributed to a number of nodes.