Change history for SQLiteSpy

---

2022-12-22 17:14:04
Updated by lwc

• Version: v1.9.156
• System Requirement:
• Release date: 20212-027-086

---

2022-02-22 18:59:01
Updated by Midas

• Release date: 20201-02-08
• What's new: Full changelog at [url]https://yunqa.de/delphi/approducts/sqlitespy/history[/url].

---

2021-02-19 19:15:42
Updated by Midas

• Website URL: https://yunqa.de/delphi/approducts/sqlitespy/index
• Version: v1.9.145
• Download URL: https://yunqa.de/delphi/approducts/sqlitespy/index
• Release date: 2020-02-058
• What's new: SFull changee:log at [url]https://https://yunqa.de/.delphi/delphi/productsts/sqlitesspy/history[/url].

---

2021-01-01 13:23:23
Updated by billon

• System Requirement: Win95 Win98 WinME WinNT

---

2020-12-31 19:02:48
Updated by billon

• Website URL: https://www.yunqa.de/delphi/products/sqlitespy/index
• Version: v1.9.134
• Size (in bytes): 48432710468
• Download URL: https://www.yunqa.de/delphi/products/sqlitespy/index
• Release date: 201920-032-015
• What's new: See:[url]https://www.yunqa.de/delphi/products/sqlitespy/history[/url]

---

2019-03-01 15:09:03
Updated by billon

• Version: v1.9.123
• License: Freeware for or peersonal and educational use.
• Size (in bytes): 48474106084
• Release date: 20189-013-021

---

2018-01-25 17:01:33
Updated by billon

• Synopsis: SQLiteSpy is a fast and compact database manager for SQLite. It reads SQLite 3 files and executes SQL against them with a graphical user interface that makes it very easy to explore, analyze, and manipulate those databases.

---

2018-01-25 15:01:50
Updated by billon

• How to extract: Download the ZIP package and extract to a folder of your choice. Delete [i]World.db3[/i]. Launch [i]SQLiteSpy.exe[/i].

---

2018-01-25 14:59:58
Updated by billon

• Website URL: https://www.yunqa.de/delphi/products/sqlitespy/index
• Version: v1.9.112
• Size (in bytes): 47406013448
• Download URL: https://www.yunqa.de/delphi/products/sqlitespy/index
• Keywords: sqlite%20spy
• Release date: 20168-06-1-02
• What's new: [list][*]Update built-in [url=http://See:[url]https://www..yuunqqa.de/delphi/products/sqlite3/index]DISQLite3[/url] engine to SQLite 3.13.0.[*]Add the JSON extension.Example: [font=monospace]SELECT json_extract('{“a”:2,“c”:[4,5,{“f”:7}]}', '$.c[2].f');[/font][*]Add t.de/delphe Session extensi/pron.Example: [font=monospaducts/sqlite]SELECT * FROM generate_serpy/hies(0,100,5);[/fstont]ry[/urlist]

---

2016-06-10 21:29:08
Updated by billon

• Icon: Updated

---

2016-06-10 21:24:56
Updated by billon

• Version: v1.9.101
• Size (in bytes): 460133356844
• Release date: 20156-086-10
• What's new: [list][*]Update built-in [url=http://www.yunqa.de/delphi/doku.php/products/ts/sqlite3/indexlite3/index]DISSQLitite3[/url] en engine to SQLLite 3.13.0.[*]Add the JSON extensiton.Example: [font=monospace]SELECT json_extract('{“a”:2,“c”:[4,5,{“f”:7}]}', 3.8'$.11c[2].1, if');[/fonclut][*]Adding new Full Text Shearch 5 (FTS5).[*]Fession ex tension.Exabmple bre: [font=monowsingpace]SELECT * if INTEGEFR PRIOMARY KEY column contai gened ^ charracte_series.(0,100,5);[*]Try to detect UTF-8 encoding i/f loading an SQL file without BOM.][/list]

