Re: [sqlite] Schema updates across threads in WAL & multithread mode

2019-10-18 Thread Ben Asher
Hi D. Richard Hipp. Sorry for the late reply. I had some email settings wrong somewhere, and I didn't realize I had a reply until I remembered this and checked the archives months later. You had written: >> >> Is there something we need to do proactively to ensure that schema update >> appears

Re: [sqlite] Schema updates across threads in WAL & multithread mode

2019-10-18 Thread Ben Asher
Hi Simon. Sorry for the late reply. I had some email settings wrong somewhere, and I didn't realize I had a reply until I remembered this and checked the archives months later. You had written: >Can I ask the maximum number of columns you expect to exist in that table ? I'm working up to trying

Re: [sqlite] Schema updates across threads in WAL & multithread mode

2019-10-18 Thread Ben Asher
Hi José. Sorry for the late reply. I had some email settings wrong somewhere, and I didn't realize I had a reply until I remembered this and checked the archives months later. You had asked: > Are you using BEGIN and END before and after the schema update? Yes that's correct. We are doing the

Re: [sqlite] Schema updates across threads in WAL & multithread mode

2019-08-16 Thread Ben Asher
To clarify, we add a column on our writer connection, and then "SELECT * FROM table" on the reader connection does not include the column that was added. Ben On Fri, Aug 16, 2019 at 11:32 AM Ben Asher wrote: > Hi folks! We're running (sqlite 3.27.2) into an issue where we make a > schema

Re: [sqlite] Schema updates across threads in WAL & multithread mode

2019-08-16 Thread Richard Hipp
On 8/16/19, Ben Asher wrote: > > Is there something we need to do proactively to ensure that schema update > appears immediately from other threads? > When a database connection has a read transaction open, it continues to see a snapshot of the database as it existed when the read transaction

Re: [sqlite] Schema updates across threads in WAL & multithread mode

2019-08-16 Thread Simon Slavin
On 16 Aug 2019, at 7:32pm, Ben Asher wrote: > we make a > schema update (adding a column to a table) on our writer connection Can I ask the maximum number of columns you expect to exist in that table ? I'm working up to trying to convince you to add a row to something instead, but I want to

Re: [sqlite] Schema updates across threads in WAL & multithread mode

2019-08-16 Thread Jose Isaias Cabrera
Ben Asher, on Friday, August 16, 2019 02:32 PM, wrote... > > Hi folks! We're running (sqlite 3.27.2) into an issue where we make a > schema update (adding a column to a table) on our writer connection, but > then the schema update isn't immediately available on the read-only > connections that we

[sqlite] Schema updates across threads in WAL & multithread mode

2019-08-16 Thread Ben Asher
Hi folks! We're running (sqlite 3.27.2) into an issue where we make a schema update (adding a column to a table) on our writer connection, but then the schema update isn't immediately available on the read-only connections that we use on other threads, which causes a crash in our application (app

[sqlite] Schema-less JSON SQLite DB?

2015-07-16 Thread Eduardo Morras
On Wed, 15 Jul 2015 17:22:36 +0200 Sergej Jure?ko wrote: > An idea I?ve had a while ago was to implement functions for json > documents (using sqlite3_create_function_v2) > > Json would be stored in a text column. You would need to define 2 > functions: > -

[sqlite] Schema-less JSON SQLite DB?

2015-07-16 Thread Sergej Jurečko
I will probably get around to doing it in the next few months. Hopefully I have the time, right now I'm very busy. I will post to this message board when I'm done. Sergej

[sqlite] Schema-less JSON SQLite DB?

2015-07-15 Thread Sergej Jurečko
An idea I?ve had a while ago was to implement functions for json documents (using sqlite3_create_function_v2) Json would be stored in a text column. You would need to define 2 functions: - docget(document,key1,subval1,subval2,?) - docset(document,key1,subval1,subval2,..,val) Last parameter of

[sqlite] Schema-less JSON SQLite DB?

2015-07-15 Thread Hayden Livingston
I'm beginning to understand some of the implementation challenges here. Eric, it'd be great to get that open sourced. I can tell you at least I will jump and prototype on it. Sergej and Roger, I do like this potential idea as well. Of course, now it's a custom sqlite, but at least the job gets

[sqlite] Schema-less JSON SQLite DB?

2015-07-15 Thread J Decker
On Wed, Jul 15, 2015 at 10:03 AM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 07/15/2015 08:22 AM, Sergej Jure?ko wrote: > > What do you guys think? Is it stupid, could it be improved? > > I recommend looking at Mongodb and Postgres first to see how they do >

[sqlite] Schema-less JSON SQLite DB?

2015-07-15 Thread Alek Paunov
Hi Hayden, On 14.07.2015 03:43, Hayden Livingston wrote: > Is there a concept of a schema-less JSON SQLite DB? > > My reason is simple: versioning. We have lot of business metrics that > get updated let's say once a month, and we need to be agile to get > them. Right now, we just put the

[sqlite] Schema-less JSON SQLite DB?

2015-07-15 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/15/2015 08:22 AM, Sergej Jure?ko wrote: > What do you guys think? Is it stupid, could it be improved? I recommend looking at Mongodb and Postgres first to see how they do queries. It would be better to be compatible with them where practical,

[sqlite] Schema-less JSON SQLite DB?

2015-07-15 Thread Eric Rubin-Smith
Given the number of the threads in the list, it seems a > lot of people want hierarchical data in SQLite :-) > Throwing in another $.02 here, my company had a need to ingest JSON of various formats into SQLite databases in low-power embedded devices. We wrote the utility program described here:

