Re: [sqlite] a tool that allows you to graphically change sqlite schema

After thinking about your post,  the sqlite alter limitation is sqlite specific. Maybe their sqlite Bryson takes this info account? I usually use the free odbc one but it is slow... Sent from Yahoo! Mail on Android ___ sqlite-users mailing list

Re: [sqlite] a tool that allows you to graphically change sqlite schema

Try sql maelstro Sent from Yahoo! Mail on Android ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] a tool that allows you to graphically change sqlite schema

Is there a tool that allows you to graphically change sqlite schema as simple as editing a spreadsheet? For example if I wanted to change a column name from "my_driving_hours" to "driving_time", instead of writing a line of code, I can just click on that column and type in the new name, letting

[sqlite] A graphical tool to handle sqlite schema change(more than ALTER TABLE)

Is there a tool that allows you to graphically change sqlite schema as simple as editing a spreadsheet? For example if I wanted to change a column name from "my_driving_hours" to "driving_time", instead of writing a line of code, I can just click on that column and type in the new name, letting

Re: [sqlite] Using pragma user_version when doing updates

Could be an interesting virtual table module... On Tue, Sep 17, 2013 at 6:24 PM, Darren Duncan wrote: > On 2013.09.17 4:28 PM, Richard Hipp wrote: > >> On Tue, Sep 17, 2013 at 7:13 PM, Amit wrote: >> >> Hello, >>> >>> I would like to run the

Re: [sqlite] Using pragma user_version when doing updates

On 2013.09.17 4:28 PM, Richard Hipp wrote: On Tue, Sep 17, 2013 at 7:13 PM, Amit wrote: Hello, I would like to run the following update statement if pragma user_version == 2. How can I incorporate that in this query? UPDATE pass_key SET key = (SELECT textval FROM

Re: [sqlite] Using pragma user_version when doing updates

Richard Hipp writes: > > You can access the user version using "PRAGMA user_version". > Unfortunately, you cannot combine a pragma with a larger query. > Yes, I feared as much. Thanks for the response, Amit ___ sqlite-users mailing list

Re: [sqlite] Using pragma user_version when doing updates

On Tue, Sep 17, 2013 at 7:13 PM, Amit wrote: > Hello, > > I would like to run the following update statement > if pragma user_version == 2. > > How can I incorporate that in this query? > > UPDATE pass_key > SET key = (SELECT textval FROM saved.pass_key b WHERE

[sqlite] Using pragma user_version when doing updates

Hello, I would like to run the following update statement if pragma user_version == 2. How can I incorporate that in this query? UPDATE pass_key SET key = (SELECT textval FROM saved.pass_key b WHERE b.field='key') WHERE name="KeyLock"; I've tried using CASE..WHEN..ELSE but it doesn't seem to

Re: [sqlite] SQLite clusters?

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?

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?

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?

> 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

[sqlite] SELECT statement performance in 3.8.0.2

Hi SQLite team, I have query with multiple select statements (attached below). When I run this query on 3.8.0.2 sqlite3 it takes much more time than in took on same db in 3.7.17. In 3.7.17 it takes 0.093 sec, In 3.8.0.2 it takes couple of minutes. Database has three tables product (3000 rows),

Re: [sqlite] SELECT statement performance in 3.8.0.2

On Tue, Sep 17, 2013 at 9:26 AM, Adam Kopriva wrote: > Hi SQLite team, > > I have query with multiple select statements (attached below). When I run > this query on 3.8.0.2 sqlite3 it takes much more time than in took on same > db in 3.7.17. In 3.7.17 it takes 0.093 sec,

Re: [sqlite] SQLite clusters?

In practice, Hbase schemas are denormalized. But toa void storing all that null data, they use column families. Anyone trying to use a cluster should know to join everything as much as possible. But it is recognized that even for Hbase, joins are an expensive and limiting operation. By

Re: [sqlite] SQLite clusters?

That's the whole point of using SQLite, it's not 'big iron' - it's a bunch of iron filings working together. I'm just suggesting the amount of work to get such a thing going is not that much work, but I wanted to float it here to see if there were any good reasons why it was a bad idea. :-)

Re: [sqlite] SQLite clusters?

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?

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?

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?

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?

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?

Hi, Jason, It might be that this is a little bit to big for sqLITE. Maybe a "big iron" database like PostgreSQL or the Greenplum Database will fit your requirements better. Best regards Markus Schaber CODESYS® a trademark of 3S-Smart Software Solutions GmbH Inspiring Automation Solutions

Re: [sqlite] SQLite clusters?

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?

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.

Re: [sqlite] quetion on editing a sqlite database

Hi, Von: von Simon Slavin > On 15 Sep 2013, at 11:30pm, john white wrote: > > Oh, there is a location column with this information. I can do them, > > one at a time, but that is going to take a LOT of time. I was hoping > > there would be a way to select them all and then

Re: [sqlite] Select with dates

On 16 Sep 2013, at 18:43, Petite Abeille wrote: > What about simply using not overlapping intervals and call it a day? Sure! WFM. I thought that was what I was suggesting. 8-) /Niall ___ sqlite-users mailing list