Announcement of the release Sqlite Root http://www.sqliteroot.com/ 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
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
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
On 5 Mar 2012, at 10:59am, Larry Knibb larry.kn...@gmail.com 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
zipping
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 sreekumar...@gmail.com 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
On 5 Mar 2012, at 11:52am, Theerthagiri, Karthik
karthik.theerthag...@credit-suisse.com 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, the
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
On Mon, Mar 5, 2012 at 7:04 AM, Sreekumar TP sreekumar...@gmail.com 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?
-Sreekumar
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
On 5 Mar 2012, at 12:16pm, Larry Knibb larry.kn...@gmail.com 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 builds.
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
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 out
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
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
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
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 table.
Hi.
Il giorno 05 marzo 2012 14:50, Rob Richardson rdrichard...@rad-con.com 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 foreign
On 3/5/12, Fabio Spadaro fabiolinos...@gmail.com wrote:
Hi.
Il giorno 05 marzo 2012 14:50, Rob Richardson rdrichard...@rad-con.com 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
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
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 know
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 it was a
On 6 Mar 2012, rod wrote:
On 2/9/12, rod crimson.blue.2 at gmail.com 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
I think that you can track progress at
http://www.sqlite.org/src/timeline?n=20r=winrt
Best regards,
Krystian Bigaj
On 2 March 2012 16:37, Steven Nesbit snes...@portaltech.com wrote:
Sorry about that, WinRT Sqlite
Steve
___
sqlite-users mailing
-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
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
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
On March 5, Richard Hipp wrote:
On Mon, Mar 5, 2012 at 7:04 AM, Sreekumar TP sreekumar.tp at gmail.com 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
On Mon, Mar 5, 2012 at 1:39 PM, Larry Brasfield
larry_brasfi...@iinet.comwrote:
On March 5, Richard Hipp wrote:
On Mon, Mar 5, 2012 at 7:04 AM, Sreekumar TP sreekumar.tp at gmail.com
wrote:
The crash is a result of -O3 flag used during compiling the library.
A compiler bug, then. OK.
On March 5, Richard Hipp wrote:
On Mon, Mar 5, 2012 at 1:39 PM, Larry Brasfield
larry_brasfield at iinet.comwrote:
On March 5, Richard Hipp wrote:
On Mon, Mar 5, 2012 at 7:04 AM, Sreekumar TP sreekumar.tp at gmail.com
wrote:
The crash is a result of -O3 flag used during compiling the
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:
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 d...@sqlite.org wrote:
On Mon, Mar 5, 2012 at 7:04 AM, Sreekumar TP
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]
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,
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.
--
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
35 matches
Mail list logo