ANN: Sqlite3Explorer.exe version 1.6

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

ANN: Sqlite3Explorer.exe version 1.6

Cariotoglou Mike
I have uploaded v 1.6 of sqlite3Explorer (www.singular.gr/sqlite). It
has some minor
bug fixes and enhancements, plus support for REGEXP operator.
Sqlite3Explorer has had
regular expression support for a long time now, using the (undocumented)
MATCHES() function.
I have now changed this to comply with the REGEXP operator.
Functionality is PERL (PCRE)

Since I have not been answering queries for some time now, because I was
too busy, I will
try to address some of the accumulated issues in this announcement, as
well:

>2. I have a table with signed 32-bit integers. Doing queries with
negative
>values doesn't work. I have to specify the 2's complement value to get
it
>working.

Sqlite3Explorer does not support 64-bit UNSIGNED integers (32-bit is
ok). This is a Delphi
limitation, and not likely to be solved.


>>1. The rowid (implicit column) is not displayed.
of course. you need to add it to the SELECT statement explicitly. If any
other product is
showing you this, they are monkeying with your SQL.


>I Have two databases with identical schema but different data. Open one
>.database, view data in one table. Open the other database, the data
shown
>in the table is for the original database. Edit the data, and Update
>database. The second database is updated with the changed information
if
>the same record exists there; otherwise you get:

---------------------------
sqlite3explorer
---------------------------
resolver: unexpected count of affected records: 0.
---------------------------
OK
---------------------------

This is a feature, not a bug. it allows you to load data, open another
database and
apply changes there. This works as designed. if you do not need this,
simply do not use it.

>Further to these, I've found that viewing of text data in the grid is
>limited to 255 characters. Is it possible to make the default a lot
bigger
>or have a way of "zooming" a field to get the final value.


Not strictly true. If you work in untyped mode, or if you work in typed
mode, but your
columns do NOT contain size information, then, yes, the columns default
to a size of 255.
Version 1.6 changes this to 8192. Also, a workaround for the previous
versions would be to
define your columns properly , such as :

 name varchar (wrong)
 name varchar(1200) (correct)
 
 

Reply | Threaded
Open this post in threaded view
|

Re: ANN: Sqlite3Explorer.exe version 1.6

Hugh Gibson
> I have uploaded v 1.6 of sqlite3Explorer (www.singular.gr/sqlite).

Thanks!

The download page has 16/03/2005 against version 1.6 - should be
16/6/2005.

Hugh
Reply | Threaded
Open this post in threaded view
|

Re: ANN: Sqlite3Explorer.exe version 1.6

Hugh Gibson
In reply to this post by Cariotoglou Mike
Just got a crash when viewing table data using SQLite3Explorer version
1.6:

---------------------------
sqlite3explorer
---------------------------
Access violation at address 00402E29 in module 'sqlite3Explorer.exe'.
Write of address 01357AAE.
---------------------------
OK  
---------------------------

Pressing OK enabled me to scroll the data, but when reaching near the
bottom I got:

---------------------------
sqlite3explorer
---------------------------
RecordIndex out of range.
---------------------------
OK  
---------------------------

Integrity check on the database gave:

---------------------------
sqlite3explorer
---------------------------
Database seems ok
---------------------------
OK  
---------------------------

Scrolling up and down gave more errors, and eventually I had to kill the
app.

The only thing that could affect this is that I had some fields with lots
of data, probably around 100k.

Hugh
Reply | Threaded
Open this post in threaded view
|

RE: ANN: Sqlite3Explorer.exe version 1.6

Cariotoglou Mike
In reply to this post by Cariotoglou Mike
which version of the dll are you using ? do you have REFERENCES
declarations ? can you send me a sample of the data ?

> -----Original Message-----
> From: Hugh Gibson [mailto:[hidden email]]
> Sent: Wednesday, June 22, 2005 4:22 PM
> To: [hidden email]
> Subject: Re: [sqlite] ANN: Sqlite3Explorer.exe version 1.6
>
> Just got a crash when viewing table data using SQLite3Explorer version
> 1.6:
>
> ---------------------------
> sqlite3explorer
> ---------------------------
> Access violation at address 00402E29 in module 'sqlite3Explorer.exe'.
> Write of address 01357AAE.
> ---------------------------
> OK  
> ---------------------------
>
> Pressing OK enabled me to scroll the data, but when reaching
> near the bottom I got:
>
> ---------------------------
> sqlite3explorer
> ---------------------------
> RecordIndex out of range.
> ---------------------------
> OK  
> ---------------------------
>
> Integrity check on the database gave:
>
> ---------------------------
> sqlite3explorer
> ---------------------------
> Database seems ok
> ---------------------------
> OK  
> ---------------------------
>
> Scrolling up and down gave more errors, and eventually I had
> to kill the app.
>
> The only thing that could affect this is that I had some
> fields with lots of data, probably around 100k.
>
> Hugh
>
>
>

Reply | Threaded
Open this post in threaded view
|

RE: ANN: Sqlite3Explorer.exe version 1.6

Hugh Gibson
Mike,

> which version of the dll are you using ?

I was using 3.2.1. I upgraded to 3.2.2 and got:

---------------------------
sqlite3explorer
---------------------------
Access violation at address 00402E29 in module 'sqlite3Explorer.exe'.
Write of address 0133CA7D.
---------------------------
OK  
---------------------------

> do you have REFERENCES declarations ?

No, it's nothing that we use. I'm not even sure what it does! I see it's a
keyword in the SQLite list but a full search for it doesn't show it
anywhere else in the SQLite pages.

> can you send me a sample of the data ?

Well, I can get SQLite3Explorer to crash by creating a new database:

CREATE TABLE t (sValue TEXT);
INSERT INTO T (sValue) VALUES ('HELLO');
// Note: VALUES isn't highlighted as a keyword; VALUE is (bug)
SELECT * FROM T;
INSERT INTO T (sValue) VALUES
('012345678901234567890123456789012345678901234567890123456789012345678901
2345678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123
45678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123
45678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123
45678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123
45678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123
45678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123
45678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123
45678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123
45678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123
45678901234567890123456789');

That's 1000 characters (plus odd CRLF) and is OK when doing another
SELECT, but note that the saved query can't be recalled from history.
Now continue in that way, creating 10,000+ characters in the insert. The
insert runs OK, but you get crashes when selecting the table and doing
Show Data. There are also problems when you close the program.

At one point I got problems in the query editor creating a big query. I
wasn't able to repeat that, with a query up to 1 MB big.

Hugh
 

> > -----Original Message-----
> > From: Hugh Gibson [mailto:[hidden email]]
> > Sent: Wednesday, June 22, 2005 4:22 PM
> > To: [hidden email]
> > Subject: Re: [sqlite] ANN: Sqlite3Explorer.exe version 1.6
> >
> > Just got a crash when viewing table data using SQLite3Explorer version
> > 1.6:
> >  <snip>
> > The only thing that could affect this is that I had some
> > fields with lots of data, probably around 100k.