[sqlite] Schema-less JSON SQLite DB?

2015-07-15 Thread Hick Gunter
[mailto:halivingston at gmail.com] Gesendet: Dienstag, 14. Juli 2015 19:22 An: General Discussion of SQLite Database Betreff: Re: [sqlite] Schema-less JSON SQLite DB? Wow, this is the killer feature no-one told me about. I can get rid of types? How does this work under-the-hood? SELECT * FROM TABLE WHERE

[sqlite] Schema-less JSON SQLite DB?

2015-07-15 Thread J Decker
On Wed, Jul 15, 2015 at 2:14 AM, Alek Paunov wrote: > Hi Hayden, > > On 14.07.2015 03:43, Hayden Livingston wrote: > >> Is there a concept of a schema-less JSON SQLite DB? >> >> My reason is simple: versioning. We have lot of business metrics that >> get updated let's say once a month, and

[sqlite] Schema-less JSON SQLite DB?

2015-07-14 Thread Kees Nuyt
On Tue, 14 Jul 2015 10:22:02 -0700, Hayden Livingston wrote: > Wow, this is the killer feature no-one told me about. > I can get rid of types? How does this work under-the-hood? > > SELECT * FROM TABLE WHERE FooColumn > 50 > > And I've stored "Something" in that column in some row. > What's the

[sqlite] Schema-less JSON SQLite DB?

2015-07-14 Thread Simon Slavin
On 14 Jul 2015, at 6:22pm, Hayden Livingston wrote: > Wow, this is the killer feature no-one told me about. I can get rid of > types? How does this work under-the-hood? > > SELECT * FROM TABLE WHERE FooColumn > 50 > > And I've stored "Something" in that column in some row. What's the

[sqlite] Schema-less JSON SQLite DB?

2015-07-14 Thread Hayden Livingston
that does indeed look interesting. Embedded DB is the only problem here. On Mon, Jul 13, 2015 at 11:01 PM, Darren Duncan wrote: > Have a look at PostgreSQL 9.4 as well and its new JSONB data type. Gives > you the goods of relational and hierarchical databases in one place, > including the

[sqlite] Schema-less JSON SQLite DB?

2015-07-14 Thread Hayden Livingston
Wow, this is the killer feature no-one told me about. I can get rid of types? How does this work under-the-hood? SELECT * FROM TABLE WHERE FooColumn > 50 And I've stored "Something" in that column in some row. What's the behavior? I don't want to take up your time, so if there's a document I

[sqlite] Schema-less JSON SQLite DB?

