Re: [sqlite] Once again about file change counter

On Tue, Mar 6, 2012 at 9:55 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 06/03/12 01:56, Max Vlasov wrote: > > I don't see a problem here. > > ... For example the user could use the app for 3 hours and perform what > they > consider to be

[sqlite] About doc generation tool of SQLite

In document of SQLite in URL:http://www.sqlite.org/capi3ref.html It says: "This document is created by a script which scans comments in the source code files." I tried to find this script in the repo of SQLite, but I didn't find it. Is there any one know where is it. Thx. Regards, Yang

[sqlite] I can't open the link https://docs.google.com/viewer?a=v=explorer=true=0BzRwojdN0G2UMWY2MTg2NzgtNDU3YS00Y2RiLWI5MTktMDZiMDYxZGU5MGEx=en_US=1

Date: Thu, 01 Mar 2012 19:39:41 -0800 From: Larry Brasfield To: sqlite-users@sqlite.org Subject: Re: [sqlite] import a txt into sqlite Message-ID: <4f5040fd.3000...@iinet.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed YAN HONG YE wrote: > I have a txt

Re: [sqlite] What do people think of SQLite Root?

I use SQLite Expert. There is a fee for the professional version, but it is one time, all updates are free. http://www.sqliteexpert.com/ On Tue, Mar 6, 2012 at 1:43 PM, Fabio Spadaro wrote: > Hi. > > Il giorno 06 marzo 2012 17:31, Kit ha scritto:

[sqlite] SQLite Manager question

After recent postings, I have a demo version of SQLite manager. I'm noticing that the same simple query (SELECT * FROM ) on a table with around 50k rows takes anywhere from 3-10 times longer in the SQL tab than the Manage tab according to the timings that SQLite Manager shows. Any ideas why that

[sqlite] C# How to getorun autoincrement value

Hi, I don't know how to make this EASY thing (for me side) I found only this, but they said it is solverd, but it isn;t http://stackoverflow.com/questions/3828098/solved-how-to-return-autoincrement-value-in-insert-query-in-sqlite I don;t know what I get exception Not supported when I tried to

Re: [sqlite] What do people think of SQLite Root?

Hi. Il giorno 06 marzo 2012 17:31, Kit ha scritto: > > Announcement of the release Sqlite Root > now available for Linux. > > Any feedback is appreciated. > > Fabio Spadaro > > Two big problems: > - license > - size > > This software is

Re: [sqlite] Building an SQLite Extension: How to Persist Configurations/Variables for a database

On 3/6/2012 13:03, Peter Aronson wrote: I didn't, but I could have, by using authorizer function (relatively easy -- see sqlite3_set_authorizer), and setting it in the extension initialization function. Mind you, I generally feel if people are going to muck with the metadata, it's their own

Re: [sqlite] Building an SQLite Extension: How to Persist Configurations/Variables for a database

I didn't, but I could have, by using authorizer function (relatively easy -- see sqlite3_set_authorizer), and setting it in the extension initialization function.  Mind you, I generally feel if people are going to muck with the metadata, it's their own problem. Peter  

Re: [sqlite] Once again about file change counter

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/03/12 01:56, Max Vlasov wrote: > I don't see a problem here. Apologies for not being clear enough. What I meant is that there is a user using the app and the app in turn is using the database. When the user does actions that can result in one

Re: [sqlite] Building an SQLite Extension: How to Persist Configurations/Variables for a database

It's just basic SQLite reading and writing logic, like in here: http://www.sqlite.org/cintro.html Best, Peter On 3/6/2012 9:44 AM, Grace Simon Batumbya wrote: On 3/6/2012 11:22, Peter Aronson wrote: The simplest approach would be to create a table to hold this information. I have an

Re: [sqlite] UPDATE failure

2012/3/6 : > UPDATE table_name SET IdDeptGroup=1, Gross=Gross+ integer_value  WHERE > Id_= Id_value > > Have you ever seen a mismatch(sum is lower then expected) in the final sum > result ? Missing some `Id_` in the table? -- Kit

Re: [sqlite] Create Temp Table from Query

Yes, that is what I'm looking for. This type of query crashes my browsers so I'm assuming that the question is based on the concept and not the actual syntax? On Mar 2, 2012 10:08 AM, "Marc L. Allen" wrote: > CREATE TEMPORARY TABLE XYZ AS >SELECT ... > > Is

Re: [sqlite] Building an SQLite Extension: How to Persist Configurations/Variables for a database

On 3/6/2012 11:22, Peter Aronson wrote: The simplest approach would be to create a table to hold this information. I have an extension that works way -- you have to run an initialization function (SELECT function();) to create metadata tables before creating any tables using the extension.

Re: [sqlite] What do people think of SQLite Root?

> Announcement of the release Sqlite Root  now > available for Linux. > Any feedback is appreciated. > Fabio Spadaro Two big problems: - license - size This software is unusable for me. -- Kit ___ sqlite-users mailing

Re: [sqlite] Building an SQLite Extension: How to Persist Configurations/Variables for a database

The simplest approach would be to create a table to hold this information. I have an extension that works way -- you have to run an initialization function (SELECT function();) to create metadata tables before creating any tables using the extension. Best, Peter On 3/6/2012 6:35 AM, Grace

Re: [sqlite] What do people think of SQLite Root?

> Download the latest version Sqlite Root 1.9.7.6 > BTW, if you press Help then log in windows 7 using that version I get a crash as well. Traceback Info: Traceback (most recent call last): File "core.pyo", line 2481, in actionLog File "framelog.pyo",

Re: [sqlite] What's the best way to organize this database?

