[sqlite] Data Modeling Tools

Hello all, I am working on a project that is based around SQLite as a data format (so to speak), and as such, I would like to be able to show others various diagrams of the data models. Are there any programs that will work with SQLite directly? Or any generic tools that anyone could suggest?

Re: [sqlite] Adding Custom Column Data Types

Thanks, Everyone. I think I understand this enough to at least attempt to test it, unfortunately, it will probably be a couple of days before them. I will let you know the results... Mike On Wed, Jan 28, 2009 at 2:24 AM, MikeW <mw_p...@yahoo.co.uk> wrote: > Mike McGonagle <mjm...

Re: [sqlite] Am I understanding Blobs correctly?

Thanks, the datatypes are going to be varied, but I am sure the sizes are the things I need to consider. Mike On Mon, Jan 26, 2009 at 8:27 PM, P Kishor wrote: > If you have a lot of tiny images, especially if the images can be > smaller than a page size in the db, then

[sqlite] Am I understanding Blobs correctly?

Hello all, I have never used Blobs before, and in reading some of the literature, I am just a bit confused. From what I am understanding, I get the impression that a Blob is no more than the binary data from a disk file, stored as a string of bytes in a field of the database. Basically, I am

[sqlite] Adding Custom Column Data Types

Hello all, I am in the process of integrating SQLite into a multimedia environment/programming language. One thing that I would like to be able to do is support all the various datatypes in this language, and one in particular is a list of other primitive datatypes. Is there a way to add a

Re: [sqlite] Question about sqlite3_reset

On Thu, Jan 15, 2009 at 1:52 PM, Vivien Malerba wrote: > Hi! > > I have the following situation: > * a prepared statement (for a SELECT) on which sqlite3_step has been called > successfully (meaning having returned SQLITE_ROW or SQLITE_DONE each time) > * I call

Re: [sqlite] SQLite version 3.6.10

Thank you for these releases, I appreciate (and agree) with your reasons for the many releases. For me, it really is so simple that all I do is take the Amalgamated version and swap it out for the previous version. I can only think that anyone who has troubles with a swap like this may be doing

Re: [sqlite] Is this legal SQL?

Thanks for the advice, everyone was a help in this... On Mon, Jan 12, 2009 at 6:41 PM, Igor Tandetnik > Why do you want to create a bunch of identical tables in the first > place? What are you trying to achieve? I am working with Multimedia stuff, and each table, while holding the same fields,

[sqlite] Is this legal SQL?

Hello all, I am working on connecting SQLite up to another programming language, and had a question about how SQLite (or SQL in general) would handle this... I want to be able to create some tables dynamically (same structure, different name), and I thought this might work... CREATE TABLE ?1 (x

Re: [sqlite] a suggestion to write tutorial for sqlite

For what it is worth, while I had done a few simple things in MySQL prior to using SQLite, I think it would be nice if there were a couple of different "tracks" of tutorials. Maybe they could be one for the "Novice", one for an "Experienced" user, and then one for those that are doing actual C

Re: [sqlite] Clear screen in command line interface

Hum, on the Mac (10.4.9), the terminal window can be cleared from within the terminal program itself. I would imagine that other terminal programs also provide this. Does this functionality really need to be in SQLite? Mike On Wed, Mar 26, 2008 at 1:59 PM, Fred J. Stephens <[EMAIL PROTECTED]>

Re: [sqlite] Question on Queries

Thanks for everybody's input, I will test these things out tonight... On Mon, Mar 3, 2008 at 3:53 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > > SELECT data FROM LIST l > > INNER JOIN MAIN m ON l.mid = m.id > > WHERE m.name = "something"; > > The two statements are not equivalent: they

Re: [sqlite] Question on Queries

Oh, I forgot to mention (if it matters), the "MAIN" table has about 3000 rows in it, while the "LIST" table has about 6 rows. Mike On Mon, Mar 3, 2008 at 3:32 PM, Mike McGonagle <[EMAIL PROTECTED]> wrote: > Hello all, > I was working with some queries last

[sqlite] Question on Queries

Hello all, I was working with some queries last night, and ran accross something that I don't quite understand. Basically, this is what I have... *** CREATE TABLE MAIN ( id integer primary key autoincrement not null, name varchar(30), [other fields left out, as they are

Re: [sqlite] Question on Blobs

27, 2008 at 8:02 PM, Peter A. Friend <[EMAIL PROTECTED]> wrote: > > On Feb 27, 2008, at 4:48 PM, Mike McGonagle wrote: > > > Hello all, > > I was hoping that someone might share some tips on working with > > Blobs? I > > would like to be able to store some i

Re: [sqlite] Version 3.2.2

Trey, Could you site a reference on this? I have been looking for documentation on how SQL deals with quoted things for a while now, but have not found anything. Thanks, Mike On Feb 6, 2008 8:21 PM, Trey Mack <[EMAIL PROTECTED]> wrote: > > UPDATE listings SET buyer = 'Price' WHERE listnum =

Re: [sqlite] Question on SQL arbitrary arrays

On Jan 16, 2008 2:18 PM, Dennis Cote <[EMAIL PROTECTED]> wrote: > Mike, > > Do you need to be able to access the individual array elements with SQL > statements, or do you simply need to save and restore entire arrays? The arrays are a set, so they would never be addressed as individual

Re: [sqlite] Dump w/o Schema

On Jan 15, 2008 2:37 PM, Mark Riehl <[EMAIL PROTECTED]> wrote: > Is there a way to dump out the contents of the database w/o having the > CREATE TABLE statements? For example, I can do the following: > > sqlite3 foo.db .dump > foo.dmp > You could do something like on Unix: sqlite3 foo.db .dump

Re: [sqlite] Question on SQL arbitrary arrays

On Jan 14, 2008 11:28 PM, mark pirogovsky <[EMAIL PROTECTED]> wrote: > It is really hard to give you some idea without knowing more of you > problem... but your proposed implementation does carry a lot of > overhead - for every number you have two extra fields, not to mention > the database

[sqlite] Question on SQL arbitrary arrays

Hello all, This isn't s question specific to SQLite, so I hope that you don't mind... but, I am trying to store an ordered lists of numbers of arbitrary length in a table. I am not really sure what the best method of doing this, but the way that I have come up with is to create a table with the

[sqlite] Repository for User defined functions

Hello all, I was just curious if there was a respository for user defined functions? I was hoping to find a hash function that I could use to hash some strings with, and I have not seen anything in the SQLite docs. Thanks, Mike

[sqlite] Intro and question

Hello all, My name is Mike "Mogo" McGonagle. I found SQLite about 3 months ago, and have beeen hooked ever since. As I am interested in using SQL in a multimedia environment, I have been working on connecting SQLite up with the data-flow/graphical programming language Pure Data. (