2015-07-14 Thread Darren Duncan
Have a look at PostgreSQL 9.4 as well and its new JSONB data type. Gives you the goods of relational and hierarchical databases in one place, including the querying and indexing. -- Darren Duncan On 2015-07-13 5:43 PM, Hayden Livingston wrote: > Is there a concept of a schema-less JSON

[sqlite] Schema-less JSON SQLite DB?

2015-07-13 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/13/2015 08:00 PM, Hayden Livingston wrote: > Does your code also map object hierarchies in json? Yes, but thankfully I don't have much of them. Essentially the top level of the object has a unique id (SQLite allocated), and then other tables

[sqlite] Schema-less JSON SQLite DB?

2015-07-13 Thread Hayden Livingston
f). Something small and light? > A library not a server? > > Be aware that you can dynamically update the SQLite schema, and that > it takes no time to do so. Another database I won't name locks the > database and rewrites each record. This can take hours or even days. >

[sqlite] Schema-less JSON SQLite DB?

2015-07-13 Thread Roger Binns
ike SQLite, or SQLite itself). Something small and light? A library not a server? Be aware that you can dynamically update the SQLite schema, and that it takes no time to do so. Another database I won't name locks the database and rewrites each record. This can take hours or even days. SQLite j

[sqlite] Schema-less JSON SQLite DB?

2015-07-13 Thread Hayden Livingston
Is there a concept of a schema-less JSON SQLite DB? My reason is simple: versioning. We have lot of business metrics that get updated let's say once a month, and we need to be agile to get them. Right now, we just put the version in the SQLite file, and then make sure no queries cross the

[sqlite] Looking for Ready-To-Use (Instant) SQLite Schema (and Sample Data) Scripts

2015-05-05 Thread Gerald Bauer
Hello, As posted before I've started an awesome collection about all things SQLite [1]. One section collections ready-to-use (instant) SQLite schemas (and sample data) scripts. So far listed are: - football.db - teams, competitions, seasons, matches, goals, rounds, groups, etc. -

