Re: [sqlite] table backup

Hi Roger, I don't have any clue. Two databases are corrupted. First one, while inserting 20,000 records suddenly sqlite thrown disk io error at 4,000 record. No clue. Second database corrupted when my application crashed. But that time, second database was not opened. So, I am planning to

Re: [sqlite] Unql

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/12/12 19:01, dcharno wrote: > What ever happened to Unql and is there any chance it will be revived? > It seemed like it would have been incredible useful. Warning: My opinion only Unql seemed to be especially pointless. Being somewhat

[sqlite] Unql

What ever happened to Unql and is there any chance it will be revived? It seemed like it would have been incredible useful. :( ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Foreign key constraint with m:n relationship

Kristine Peters wrote: > Does sqlite3 support foreign key constraints with m:n relations? In your logical model, you have a M:N relation. In the phyiscal database, however, you implement this as a separate table which can be seen as having two 1:N relations, so what you have are two separate

[sqlite] Foreign key constraint with m:n relationship

Does sqlite3 support foreign key constraints with m:n relations? I can get cascade update/delete to work with 1:n relations, but not m:n. Example, this schema works: (yes, it¹s from the Elmasri text; it shows a 1:n relationship between EMPLOYEE and DEPARTMENT; also the 1:N relationship to the

Re: [sqlite] table backup

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/12/12 21:44, dd wrote: > Sometimes, sqlite databse corrupts. That is the problem you need to fix. If you have a system that is unreliable then it will also corrupt your backups. http://www.sqlite.org/lockingv3.html#how_to_corrupt

[sqlite] [Abwesenheitsnotiz] sqlite-users Digest, Vol 60, Issue 10

Hallo, vielen Dank für Ihre Nachricht. Ich bin in der Zeit vom 10.12. bis 11.12.2012 im Urlaub und werde mich nach meiner Rückkehr bei Ihnen melden. Ihre Nachricht wird nicht weitergeleitet. Mit freundlichen Grüßen Carl Slowinski oxando GmbH Konrad-Zuse-Ring 12 D-68163 Mannheim Germany

Re: [sqlite] SQLite logo usage

On Mon, Dec 10, 2012 at 11:04 AM, Bruno Kim Medeiros Cesar < brunokim...@gmail.com> wrote: > Thanks for your answer. > > Is it explicit somewhere in the site, or should it be? I guessed to be the > case, but there's no notice as we see on NASA images, for example. > There is no notice on the

Re: [sqlite] SQLite logo usage

Thanks for your answer. Is it explicit somewhere in the site, or should it be? I guessed to be the case, but there's no notice as we see on NASA images, for example. Bruno Kim Medeiros Cesar Eng. de Computação 2008 - EESC - USP brunokim...@gmail.com Skype: bkim.cesar 2012/12/10 Richard Hipp

Re: [sqlite] SQLite logo usage

On Mon, Dec 10, 2012 at 9:40 AM, Simon Slavin wrote: > > On 10 Dec 2012, at 2:38pm, Richard Hipp wrote: > > > The "SQLite" name and the new SQLite Logo are registered trademarks. > > Let's ask it a different way. If I write something and want to list >

Re: [sqlite] SQLite logo usage

On 10 Dec 2012 at 14:40, Simon Slavin wrote: > On 10 Dec 2012, at 2:38pm, Richard Hipp wrote: > >> The "SQLite" name and the new SQLite Logo are registered trademarks. > > Let's ask it a different way. If I write something and want to list SQLite as >

Re: [sqlite] String not valid DateTime

On 10 Dec 2012 at 14:05, William Drago wrote: > I am using SQLite with C# and am having trouble with SQLite > DATETIME types. The following error occurs when trying to > read rows from a table that contains dates (e.g. "12/09/2012 > 22:51:24"). (I am using a

Re: [sqlite] SQLite logo usage

On 10 Dec 2012, at 2:38pm, Richard Hipp wrote: > The "SQLite" name and the new SQLite Logo are registered trademarks. Let's ask it a different way. If I write something and want to list SQLite as one of the technologies in it, how would you like me to list SQLite ? Is there

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

Lets agree to disagree, sqlite is completely cross-plaform. You could develop a cross plate-form solution in the same time (Qt or Tcl/tk). The 95% market does not hold if you think smart-phone and tablet (a good target for a simple data entry application). If you only want windows, why not uuse

Re: [sqlite] SQLite logo usage

On Mon, Dec 10, 2012 at 8:57 AM, Bruno Kim Medeiros Cesar < brunokim...@gmail.com> wrote: > Hello. > > Is there a policy on how to use the SQLite logo? Is it copyrighted or in > public domain? I found it as an SVG in a non-official site, and was > wondering if it is free to edit and modify. >

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

On Mon, 10 Dec 2012 15:07:05 +0100, Noel Frankinet wrote: >It's probably a good way to get something working, but you loose the >cross-platform I know, but Windows is 95% of the market for end-users, cross-platform is a pain to write, they take longer to load and always

Re: [sqlite] just a test

Gmail users: You can set a Filter to ensure the Igor's messages are delivered to your in-box. I did this last week and since then his messages do not end up in my SPAM folder. If you search "This message may not have been sent by..." warning in Gmail help, there are instructions. Adam On

Re: [sqlite] String not valid DateTime

William Drago wrote: > I am using SQLite with C# and am having trouble with SQLite DATETIME > types. In SQLite, the DATETIME type is interpreted in the same way as the FLUFFY_BUNNIES type, i.e., it is not recognized at all. Due to SQLite's dynamic typing, values in that column have the same type

Re: [sqlite] String not valid DateTime

William Drago wrote: > I am using SQLite with C# and am having trouble with SQLite > DATETIME types. The following error occurs when trying to > read rows from a table that contains dates (e.g. "12/09/2012 > 22:51:24"). (I am using a SQLiteDataReader to put query >

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

It's probably a good way to get something working, but you loose the cross-platform On 10 December 2012 14:47, Gilles Ganault wrote: > On Mon, 10 Dec 2012 11:49:31 +, Simon Slavin > wrote: > >There are lots of people who manipulate data that

[sqlite] String not valid DateTime

All, I am using SQLite with C# and am having trouble with SQLite DATETIME types. The following error occurs when trying to read rows from a table that contains dates (e.g. "12/09/2012 22:51:24"). (I am using a SQLiteDataReader to put query results into a C# DataTable.) "String was not

[sqlite] SQLite logo usage

Hello. Is there a policy on how to use the SQLite logo? Is it copyrighted or in public domain? I found it as an SVG in a non-official site, and was wondering if it is free to edit and modify. I would like to do a little homage to SQLite, and have inserted the blessing within the blue box as in

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

On Mon, 10 Dec 2012 11:49:31 +, Simon Slavin wrote: >There are lots of people who manipulate data that way, but they tend to export > their data from the SQLite database into their favourite spreadsheet app, > do the manipulation there, then reimport to SQLite. > This

Re: [sqlite] just a test

Clearly, Igor is too helpful and responds to too many messages... *rolls eyes* I'm not on gmail, so I didn't know this was even a problem, but hopefully it gets sorted out soon. Ryan On 09/12/2012 2:01 AM, dd wrote: Yes. Igor Tandetnik mails marked as a spam nowadays. I marked it as a NOT

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

On 10 Dec 2012, at 11:00am, Gilles Ganault wrote: > That's why I thought there could be a need for a datagrid that would > save data in SQLite and provide basic sort/search functions. There are lots of people who manipulate data that way, but they tend to export their

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

On Sun, 09 Dec 2012 14:15:30 +0100, Olaf Schmidt wrote: >The only thing remaining for a decent workflow, which in >the end is based on SQLite-storage, would then be a small >batch-program or -script, which ensures the SQLite-To-CSV >conversion (the sqlite-commandline-tool could do

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

On Sun, 9 Dec 2012 07:42:08 -0600, "Michael Black" wrote: >Generally speaking database and spreadsheet functionality are not similar >enough to combine. Thanks for the input. Indee, maybe the two concepts are just too different.

[sqlite] Link pragma.html#pragma_user_version invalid

In the list of PRAGMAs in pragma.html the "PRAGMA user_version" documentation link to http://www.sqlite.org/pragma.html#pragma_user_version is invalid. It should point to http://www.sqlite.org/pragma.html#pragma_schema_version instead. This is also present in today's documentation