It's a fine start but depending on how large the database is likely to grow (how many songs, how many plays of the same song), you might not want to duplicate the song info every time it's played. Look up normalisation (or if you're American you might want to spell that with a z ;).

Re: [sqlite] What's the best way to organize this database?

that if you are going to want to search and sort by date order it's best to store dates in an order which is naturally sortable. So store a Julian Date number, or perhaps in the form YYYYMMDD (e.g. '20120306' for today). Don't store them in an order that's designed for humans to read. > So I'm

[sqlite] UPDATE failure

Hallo, I'm working with SQLite rel.3.4.3. on embedded system with ARM processor (unfortunately I cannot use a more recent release due to customizations on source code) I need to update a db of statistics very often, opening and closing db handle many times, with a short delay between each

Re: [sqlite] What do people think of SQLite Root?

Hi. Il giorno 05 marzo 2012 20:50, Dimiter 'malkia' Stanev ha scritto: > > > Unfortunately I've got an error when opening our db (SQLite Root 1.9.7.4): > >Traceback Info: > Traceback (most recent call last): > File "core.pyo", line 2731, in OnOpenDialogXOpenDb >

[sqlite] SQLLite issue - Database full on Solaris

> Hi, > I am getting SQLLite error “Database full” on solaris box and I can see that > a lot of space still there. Unfortunately we are running very old version of > SQLLite 3.2.2. > This is not even reproducible so I do not know when it comes again. > > Can you suggest a way to find out or

[sqlite] What's the best way to organize this database?

Hi all. I'm very new to all of this, so I'm not necessarily looking for over-the-top advice, although anything you tell me will be appreciated. I just want to create a simple script (in Python, using sqlite3) that reads a "|" delineated text file and extracts the following bits of information

Re: [sqlite] diff/patch SQLite databases

On 6 Mar 2012, at 1:34pm, Larry Knibb wrote: > I wouldn't initially need to support schema changes, just data > changes. And actually only data additions (INSERTs) as the first use > case. So diffing the .dumps would probably suffice. But later, I'd > want to handle

[sqlite] Building an SQLite Extension: How to Persist Configurations/Variables for a database

Hello there, I am developing an SQLite extension in which I would like the user to be able to specify some configurations before the creation of any tables and then have those settings persist for that database.( I got this idea from the way pragma encoding work

Re: [sqlite] diff/patch SQLite databases

I wouldn't initially need to support schema changes, just data changes. And actually only data additions (INSERTs) as the first use case. So diffing the .dumps would probably suffice. But later, I'd want to handle UPDATE and DELETE. I'm sure I can write a small utility in Perl but just wanted to

Re: [sqlite] diff/patch SQLite databases

On 6 Mar 2012, at 1:19pm, Larry Knibb wrote: > Is there already an established mechanism for diffing two SQLite > databases and creating a SQL patch file? > > So not a GUI diff tool (like > http://download.cnet.com/SQLite-Diff/3000-10254_4-205921.html) for > looking at

[sqlite] diff/patch SQLite databases

Is there already an established mechanism for diffing two SQLite databases and creating a SQL patch file? So not a GUI diff tool (like http://download.cnet.com/SQLite-Diff/3000-10254_4-205921.html) for looking at the diffs, but something to generate the SQL to upgrade an old database to a new

Re: [sqlite] Tuning a SQLite database for best compression

Thanks Scott, It is much better without the indexes. The uncompressed db file after dropping the indexes and vacuuming is 23MB compared to 43MB with indexes. Deflate cuts the size down to 10MB. The LZMA archive is less than 7MB - more or less the same as the Deflated SQL. I really need an LZMA

Re: [sqlite] Once again about file change counter

On Tue, Mar 6, 2012 at 4:00 PM, Dan Kennedy wrote: > On 03/06/2012 06:45 PM, Max Vlasov wrote: > >> >>> >> It's an interesting suggestion, thanks. I just thought that using xSync I >> even can only implement my own db change counter. In any case the question >> is will it

Re: [sqlite] Tuning a SQLite database for best compression

Hi Roger, Fantastic - thanks for your comprehensive reply. Funnily enough I had already stripped out the INSERT INTO TABLE VALUES text to see if that would make a difference but actually it looked like both compression algorithms were pretty much eliminating all the duplication there already. One

Re: [sqlite] Once again about file change counter

On 03/06/2012 06:45 PM, Max Vlasov wrote: On Tue, Mar 6, 2012 at 2:37 PM, Dan Kennedy wrote: On 03/06/2012 02:41 PM, Max Vlasov wrote: But for correct work this vfs should rely on the fact that file change counter will stay the same until the final write to the

Re: [sqlite] Once again about file change counter

On Tue, Mar 6, 2012 at 2:37 PM, Dan Kennedy wrote: > On 03/06/2012 02:41 PM, Max Vlasov wrote: > >> But for correct work this vfs should rely on the >> fact that file change counter will stay the same until the final write to >> the first sector. >> > > > Do you just

Re: [sqlite] Once again about file change counter

On 03/06/2012 02:41 PM, Max Vlasov wrote: Hi, there are some ideas for vfs implementation that would require tracking file change counter. As I recall, I asked about specific api for working with file change counter, and seems like there was no such. On the other side it looks like it's not a

Re: [sqlite] Once again about file change counter

On Tue, Mar 6, 2012 at 12:22 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 05/03/12 23:41, Max Vlasov wrote: > > One of the recent thought I had was implementing time machine vfs. So > > on the developer level he opens the db either in

Re: [sqlite] Once again about file change counter

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 05/03/12 23:41, Max Vlasov wrote: > One of the recent thought I had was implementing time machine vfs. So > on the developer level he opens the db either in general mode or > history (read-only) mode providing the date (or version) for working >