Re: [sqlite] Looking for SQLite schema doc generator (in

2015-02-04 Thread Erik Ejlskov Jensen
Thanks, I simply adapted this: https://sqldbdoc.codeplex.com/ And you can modify the xlst file if you have the guts Sendt fra Windows Mail Fra: gerald.ba...@gmail.com Sendt: ‎tirsdag‎, ‎3‎. ‎februar‎ ‎2015 ‎18‎:‎29 Til: Erik Ejlskov Jensen Cc: rsm...@rsweb.co.za,

Re: [sqlite] Looking for SQLite schema doc generator (in HTML) for tables, fields, etc

2015-02-04 Thread Gerald Bauer
Hello, Thanks. Good point. Will rename fields to columns in schema.json. Was trying initially to (re)use the Tabular Data Package format (in json) [1] from the Open Knowledge Foundation (OKFN) but it's not really a good fit. Sorry for the broken link. The schemadoc repo (that generates the

Re: [sqlite] Looking for SQLite schema doc generator (in HTML) for tables, fields, etc

2015-02-04 Thread Dominique Devienne
On Wed, Feb 4, 2015 at 9:18 AM, Gerald Bauer wrote: > [1a] New schemadoc Ruby Gem -> https://github.com/rubylibs/schemadoc > [DD] 404 for me > [1b ] Templates -> >

Re: [sqlite] Looking for SQLite schema doc generator (in HTML) for tables, fields, etc

2015-02-04 Thread Gerald Bauer
Hello, > I had something that I would use to draw a few pictures of the table schema... You're invited to share your code - my first version [1] is text-only so far. Always good to have some diagrams - a picture is worth a thousand words etc. ;-) Keep it up. Cheers. [1a] New schemadoc Ruby

Re: [sqlite] Looking for SQLite schema doc generator (in

2015-02-04 Thread Gerald Bauer
Hello, Thanks for the pointer to the template. I'm using a plain HTML template w/ Liquid tags [1]. You can see a rendered (live) version online. [2] Thanks for the inspiration. Cheers. [1] https://github.com/book-templates/schema/blob/gh-pages/index.html [2]

Re: [sqlite] Looking for SQLite schema doc generator (in

2015-02-03 Thread Erik Ejlskov Jensen
Thanks, I simply adapted this: https://sqldbdoc.codeplex.com/ And you can modify the xlst file if you have the guts Sendt fra Windows Mail Fra: gerald.ba...@gmail.com Sendt: ‎tirsdag‎, ‎3‎. ‎februar‎ ‎2015 ‎18‎:‎29 Til: Erik Ejlskov Jensen Cc: rsm...@rsweb.co.za,

Re: [sqlite] Looking for SQLite schema doc generator (in HTML) for tables, fields, etc

2015-02-03 Thread Mohit Sindhwani
On 4/2/2015 12:20 AM, Gerald Bauer wrote: Hello, I have started two hours ago ;-) to put together a little script. The idea is to "dump" the schema as json and then use a static site generator w/ html templates to generate the docu. So far the script that generates the json dump (is

Re: [sqlite] Looking for SQLite schema doc generator (in

2015-02-03 Thread Erik Ejlskov Jensen
You can use my Visual Studio addin: SQLite Toolbox to do this: http://erikej.blogspot.dk/2014/08/sqlite-toolbox-40-visual-guide-of.html Sendt fra Windows Mail ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Looking for SQLite schema doc generator (in

2015-02-03 Thread Gerald Bauer
Hello, > SQLite Toolbox Thanks for highlighting. The HTML pages for the schema looks great. Cheers. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Looking for SQLite schema doc generator (in

2015-02-03 Thread Drago, William @ CSG - NARDAEAST
age- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Erik Ejlskov Jensen > Sent: Tuesday, February 03, 2015 12:11 PM > To: rsm...@rsweb.co.za; gerald.ba...@gmail.com > Cc: sqlite-users@sqlite.org > Subject: Re: [sqlite] Looking for SQLite

Re: [sqlite] Looking for SQLite schema doc generator (in

2015-02-03 Thread Erik Ejlskov Jensen
You can use my Visual Studio addin: SQLite Toolbox to do this: http://erikej.blogspot.dk/2014/08/sqlite-toolbox-40-visual-guide-of.html Sendt fra Windows Mail ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Looking for SQLite schema doc generator (in HTML) for tables, fields, etc

2015-02-03 Thread Gerald Bauer
Hello, I have started two hours ago ;-) to put together a little script. The idea is to "dump" the schema as json and then use a static site generator w/ html templates to generate the docu. So far the script that generates the json dump (is twenty lines of Ruby). You can see an example,

Re: [sqlite] Looking for SQLite schema doc generator (in HTML) for tables, fields, etc

2015-02-03 Thread Gerald Bauer
Hello, Thanks. Good point. Wrapping into a html pre tag and it's a great cheat sheet as a single html page. Ideally looking for something with an index page, table cross-references as links, etc. Cheers. ___ sqlite-users mailing list

Re: [sqlite] Looking for SQLite schema doc generator (in HTML) for tables, fields, etc

2015-02-03 Thread RSmith
On 2015/02/03 17:34, Gerald Bauer wrote: Hello, I'm looking for a little tool that reads in an SQLite schema (e.g. beer.db, football.db, etc.) and outputs (generates) documentation for tables, fields etc. as a single HTML page or as HTML pages.Any insight appreciated? Actually I

Re: [sqlite] Looking for SQLite schema doc generator (in HTML) for tables, fields, etc

2015-02-03 Thread Rich Shepard
On Tue, 3 Feb 2015, Gerald Bauer wrote: I'm looking for a little tool that reads in an SQLite schema (e.g. beer.db, football.db, etc.) and outputs (generates) documentation for tables, fields etc. as a single HTML page or as HTML pages. Any insight appreciated? Gerald, While not in html

[sqlite] Looking for SQLite schema doc generator (in HTML) for tables, fields, etc

2015-02-03 Thread Gerald Bauer
Hello, I'm looking for a little tool that reads in an SQLite schema (e.g. beer.db, football.db, etc.) and outputs (generates) documentation for tables, fields etc. as a single HTML page or as HTML pages.Any insight appreciated? Cheers

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

2013-09-22 Thread William Drago
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 the tool automatically create a new d

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

2013-09-19 Thread Kees Nuyt
On Wed, 18 Sep 2013 20:53:31 -0700 (PDT), niubao <niuba...@gmail.com> wrote: >Thank you very much Simon, for your detailed and very clear explanation on >this. I wonder if there is some materials, a tutorial or something, that >are dedicated to SQLite schema change for beginners?

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

2013-09-19 Thread Peter Haworth
at 9:00 AM, <sqlite-users-requ...@sqlite.org> wrote: > Message: 3 > Date: Wed, 18 Sep 2013 13:54:34 -0700 (PDT) > From: niubao <niuba...@gmail.com> > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] A graphical tool to handle sqlite schema > change(more

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

2013-09-18 Thread niubao
Thank you very much Simon, for your detailed and very clear explanation on this. I wonder if there is some materials, a tutorial or something, that are dedicated to SQLite schema change for beginners? There seems to be so many things to consider. -- View this message in context: http

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

2013-09-18 Thread Simon Slavin
On 19 Sep 2013, at 3:50am, Bao Niu wrote: > After a thorough trial I've finally got this firefox add-on to work > properly. And it's great! It basically provides everything that I needed, > except for one: changing foreign key constraints from the gui. Is it > possible to do

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

2013-09-18 Thread Bao Niu
is email, your message will be added to the discussion > > below: > > > > > http://sqlite.1065341.n5.nabble.com/A-graphical-tool-to-handle-sqlite-schema-change-more-than-ALTER-TABLE-tp71338p71353.html > > To unsubscribe from A graphical tool to handle sqlite schema cha

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

2013-09-18 Thread niubao
reply to this email, your message will be added to the discussion > below: > > http://sqlite.1065341.n5.nabble.com/A-graphical-tool-to-handle-sqlite-schema-change-more-than-ALTER-TABLE-tp71338p71353.html > To unsubscribe from A graphical tool to handle sqlite schema change(more > than

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

2013-09-18 Thread niubao
-sqlite-schema-change-more-than-ALTER-TABLE-tp71338p71352.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

2013-09-18 Thread Jason H
It kinda is whe. All you nees is a select into Sent from Yahoo! Mail on Android ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

2013-09-18 Thread Kees Nuyt
On Wed, 18 Sep 2013 20:46:47 +, Reid Thompson <reid.thomp...@ateb.com> wrote: > >On Wed, 2013-09-18 at 11:02 -0700, Bao Niu wrote: > >> > > Is there a tool that allows you to graphically change sqlite schema as >> > simple >> > > as editing a

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

2013-09-18 Thread niubao
2 -0700, Bao Niu wrote: > > > > > Is there a tool that allows you to graphically change sqlite schema > as > > > simple > > > > as editing a spreadsheet? > > https://code.google.com/p/sqlite-manager/ should meet your needs > > > ___

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

2013-09-18 Thread Reid Thompson
On Wed, 2013-09-18 at 11:02 -0700, Bao Niu wrote: > > > Is there a tool that allows you to graphically change sqlite schema as > > simple > > > as editing a spreadsheet? https://code.google.com/p/sqlite-manager/ should meet your needs __

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

2013-09-18 Thread Bao Niu
Linux is the only operating system. On Sep 18, 2013 5:03 AM, "Simon Slavin" <slav...@bigfraud.org> wrote: > > On 18 Sep 2013, at 1:49am, niubao <niuba...@gmail.com> wrote: > > > Is there a tool that allows you to graphically change sqlite schema as > simpl

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

2013-09-18 Thread Tim Streater
On 18 Sep 2013 at 01:49, niubao <niuba...@gmail.com> wrote: > 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",

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

2013-09-18 Thread Simon Slavin
On 18 Sep 2013, at 1:49am, niubao <niuba...@gmail.com> wrote: > Is there a tool that allows you to graphically change sqlite schema as simple > as editing a spreadsheet? What Operating System ? Simon. ___ sqlite-users mailing list

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

2013-09-18 Thread jcd
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

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

2013-09-17 Thread Jason H
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

2013-09-17 Thread Jason H
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

2013-09-17 Thread Bao Niu
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 t

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

2013-09-17 Thread niubao
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 t

[sqlite] schema creation

2013-03-05 Thread Paolo Délano Alonso
I noticed that the schema for my table is not being created even though my object class has the proper attributes (PrimaryKey, Autoincrement). My object class is located in a different solution in my VS2012 project. I moved the object class to the same solution where I´m calling the SQLite

Re: [sqlite] (UML) Visualisation of a SQLite schema ?

2011-04-29 Thread Fredrik Karlsson
Hi, Just thought I'd tell you that I went into solving this issue myself. The resulting script is here: https://github.com/dargosch/sqlite2dot * Requires Tcl and the sqlite3 package for Tcl. It generates a .dot file for use with Graphviz. Very simple script, but it solves the issue I wanted to

Re: [sqlite] (UML) Visualisation of a SQLite schema ?

2011-04-15 Thread Gary_Gabriel
Hi Fredrik, > I'm looking for a tool that would generate a visualisation (UML?) of > the SQLite database schema I'm using, with table constraints and > references between tables if possible. Is there such a tool (for Mac)? > If you are interested in doing something yourself- then this might be

[sqlite] (UML) Visualisation of a SQLite schema ?

2011-04-15 Thread Fredrik Karlsson
Hi, I'm looking for a tool that would generate a visualisation (UML?) of the SQLite database schema I'm using, with table constraints and references between tables if possible. Is there such a tool (for Mac)? I've looked into SQL::Translator (produces reasonable output, but does not cover the

Re: [sqlite] Schema and database layout

2009-09-16 Thread Kavita Raghunathan
- Original Message - From: "P Kishor" <punk.k...@gmail.com> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Wednesday, September 16, 2009 9:00:29 AM GMT -06:00 US/Canada Central Subject: Re: [sqlite] Schema and database layout

Re: [sqlite] Schema and database layout

2009-09-16 Thread Pavel Ivanov
16, 2009 6:40:18 AM GMT -06:00 US/Canada Central > Subject: Re: [sqlite] Schema and database layout > >> KR: The 10 tables contain different data, but instead of doing this >> statement (example below) over >> and over, I want to just pass this table "type" because all

Re: [sqlite] Schema and database layout

2009-09-16 Thread P Kishor
ent: Wednesday, September 16, 2009 6:40:18 AM GMT -06:00 US/Canada Central > Subject: Re: [sqlite] Schema and database layout > >> KR: The 10 tables contain different data, but instead of doing this >> statement (example below) over >> and over, I want to just pass this t

Re: [sqlite] Schema and database layout

2009-09-16 Thread Kavita Raghunathan
- Original Message - From: "Pavel Ivanov" <paiva...@gmail.com> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Wednesday, September 16, 2009 6:40:18 AM GMT -06:00 US/Canada Central Subject: Re: [sqlite] Schema and database lay

Re: [sqlite] Schema and database layout

2009-09-16 Thread Pavel Ivanov
Kavita Raghunathan <kavita.raghunat...@skyfiber.com> wrote: > Please see clarifications below: > - Original Message - > From: "Pavel Ivanov" <paiva...@gmail.com> > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Sent: Tuesd

Re: [sqlite] Schema and database layout

2009-09-15 Thread Kavita Raghunathan
Please see clarifications below: - Original Message - From: "Pavel Ivanov" <paiva...@gmail.com> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Tuesday, September 15, 2009 4:36:19 PM GMT -06:00 US/Canada Central Subject: Re: [sq

Re: [sqlite] Schema and database layout

2009-09-15 Thread Simon Slavin
On 15 Sep 2009, at 10:27pm, Kavita Raghunathan wrote: > 1) dont see a way to reuse schemas. In other words, I have say 10 > tables with the same schema. How would I prevent doing 10 CREATE > table commands ? Would there be a way I can pass the schema as well > as data into SQLite ? If you

Re: [sqlite] Schema and database layout

2009-09-15 Thread Pavel Ivanov
> 1) dont see a way to reuse schemas. In other words, I have say 10 tables with > the same schema. How would I prevent doing 10 CREATE table commands ? Create 1 table with 1 additional column "schema" which will contain numbers from 1 to 10. > Would there be a way I can pass the schema as well

[sqlite] Schema and database layout

2009-09-15 Thread Kavita Raghunathan
All, I have a couple of questions: I've been studying the C/C++ interface, and 1) dont see a way to reuse schemas. In other words, I have say 10 tables with the same schema. How would I prevent doing 10 CREATE table commands ? Would there be a way I can pass the schema as well as data into

[sqlite] Generate an sqlite schema from a postgres dump

2009-07-10 Thread Paolo Tell
I googled and checked the archive of this mailing list without finding an answer to this topic. Is there a way to automaticaly create a db from a postgres dump? Including an appropriate conversion of the features that are different in the two database engines. Before starting doing it manually I

Re: [sqlite] Schema design and/or SELECT construction

2009-06-03 Thread Craig Smith
Chris and Jay: Thank you both very much for your comments; that solves it. I am not a trained database designer, but I have resources on normalization; I simply neglected to consult them, thinking that this was a SELECT problem, not a design problem. Your input was just what I was hoping

Re: [sqlite] Schema design and/or SELECT construction

2009-06-03 Thread Jay A. Kreibich
On Mon, Jun 01, 2009 at 09:21:40PM -0700, Craig Smith scratched on the wall: > Hello: > > I have about 3000 electronic images that I am preparing to distribute > to my family members. They use a variety of operating systems, so I > am providing the images on remote hard drives, with the

Re: [sqlite] Schema design and/or SELECT construction

2009-06-03 Thread Chris Peachment
What's wrong with a properly normalised schema like this: create table main (id, name,...); create table keyword (id, label); create table crossref (id_main, id_keyword); The concept of core and other keywords is a bit arbitrary. What is important (i.e. core) today might not be so tomorrow.

[sqlite] Schema design and/or SELECT construction

2009-06-03 Thread Craig Smith
Hello: I have about 3000 electronic images that I am preparing to distribute to my family members. They use a variety of operating systems, so I am providing the images on remote hard drives, with the images divided into folders based on years the images were created. All images were

Re: [sqlite] Schema syntax error

2009-03-22 Thread D. Richard Hipp
On Mar 18, 2009, at 9:39 PM, Tristan Seligmann wrote: > Divmod Axiom[1] is a Python ORM built on SQLite; one of the book > keeping tables it creates in the database has a column named > "indexed", which became a reserved word around SQLite 3.6.4 (?). The > "obvious" fix for this problem is to

Re: [sqlite] Schema syntax error

2009-03-19 Thread Kees Nuyt
On Thu, 19 Mar 2009 03:39:11 +0200, Tristan Seligmann wrote: >Divmod Axiom[1] is a Python ORM built on SQLite; one of the book >keeping tables it creates in the database has a column named >"indexed", which became a reserved word around SQLite 3.6.4 (?). The >"obvious"

[sqlite] Schema syntax error

2009-03-18 Thread Tristan Seligmann
Divmod Axiom[1] is a Python ORM built on SQLite; one of the book keeping tables it creates in the database has a column named "indexed", which became a reserved word around SQLite 3.6.4 (?). The "obvious" fix for this problem is to simply quote the column name using "", but the problem is that it

Re: [sqlite] schema optimization question

2008-05-23 Thread Stephen Oberholtzer
On Fri, May 23, 2008 at 3:01 PM, Jeff Gibson <[EMAIL PROTECTED]> wrote: > I'm sorry if this is an obvious question - I'm new to databases. I have > an application where the database is used to log a large number of > simulation events. The database is written once and read many times > (i.e.,

Re: [sqlite] schema optimization question

2008-05-23 Thread Keith Goodman
On Fri, May 23, 2008 at 12:01 PM, Jeff Gibson <[EMAIL PROTECTED]> wrote: > I'm sorry if this is an obvious question - I'm new to databases. I have > an application where the database is used to log a large number of > simulation events. The database is written once and read many times > (i.e.,

[sqlite] schema optimization question

2008-05-23 Thread Jeff Gibson
I'm sorry if this is an obvious question - I'm new to databases. I have an application where the database is used to log a large number of simulation events. The database is written once and read many times (i.e., there are never any inserts or updates after database creation). The three

Re: [sqlite] schema design question

2008-04-12 Thread Jay A. Kreibich
On Fri, Apr 11, 2008 at 01:54:43PM -0700, Richard Klein scratched on the wall: > Jay A. Kreibich wrote: > >On Thu, Apr 10, 2008 at 05:58:59PM -0700, Richard Klein scratched on the > >wall: > > > >>My advice would be to try it and see. If table creation takes too long, > >>you can always remove

Re: [sqlite] schema design question

2008-04-11 Thread Jeff Gibson
Thanks for all the suggestions. My schema is now a lot cleaner, and my application runs 30% faster! Jeff Richard Klein wrote: >> Jeff Gibson wrote: >> >>> One thing your earlier suggestion brought up. The way I was hooking up >>> tables before was something along the lines of: >>>

Re: [sqlite] schema design question

2008-04-11 Thread Richard Klein
Jay A. Kreibich wrote: > On Thu, Apr 10, 2008 at 05:58:59PM -0700, Richard Klein scratched on the wall: > >> My advice would be to try it and see. If table creation takes too long, >> you can always remove the UNIQUE constraint, and then write a routine to >> check the table for uniqueness after

Re: [sqlite] schema design question

2008-04-11 Thread Richard Klein
> Jeff Gibson wrote: >> One thing your earlier suggestion brought up. The way I was hooking up >> tables before was something along the lines of: >> >> CREATE TABLE primary(id1 INTEGER PRIMARY KEY, ); >> CREATE TABLE secondary(id2 INTEGER PRIMARY KEY, ); >> CREATE TABLE link(id1 INTEGER, id2

Re: [sqlite] schema design question

2008-04-11 Thread Dennis Cote
Jeff Gibson wrote: > > One thing your earlier suggestion brought up. The way I was hooking up > tables before was something along the lines of: > > CREATE TABLE primary(id1 INTEGER PRIMARY KEY, ); > CREATE TABLE secondary(id2 INTEGER PRIMARY KEY, ); > CREATE TABLE link(id1 INTEGER, id2

Re: [sqlite] schema design question

2008-04-11 Thread Jay A. Kreibich
On Thu, Apr 10, 2008 at 05:58:59PM -0700, Richard Klein scratched on the wall: > My advice would be to try it and see. If table creation takes too long, > you can always remove the UNIQUE constraint, and then write a routine to > check the table for uniqueness after it's created. That

Re: [sqlite] schema design question

2008-04-10 Thread Richard Klein
Jeff - I'm pretty new to databases myself, but I have seen examples of schemas that resemble your first alternative, i.e. that involve the creation of a third table containing just the linkages between the primary and secondary tables. And in fact, I think that is the right solution for your

Re: [sqlite] schema design question

2008-04-10 Thread Jeff Gibson
Right. Hence my hesitation. :-) I suppose it's possible to check uniqueness once at the end in O(N), but it would also take O(N) extra storage, and I doubt sqlite is doing that... One thing your earlier suggestion brought up. The way I was hooking up tables before was something along the

Re: [sqlite] schema design question

2008-04-10 Thread Richard Klein
On second thought, checking the entire table for uniqueness would seem to require O(N log N), regardless of whether it is done one INSERT at a time, or all at once after the table is created! - Richard Richard Klein wrote: > Quoting from the description of CREATE TABLE in the SQL Syntax section

Re: [sqlite] schema design question

2008-04-10 Thread Richard Klein
Quoting from the description of CREATE TABLE in the SQL Syntax section of the SQLite documentation: "The UNIQUE constraint causes an index to be created on the specified columns. This index must contain unique keys." The creation of an index would seem to imply an O(log N) search on each

Re: [sqlite] schema design question

2008-04-10 Thread Jeff Gibson
I see. Fortunately my application simplifies this since the database is created once and read many times, but is never modified after creation time. Regarding constraints, I was thinking it might be helpful to add a few where applicable (whether foreign key constraints or even simple

Re: [sqlite] schema design question

2008-04-10 Thread Richard Klein
Jeff, I think that's the right way to go for your application. There are a few things you should be aware of regarding this approach. A column in one table that references a column in another table is called a "foreign key" in database lingo. An issue with foreign keys is that it is important

  1   2   >