인기: 데이터 업데이트: 2026년 11월 21일

카테고리

인터넷1,422
커뮤니케이션329
오디오 및 비디오938
그래픽 및 디자인566
오피스 및 생산성1,185
개발 도구3,290
AI 도구610
보안 및 개인정보408
시스템 도구3,201
게임545
교육 및 과학242
네트워크 및 IT294

SQLite Expert Personal 이전 버전 및 전체 버전

SQLite administration

2026년 8월 16일부터 현재 버전 6.2.16.750까지 SQLite Expert Personal의 2개 버전을 모았습니다. 모든 버전은 제공사의 공식 설치 파일로 연결됩니다.

2026: 2 2 26
버전날짜크기파일
6.2.16.750최신 2026년 11월 17일 — 64비트 EXE (Inno Setup)32비트 EXE (Inno Setup)
릴리스 노트
- Index Advisor on the SQL tab: SQLite’s own advisor suggests indexes that would speed up a query, and shows the resulting plan.
- Query History (SQL menu): every script run on the SQL tab, searchable, and reopened with a double-click.
- One Find window for the current grid (Ctrl+F, SQL results included), a table, or a whole database (Find in the tree). Contains, whole value, starts with or regular expression; match case; whole words; chosen columns. All matches are listed and highlighted; Go to Row opens the row.
- Recent searches are remembered. Esc or Clear Highlight removes the highlighting from a grid.
- Shorter tree and grid menus: related commands are grouped under submenus.
- Imports that create a table have a Column types option: descriptive types without sizes (the new default), STRICT type names, a STRICT table, or the old types with sizes. Floating-point columns are declared REAL.
- Imports store a value longer than its column’s declared size whole, and the text import stores yes/no as 1 or 0.
- The sample database uses SQLite’s type names (TEXT, REAL) without sizes.
- The Record Editor sizes each box to its value; drag the strip under a box to resize it.
- A new row appears in the grid at once, wherever it lands, and the cursor stays on it.
- The Value Inspector opens on a value that does not match its declared type, and the text editor saves such a value as stored.
- A tick box in a nullable column cycles through unchecked, null and checked.
- Ctrl+C while editing a cell on the Design tab copies the selected text, not the row.
- Grid filters offer every condition on TEXT columns (less than, greater than, between, any of and the rest), not only the LIKE family. BLOB columns can be filtered with Is null and Is not null.
- Filters name NULL Is null and Is not null instead of “blank”, and show an empty string as (Empty), so the two no longer look alike.
- A text column’s header filter list has (Empty) and (Not empty) beside (Null) and (Not null). Equals or Does not equal with no value is a condition on the empty string; Is null is the one for NULL.
- Dates in grids are shown, edited and filtered as yyyy-mm-dd, the way they are stored, whatever the Windows date format.
- Fixed: an error on closing a database; a conversion error on arrow keys in yes/no and date cells; a blank row for a column added on the Design tab; Options failing on its second opening, and not reopening where it was closed; a filter on a date column that left every row showing; a row edited out of a filter repeating the last row; a filter on a decimal number on a Windows that uses a decimal comma.
- Fixed in grid filters: a date range (Is between) or list (Is any of) that matched no row; a NULL row kept by Does not equal, Is less than, Is not like or a Not group where the app filters the rows itself (dates, and queries with a WHERE, ORDER BY or LIMIT); a UNION result filtered on its last SELECT only; an error filtering a join on a column both tables have, or an EXPLAIN result.
- The Functions and Collations pages of the Database tab have a Source column: SQLite library, or the loaded extension that registered each one.
- Fixed: an extension loaded with load_extension on the SQL tab missing from the Extensions tab; an extension loaded without an entry point listing no functions or collations; the Database tab's Functions and Collations pages not showing a newly loaded extension, or a collation added by icu_load_collation, until Refresh.
- Fixed: a pause of about a second when selecting another table on the Data tab, with the grid blank for the first half of it.
- Fixed: a row pasted into a table whose trigger changes the new row's key not appearing in the grid, even after Refresh.
- Fixed: in the 32-bit version, an access violation in the grid after using an extension that leaves values on the processor's floating-point stack, such as one built with the Tiny C Compiler (TCC).
5.5.44.660 2026년 8월 16일 — 64비트 EXE (Inno Setup)32비트 EXE (Inno Setup)
릴리스 노트
- Added FastSpring integration.
- Added parser support for latest SQLite features.
- Added support for Windows 64-bit on ARM64 architecture.
- Added on-demand initialization of the printing system.

데이터베이스 인기 1위

전체 보기
  1. MariaDB데이터베이스 · MariaDB Corporation Ab
  2. HeidiSQL데이터베이스 · Ansgar Becker
  3. SQLite데이터베이스 · SQLite
  4. Dolt데이터베이스 · DoltHub
  5. MongoDB데이터베이스 · MongoDB Inc
  6. Redis on Windows데이터베이스 · MSOpenTech
  7. DB Browser for SQLite데이터베이스 · DB Browser for SQLite Team
  8. Beekeeper Studio데이터베이스 · Beekeeper Studio Team
  9. Liquibase데이터베이스 · Liquibase
  10. Another Redis Desktop Manager데이터베이스 · Another

Coral Creek Software의 다른 프로그램

전체 보기

태그

공유