---

2016-04-13 21:44:15
Updated by billon

• Website URL: http://www.zeitungsjyungenqa.de/dede/delphii/products/sqlitespy/index
• System Requirement:
• Download URL: http://www.zeitungsjyungenqa.de/dede/delphii/products/sqlitespy/index
• Screenshot: Updated

---

2015-08-11 20:17:25
Updated by Checker

• Version: v1.9.910
• Size (in bytes): 4477440333568
• Release date: 2015-058-190
• What's new: [list][*]Update built-in [url=http://www.yunqa.de/delphi/doku.php/products/sqlite3/index]DISQLite3[/url] engine to SQLite 3.8.101.1.[*]Add, including new Full Text DBSTAT vieartualch table5 (FTS5).[*]The schema tree flags INFix table browsing if INTEGERER PRIMARYY KEY columns as "semi not null", using a gray check tick. This indicates that these columns do not allcow certntained NULL ^ charactioners (i.[*]Try to dete.ct UPDATE)F-8 encoding if loand raisng an SQL file err withorsut BOM.[/list]

---

2015-05-19 19:21:20
Updated by Checker

• Version: v1.9.89
• Size (in bytes): 415641677440
• Release date: 20000-0015-005-19
• What's new: [list][*]Update built-in [url=http://www.yunqa.de/delphi/doku.php/products/sqlite3/index]DISQLite3[/url] engine to SQLite 3.8.610.1.[*]Attachedd DBSTAT davirtuabase:l Double clicking a table node did not work. Fixedtable.[*]The schema tree flags INew TEGER PRIMARY KEY columns as "sediaMmi not null", usinkeg a gray.dll ext chenck tick. This indioncates wthich adds tat theese columns do not allow certain IUNICODEULL collaction nsequence needed to(i.e. UPDATE) opeand MedraiaMonkey database errors.[/list]

---

2014-08-21 16:32:32
Updated by Checker

• Version: v1.9.78
• Size (in bytes): 4092156416
• What's new: [list][*]Update built-in [url=http://www.yunqa.de/delphi/doku.php/products/sqlite3/index]DISQLite3[/url] engine to SQLite 3.8.46.3.[*]Open database by drag and dropping on the schema treeview.[*]Respect decimal point option when editing floating point numbers.[*]More s[*]Attable scrolling tchrough huge numbers of rows / columns.[*]Fix display of database: Double clicking a table / column names whichnode did represenot SQLwork. Fitexed.[*]New MediaMonkey.dll extension which adds the IUNICODE collation sequence needed to orpen MediaMonkey databases.[/list]

---

2014-04-29 18:00:00
Updated by Checker

• Version: v1.9.67
• Size (in bytes): 398640924416
• What's new: [list][*]Implement the Update built-in [url=htttp://www.yu//www.yunqa.da.de/delphi/doku.php/products/sqlite3/index]DISQLite3[/url] engine to SQLite 3.8.4.3.[*]Open database by drag and dropping on the schema treeview.[*]Respect decimal point option when edelphiting floating point numbers.[*]More stable scrolling through huge numbers of rows /d coklumns.[*]Fix disphplay of table /pr codluctmn names/sql whitch represe3/index]t SQLite[/url] 3.8.0.2 buge fixkeywords.[/list]

---

2013-09-06 16:35:26
Updated by Checker

• Version: v1.9.56
• What's new: [list][*]Implement the [url=http://www.yunqa.de/delphi/doku.php/products/sqlite3/index]SQLite[/url] 3.8.0.12 bug fixes.[/list]

---

2013-08-30 17:33:42
Updated by Checker

• Version: v1.9.45
• Size (in bytes): 37498630944
• What's new: [list][*]Update built-in [url=http://www.yunqa.de/delphi/doku.php/products/sqlite3/index]DISQLite3[/url] engine to SQLite 3.8.0.[*]In table browsing mode, order results by ROWID.[*]Fix error when scrolling a table with many rplesult columns.[*]Sment tay responsive in case of he SQLite 3.8.0.1 bug fixerrors.[/list]

