[sqlite] Sqlite Root also available for Linux

Announcement of the release Sqlite Root now available for Linux. Any feedback is appreciated. -- Fabio Spadaro Try Sqlite Root a GUI Admin Tools for manage Sqlite Database: www.sqliteroot.com ___ sqlite-users mailing list

[sqlite] Tuning a SQLite database for best compression

Hi, I'm developing a mobile application which downloads my database so smallest possible database size (i.e. on-disk/footprint) is important. Currently my database is 41.5MB with indexes and to reduce the download I'm zipping it with max. compression Deflate down to 18.4MB. I noticed I can get

[sqlite] Recommended latest SQLITE version for upgrade

Hi SQLite Users, >From your experiences, appreciate any recommendation on what could be the right latest stable version of SQLITE to upgrade to, from one of the oldest (about 5 years) versions. Many thanks in advance. Regards, Karthik Theerthagiri Exchange Connectivity SG +65 6212

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

On 5 Mar 2012, at 10:59am, Larry Knibb wrote: > I'm developing a mobile application which downloads my database so smallest > possible database size (i.e. on-disk/footprint) is important. > > Currently my database is 41.5MB with indexes and to reduce the download I'm >

Re: [sqlite] SELECT COUNT (DISTINCT column_name FROM table)

The crash is a result of -O3 flag used during compiling the library. -Sreekumar On Sat, Mar 3, 2012 at 2:00 PM, Sreekumar TP wrote: > Its does not crash on x86. I havent built the shell for my mips device. > > Sreekumar > On Mar 3, 2012 10:26 AM, "Dan Kennedy"

Re: [sqlite] Recommended latest SQLITE version for upgrade

On 5 Mar 2012, at 11:52am, "Theerthagiri, Karthik" wrote: > From your experiences, appreciate any recommendation on what could be > the right latest stable version of SQLITE to upgrade to, from one of the > oldest (about 5 years) versions. At any time,

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

Thanks for the quick reply, Simon. I was rather hoping there might be some efficiency tweaks I can do to the db file (e.g. more explicit creation statements, or postprocessing) instead of getting into custom sqlite builds. I was on the bus when I wrote my earlier mail but at home now I've tried

Re: [sqlite] SELECT COUNT (DISTINCT column_name FROM table)

On Mon, Mar 5, 2012 at 7:04 AM, Sreekumar TP wrote: > The crash is a result of -O3 flag used during compiling the library. > A compiler bug, then. OK. Good to know. SQLite has previously uncovered bugs in GCC, MSVC, and LLVM. Which compiler are you using? > >

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

The database went up by 1MB on disk but I saved over 1MB on the zip file by dropping the page_size down from 1024 to 512. That's a slight improvement. Earlier when I said the footprint was the issue, I really meant the download footprint. LZMA is also 500KB smaller @ 11.6MB (why oh why isn't

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

On 5 Mar 2012, at 12:16pm, Larry Knibb wrote: > Thanks for the quick reply, Simon. I was rather hoping there might be > some efficiency tweaks I can do to the db file (e.g. more explicit > creation statements, or postprocessing) instead of getting into custom > sqlite

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

I don't know whether this is practical in your application, but if you want to reduce redundancy in the database file when downloading, the obvious thing is to leave off the indexes, and generate them once the file is downloaded onto the device. This way you'll have to download only the actual

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

> SQLite is about equally space-efficient for pretty-much everything you do. Yeah, I figured it probably would be. I'm generating my database in one shot off-device at the moment and it's all sequential, so there's no chance of anything being out of order. Even the vacuum only cleaned up 250KB

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

Thanks Mario. I did think about stripping the indexes to cut down the size. Recreating them on-device wouldn't be difficult (just time-consuming) but offset against the smaller download it's possibly worth it... although if I'm into partial on-device db creation then I should really do some timing

[sqlite] What do people think of SQLite Root?

Our company typically uses SQLite Spy for managing SQLite databases. I keep hoping to find something better, because SQLite Spy does not offer the ability to edit a table inside a grid. The only way to update data is to use an SQL UPDATE statement. But nothing else offers the speed of

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

On 5 mars 2012, at 14:50, Rob Richardson wrote: Our company typically uses SQLite Spy for managing SQLite databases. I keep hoping to find something better, because SQLite Spy does not offer the ability to edit a table inside a grid. The only way to update data is to use an SQL UPDATE

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

On 05.03.2012 14:50, Rob Richardson wrote: > I keep hoping to find something better, because SQLiteSpy does not > offer the ability to edit a table inside a grid. Not quite true. SQLiteSpy can edit table cells inside a grid. Double-click the table-icon in the schema treeview to display the

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

Hi. Il giorno 05 marzo 2012 14:50, Rob Richardson ha scritto: > ... I keep hoping to find something better, because SQLite Spy does not > offer the ability to edit a table inside a grid ... > RobR > With sqlite root is possbile to edit the table inside a grid and

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

On 3/5/12, Fabio Spadaro wrote: > Hi. > Il giorno 05 marzo 2012 14:50, Rob Richardson ha > scritto: > >> ... I keep hoping to find something better, because SQLite Spy does not >> offer the ability to edit a table inside a grid ... >> RobR >> >

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

With the latest version, I think you can. But I haven't been able to get the latest version. The link you provided does not work for me. Do you know any site other than yunqa.de where the latest SQLite can be downloaded? RobR -Original Message- From: sqlite-users-boun...@sqlite.org

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

