[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 l

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 the

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) iD8DBQFIwHbmmOOf

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 regi

[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] [ANN] Nanoki & SQLite's FTS

Hello, Nanoki, a simple, elegant wiki engine implemented in Lua. http://alt.textdrive.com/nanoki/ Online demo: http://svr225.stepx.com:3388/search?q=chicago Nanoki incorporates SQLite excellent FTS module to provide full text search. Cheers, PA.

[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 of

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 P

[sqlite] ICU and SQlite

Hi there, i need to be able to sort results from a select statement in alphabetic order. The results however can have diacritic characters, like the german Umlaute "Ä,Ö,Ü"). They are supposed to be sorted like "AE", "OE" and "UE". I have been pointed to ICU as the solution. I got a download lin

Re: [sqlite] Writing an image to the database as a BLOB

Jared Miller wrote: > > //bind blob m_pSqliteDB->BindBlob(blobHandle, 1, (void *)bmBytes, > bmSize); //calls sqlite3_bind_blob (bmBytes is the pData param) > Can you show the code you use to call sqlite3_bind_blob() as well? > Then I call StepQuery to execute it, and then I close the query. > s

[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 MAL9

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 PROTECTED]

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 se

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 som

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 http://www.sqlmaestro

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 memory

[sqlite] SQLite DB memory fault error

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 memory fault (core dumped) error. Here is the snippet of my code: if

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 http://mesh.dl.sourceforge.net/sourceforge/souptonuts/Solving_Complex_SQL_Proble

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 a

[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", "baz

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. sqli

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 "l

[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 http://sqlite.org:8080/cgi-

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 Mes

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 bits