---

2013-08-29 17:15:42
Updated by Checker

• Version: v1.9.34
• Size (in bytes): 36792463204
• What's new: [list][*]Update built-in [url=http://www.yunqa.de/delphi/doku.php/products/sqlite3/index]DISQLite3[/url] engine to pre SQLite 4.2.0.[*]Add SQLite's spellfix virtual table.[*]New file menu items to create, open or attach a database with URI parameters.[*]Improve [ESC] key responsiveness for multiple, small SQL statemenits like 3.8.0.[*]INSERT.[*]Option to specify the data type in cell editor.[*]Handle tables dropped after displayed the grid editor.[*]Auto-calculate column widths from the record texts of initially displayed records.[*][Ctrl+PgUp/PgDn] navigate between n table browsing mode, order resultts tabsy ROWID.[*][ShFift+F10] x erropensr twhen scrolling a tablext menu win the schmany result columa ns.[*]Stay reesponsive in case of SQLite ewrrors.[/list]

---

2013-05-05 21:16:20
Updated by webfork

• Synopsis: SQLiteSpy is a fast and compact GUI daataabase manager for SQLitase manager for SQLite. Itt reeads SQLite 3 files and executes SQLite 3 files and executes SQL against them. It against them with a graphical user inteal user interfaace e that makes it very easery toeasy to explore, analyze ane, and manipulatte SQLithose databases.
• Screenshot: Updated
• Forum topic ID: 01334

---

2013-04-11 21:45:36
Updated by Checker

• Version: v1.9.13
• System Requirement:
• Size (in bytes): 367922661132
• What's new: [list] [*]Update built-in DISQLite3 e[*]Update built-in [url=http://www.yunqa.de/delphi/doku.php/products/sqlite3/index]DISQLite3[/url] engine to pre SQLite 4.2.0.[*]Add SQLite's spellfix virtual table.[*]New file menu items to create, open or attach a database with URI parameters.[*]Improve [ESC] key responsiveness for multiple, small SQL statements like INSERT.[*]Option to specify the data type in cell editor.[*]Hangdle tables dropped after dinesplayed the grid to pre SQLdite 3.7.8or.[*]Add YuSuto-calculatemmer colanguage stemming widto the FTS4 unicode tokenizer.[*]Addhs from the fuzzer ane record whotexts of initially displayed renumbecor ds.[*][Ctrl+PgUp/PgDn] navirgate between resualt tables.[*]I[Shif a database filt+F10] opens the can notntext menu in bthe opened, fall basck to the :meemory:a databasreeview.[/list]

---

2013-02-12 00:49:05
Updated by Andrew Lee

• How to extract: Download the ZIP package and extract to a folder of your choice. Delete [i]World.db3. L[/i]. Launch [i]SQLiteeSpy.exe[/i].
• What's new: [list] [*]Updatete builtt-iin DISQLite3 enDISQLite3 engine to pre to pre SQLite 3.7.8. Add .[*]Add YuStemmetemmer laanguage stemmming to to the FTS4 uninicode tokenizer. [*]Add the fuzzer and wholenumber holenumber virtual tabales. If a dattabalese .[*]Ifil a database canfile can not be e opened, fall bl back to t to the :mememory: daatabase.[/list]

---

2011-07-28 20:15:51
Updated by Checker

• Version: Vv1.9.01
• Size (in bytes): 21299661120
• What's new: SupUport for date built-in DISQLite3 engine to pre SQLite 3.7.8. Add YuStemmer language stemming to the FTS4 unicode tokenizer. Add the fuzzer andable extwholensumber vionrtual tables. If a database file can not be ompilened, with "fastcall" (C++ Builder) or "register" (Delphi) bacalling conventik tons. Update built-in DB engine to pre SQLite 3.7.6 (DISQLithe3 2.3.4). On database close, open an in-memory :memory: daataabase (:memory:).