On 05.03.2012 16:11, Rob Richardson wrote: > With the latest version, I think you can. SQLiteSpy grid editing has been around for years, it is available since version 1.6.0., 7 Feb 2007. > But I haven't been able to get the latest version. The link you > provided does not work for me. Do you

Re: [sqlite] DISTINCT bug with 3.7.10

Fri, 02 Mar 2012 19:00:30, Roger Binns wrote: > On 02/03/12 15:20, Steven Russell wrote: >> I obviously don't expect the duplicate results here. If you create the >> table without the UNIQUE clause, then the results are as expected (1 >> and 2 both only show up once). > > BTW the team agreed

Re: [sqlite] Elegant printout of table (with header) via TCL

>On 6 Mar 2012, rod wrote: >> On 2/9/12, rod wrote: >> > >> > I'm looking for a better way to printout the: >> > Column Headers, >> > followed by the table contents - >> > in comma separated value (tsv) format >> > from a SELECT statement: >> By setting a trace I am >> able to reset a variable

Re: [sqlite] Status

I think that you can track progress at http://www.sqlite.org/src/timeline?n=20=winrt Best regards, Krystian Bigaj On 2 March 2012 16:37, Steven Nesbit wrote: > Sorry about that, WinRT Sqlite > > Steve > > > ___ > sqlite-users

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

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 05/03/12 02:59, Larry Knibb wrote: > Currently my database is 41.5MB with indexes and to reduce the download > I'm zipping it with max. compression Deflate down to 18.4MB. > > I noticed I can get it down to 12.1MB using LZMA compression but >

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

We're running 1.5.5. We don't keep up with updates very well. We're lucky we're not using MS Visual Studio 6 any more. We're up to 2008! Woohoo! I can't get to www.yunqa.de now. I tried in IE8 and FireFox. RobR -Original Message- From: sqlite-users-boun...@sqlite.org

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

Note that importing the .dump file does effectively strip the indices and re-create them. In fact, there's a good chance that if you drop the indices, VACUUM, and then compress the database file, you'll find that it comes close to what you get with the .dump-then-compress values. -scott On

Re: [sqlite] SELECT COUNT (DISTINCT column_name FROM table)

On March 5, Richard Hipp wrote: On Mon, Mar 5, 2012 at 7:04 AM, Sreekumar TP wrote: > The crash is a result of -O3 flag used during compiling the library. > A compiler bug, then. OK. Good to know. SQLite has previously uncovered bugs in GCC, MSVC, and LLVM. Which compiler are you using?

Re: [sqlite] SELECT COUNT (DISTINCT column_name FROM table)

On Mon, Mar 5, 2012 at 1:39 PM, Larry Brasfield wrote: > On March 5, Richard Hipp wrote: > > On Mon, Mar 5, 2012 at 7:04 AM, Sreekumar TP >> wrote: >> >> > The crash is a result of -O3 flag used during compiling the library. >> > >> >> A compiler bug, then. OK. Good

Re: [sqlite] SELECT COUNT (DISTINCT column_name FROM table)

On March 5, Richard Hipp wrote: On Mon, Mar 5, 2012 at 1:39 PM, Larry Brasfield wrote: > On March 5, Richard Hipp wrote: > > On Mon, Mar 5, 2012 at 7:04 AM, Sreekumar TP >> wrote: >> >> > The crash is a result of -O3 flag used during compiling the library. >> > >> >> A compiler bug, then.

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

On 05.03.2012 18:45, Rob Richardson wrote: > I can't get to www.yunqa.de now. I tried in IE8 and FireFox. Most strange. Luckily, search engines find plenty of SQLiteSpy download alternatives. Here is one of the more well known ones:

Re: [sqlite] SELECT COUNT (DISTINCT column_name FROM table)

GNU C (Sourcery CodeBench 2011.03-95) version 4.5.2 (mips-linux-gnu) compiled by GNU C version 4.3.2, GMP version 4.3.2, MPFR version 2.4.2, MPC version 0.8.1 On Mon, Mar 5, 2012 at 6:12 PM, Richard Hipp wrote: > On Mon, Mar 5, 2012 at 7:04 AM, Sreekumar TP

[sqlite] C# SQLiteCommandBuilder how to return AutoIncrement

Hi, I Table def: - CREATE TABLE [vyroba] ( [ID_VYROBA] INTEGER PRIMARY KEY AUTOINCREMENT, [vlozeno] TIMESTAMP DEFAULT (datetime('now','localtime')), [POPIS] TEXT NOT NULL, [prefix_dmc] TEXT NOT NULL, [kistler_prog1] INT NOT NULL, [kislter_prog2] INT, [ID_PLC_PROG]

Re: [sqlite] C# SQLiteCommandBuilder how to return AutoIncrement

Am 06.03.2012 07:34, schrieb Pawl: Hi, I Table def: - CREATE TABLE [vyroba] ( [ID_VYROBA] INTEGER PRIMARY KEY AUTOINCREMENT, [vlozeno] TIMESTAMP DEFAULT (datetime('now','localtime')), [POPIS] TEXT NOT NULL, [prefix_dmc] TEXT NOT NULL, [kistler_prog1] INT NOT NULL,

Re: [sqlite] C# SQLiteCommandBuilder how to return AutoIncrement

Christoph Kukulies wrote: > > Just a guess: I don't see any Commit or surrounding Transaction. > I don't know what do you thing this. Is any problem in definition DDL? Describe problem: After inserting (successful) autoincrement column have still zero value. It is problem for next processing.

[sqlite] Once again about file change counter

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 problem since probably until db format change