[sqlite] First Reunion The Sqlite Latino

Hello the Free Software III Conference organized by students from the Universidad Nacional de Jujuy - UNJu in Jujuy Province - Argentina - The Community SQLite - Latino . Saludos Gerardo Cabero [0] sqlite-latino.blogspot.com ___ sqlite-users mailing

Re: [sqlite] On UNIQUE and PRIMARY KEY

On Sep 4, 2008, at 8:56 PM, Darren Duncan wrote: > D. Richard Hipp wrote: >> One occasionally sees SQLite schemas of the following form: >> >> CREATE TABLE meta(id LONGVARCHAR UNIQUE PRIMARY KEY, ); >> >> In other words, one sometimes finds a PRIMARY KEY and a UNIQUE >> declaration on

Re: [sqlite] On UNIQUE and PRIMARY KEY

D. Richard Hipp wrote: > One occasionally sees SQLite schemas of the following form: > > CREATE TABLE meta(id LONGVARCHAR UNIQUE PRIMARY KEY, ); > > In other words, one sometimes finds a PRIMARY KEY and a UNIQUE > declaration on the same column. This works fine in SQLite, but it is

Re: [sqlite] Core dump version 3.6.2

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ken wrote: > Core dump backtrace, using sqlite3 version 3.6.2... > Suse Linux, gcc 4.2.1 > > Any ideas? By far the easiest way of diagnosing is to run valgrind. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux)

Re: [sqlite] Logging

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hardy, Andrew wrote: > Do I have to pass function pointers (for functions that implement the > appropriate logging) to these functions (the ones below) then my > functions get called back omn the appropriate activity? Yes, those functions are to

[sqlite] Core dump version 3.6.2

Core dump backtrace, using sqlite3 version 3.6.2... Suse Linux,  gcc 4.2.1 Any ideas? Program terminated with signal 11, Segmentation fault. #0  0x2b4ead3562d2 in ?? () from /lib64/libc.so.6 (gdb) backtrace #0  0x2b4ead3562d2 in ?? () from /lib64/libc.so.6 #1  0x2b4ead357d1b in ??

[sqlite] On UNIQUE and PRIMARY KEY

One occasionally sees SQLite schemas of the following form: CREATE TABLE meta(id LONGVARCHAR UNIQUE PRIMARY KEY, ); In other words, one sometimes finds a PRIMARY KEY and a UNIQUE declaration on the same column. This works fine in SQLite, but it is wasteful, both of disk space and

Re: [sqlite] Query runs faster when repeating condition

Magnus Manske <[EMAIL PROTECTED]> wrote: > I've found the strangest issue today. I have a sqlite3 database that > contains the following table: > > CREATE TABLE MAL9_single ( read_name VARCHAR[32], pos1 INTEGER, seq1 > VARCHAR[64] ); > CREATE INDEX MAL9_sin_index ON MAL9_single ( pos1 ); > > From

[sqlite] Query runs faster when repeating condition

Hi, I'm new to the list, but have been an enthusiastic sqlite user for years. I've found the strangest issue today. I have a sqlite3 database that contains the following table: CREATE TABLE MAL9_single ( read_name VARCHAR[32], pos1 INTEGER, seq1 VARCHAR[64] ); CREATE INDEX MAL9_sin_index ON

Re: [sqlite] SQLite DB memory fault error

are you sure that the nickname field is 100 bytes? Why do you use strncpy(d,s,100 ) why not strncpy(d,s, sizeof(d)) Other than that, hard to tell without seeing the data types and declarations. Might want to post on a C programming board. --- On Thu, 9/4/08, kogure <[EMAIL

Re: [sqlite] Broken indexes ...

Jordan Hayes wrote: > > Where would the file be? It would be "beside" the database file, i.e. in the same directory as the database file. The journal only exists while sqlite is modifying the database. When a change has been completed successfully, the journal file is deleted. > I don't

Re: [sqlite] Logging

I've taken a brief look at this in the source. Do I have to pass function pointers (for functions that implement the appropriate logging) to these functions (the ones below) then my functions get called back omn the appropriate activity? I think I could use an example to help me along. Can

Re: [sqlite] Entity Relationship Diagram Tool for SQLite

Hello, Thank you to all that responded both via the list and privately. It was pointed out that I was not clear in my original question. I am looking for a tool that can create ER diagrams from a SQLite database. Along with dia and dezign I also found SQLite Maestro at

Re: [sqlite] SQLite DB memory fault error

"kogure" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello everyone. I have a database with fields not required to be > filled in (the other fields are declared NOT NULL). When I have a > record with the non-required fields empty, and copied it to my > structure, there is a

Re: [sqlite] vertical -> horizontal data conversion

Andy, You should be looking for pivot tables. However, there is no native support for them in sqlite as far as I know. Some databases (e.g. SQL Server 2005+) know PIVOT command but not sqlite. You may want to look at

Re: [sqlite] Entity Relationship Diagram Tool for SQLite

On 9/4/08, Hardy, Andrew <[EMAIL PROTECTED]> wrote: > > Not sure if this is what David is getting at, iro specifically saying > sqlite, but I'd be interested in something that generates a schema > diagram from an existing sqlite db file. Or are there tools that can do > this from the text of

[sqlite] vertical -> horizontal data conversion

Hi, I have a table like this create table clinical_data ( group_def text, item_def text, value text ); Assuming this example data... GROUP_DEF, ITEM_DEF, VALUE --- "MEDHIST", "BODSYS", "foo" "MEDHIST", "TERM", "bar" "MEDHIST", "ONSET",

Re: [sqlite] Logging

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hardy, Andrew wrote: > What's the most efficient way of getting a log file of the db activity > on your sql db over a time period. Can you get timings against these > acrtivities? You have to write code/callbacks that interface with the library.

Re: [sqlite] sqlite3_bind_int64, sqlite3_bind_int, sqlite_uint64

Martin (OpenGeoMap) wrote: >> Neither C nor C++ define the specific sizes of different types. >> Therefore, "long long int" can be different sizes on different >> platforms, or even within different compilers for the same platform. >> Without more information, we cannot say for sure if a

[sqlite] Logging

What's the most efficient way of getting a log file of the db activity on your sql db over a time period. Can you get timings against these acrtivities? Regards, Andrew ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Entity Relationship Diagram Tool for SQLite

Not sure if this is what David is getting at, iro specifically saying sqlite, but I'd be interested in something that generates a schema diagram from an existing sqlite db file. Or are there tools that can do this from the text of a dump, if the sql is standard enough? Andrew -Original

Re: [sqlite] sqlite3_bind_int64, sqlite3_bind_int, sqlite_uint64

> > Neither C nor C++ define the specific sizes of different types. > Therefore, "long long int" can be different sizes on different > platforms, or even within different compilers for the same platform. > Without more information, we cannot say for sure if a "long long int" > is 64