---

2011-03-02 23:33:35
Updated by Checker

• License: Freeware for personal and educational use.
• System Requirement: Win7
• What's new: Support for loadable extensions compiled withpiled with "fastcalll" (C++ Builde++ Builder) or r "reegister" (DelpDelphi) calliling conventionventions. Update built-in DB e engiine toe to pre SQLite 3.e SQLite 3.7.6 (DISQLite33 2..3.4). On database close, open an in-memory database (:memory:).

---

2011-03-02 18:15:18
Updated by Checker

• Version: V1.89.160
• Size (in bytes): 212992065408
• What's new: Update built-in DB engine to SQLite 3.7.2 (DISQLite3 2.3.1). Print some sqlite3_stmt_status() uperformance counters to the status bar. Faster porocessingt ofor loargdable e SQL scripxtens. Fix table mode browsing (double clicking on a table oname) for tables which use some of the INTEGER PRIMARY KEY aliases as compilumn named with "fas. Output a wcarningll" if the table can not be browsed beca(C++ Buse alilder) or th"ree namegis (ROWID, OID, oter" _ROWI(D_elphi) carlling conve ntion use. by the tUpdate built-in DB engine to pre. This souldSQLite 3.7.6 (DISQLite3 2.3.4). On databe very rarse close, ope,n howevan in-memory database (:memory:).

---

2010-08-31 18:32:12
Updated by Checker

• Version: V1.8.156
• Size (in bytes): 2063540872
• What's new: Update built-in DB engine to SQLite 3.7.0.1 (2 (DISQLite3 2.SQLite3 2.3.0.1).. Print some sqlite3_stmt_status() Tperformance counters to thie status bar. Faster processing of large fiSQL scripts. Fix table mode browsing (double clicking on a table name) for tables which use some of the INTEGER PRIMARY KEY aliases as column names. Output a warning if the table can not be browsed because all three names (ROWID, OID, or _ROWID_) ares ain use by potentialhe database corruption problem that can rlesult . Thif thes same ouldata base file is alternatelye wveritteny by SQLite version 3.7.0 and SQLite 3.6.23.1 or earlirer. Upgrading is hig, hly recommwevendedr.

---

2010-08-05 16:21:34
Updated by Checker

• Version: V1.8.145
• Size (in bytes): 2063360872
• What's new: Update built-in DB engine to SQLite 3.7.0.1 (DISQLite3 22.3.0.1). This fixes a potential database corruption problem that can result if the same database file is alternately written by SQLite version 3.7.0 and SQLite 3.6.23.1 or earlier. Upgrading is highly recommended.3.0)

---

2010-07-28 19:19:55
Updated by Checker

• Version: V1.8.134
• Size (in bytes): 22069693360
• What's new: Update built-in DB engine to SQLite 3.67.230 (DISQLite3 2.22.3.20)

---

2010-04-15 11:26:54
Updated by admin

• Version: V1.8.123
• Size (in bytes): 2015744269696
• What's new: Update built-in DB engine to SQLite 3.6.223 (DISQLite3 2.2.0.2)

---

2010-02-25 18:37:39
Updated by admin

• Version: V1.8.112
• Size (in bytes): 200000015744
• What's new: Update built-in DB engine to SQLite 3.6.212 (DISQLite3 2.1.2.2.0)

---

2009-12-08 19:09:19
Updated by admin

• Categories: [Others - Database Tools]
• Version: V1.8.101
• What's new: Update built-in DB engine to SQLite 3.6.21 (DISQLite3 2.1.2)

---

2009-11-13 18:01:56
Updated by admin

• Version: V1.8.510
• System Requirement:
• Suggested by: MarcoNovaro

---

2007-02-21 03:59:37
Added by admin