SQLite Database Browser - New Version!

[Intrigued]

For those that remember when I first suggested this application, SQLite Database Browser back a ways... well now there is a (major updates) new version out! (Version 1.1)

Notes

Release Name: 1.1

Notes:
Version 1.1 includes many enhancements to the original SQLiteBrowser. All code was contributed by Mauricio Piacentini and the icons were contributed by Raquel Ravanini.

--------------------------------------------------------------------------------
Changes:
Major update! The following features were added:

- SQL query window: enter SQL commands and see the output and error codes directly in a browser view.
- SQL log: lists all SQL commands issued by the browser application and/or by the user. Useful as a tool to analyze and learn SQL.
- Abitility to open database files specified with a command line parameter (sqlitebrowser mydb) and/or drag and drop.
- Added experimental modify table wizard, since SQLite does not support the ALTER TABLE SQL command. Use it with care. Works correctly for all tables originally created in SQLiteBrowser.- The browser uses a transaction to make it possible to undo changes made to a database before they are commited to disk. All changes are now temporary until the user decides to SAVE the file.
- Added CSV import/export capabilities: a wizard makes it possible to configure table importing from a CSV file (delimiters, etc.) Supports most CSV format variations, including files generated by MS Excel and Access.
- Added SQL dump import/export capabities. Useful to store an SQL format backup of your database, or to interchange data with MySQL or Oracle, for example.
- Added text import/export capabilities directly to db records.
- Modified record browsing interface. The spreadsheet interface now redraws faster (and clips longer records.) Double click a cell to edit the record on a separate window. This allows better support for longer records including line breaks, for example.

and many other small enhancements and bug fixes.

(Source: http://sourceforge.net/project/shown...ease_id=254534)

Here is the link:

SQLite Database Browser - Click Here to Download!

[csd214]

The SDB v.1.1 has a nice feature to a newbie like me: The View, SQL Log.

Example: If you modify a record (with SDB), you can look into the SQL Log to learn the proper SQL syntax.

[Intrigued]

I am the same "newbie", and appreciate that ability too! (grin)

Another aspect of the program I really appreciate is that now I can just double click (I have the program associate to '.db' files) on a .db file and it will open in SDB, now just like other program files!

[csd214]

now I can just double click

Sounds nice, but WinXP became angry:

Caution
You are attempting to open a file of type 'Data Base File' (.db)

These files are used by the operating system and by various programs. Editing or modifying them could damage your system.

If you still want to open the file, click Open With, otherwise, click Cancel.

Maybe I am a coward, but I chose ‘Cancel’.

[azmanar]

For those that remember when I first suggested this application, SQLite Database Browser back a ways... well now there is a (major updates) new version out! (Version 1.1)

(Source: http://sourceforge.net/project/shown...ease_id=254534)

Here is the link:

SQLite Database Browser - Click Here to Download!

Hi,

Version 1.1 is no longer available for download. Version 1.2.1 supports only SQLite 3.0 above. It does not support the Sqlite 2.8 being used in AM6.

Anyone who needs a DB Manager Software which directly reads through and manipulate SQLite DB files ( for example >> something.db ), I found a good FREEWARE at : http://www.dbtools.com.br/EN/downloa....php?file_id=8 .

Hopefully this info is useful.

[Intrigued]

I have it archived on my www.amsuser.com FTP server:

http://http://www.amsuser.com/misc/s...er-1.1-win.zip

[Beningram]

And for noobs like me too

http://www.amsuser.com/misc/SQLite_D...er-1.1-win.zip

(only 1 http:// so the link will work)

Will check this out...thanks for the post!

[Intrigued]

Sorry about that, I usually delete the "http://" that PHP auto-codes into the URL maker deal-e-o. Seems my attempt was thwarted. ARG!

;-)

[k1ngk1ng]

Thanks,That's very nice

[likbez]

it looks like a great tool, but it can't import CSV files as declared. We saved a table from MS Excel to file.csv and it doesn't show any record in the importing wizard. It looks like it doesn't like the fields containing both text and figures as in our case. How to get it sort out?