Repository navigation
Highlights
- Pythia is now DbCraft (#493). The program is
dbcraft, the repository ortic/dbcraft and the website ortic.github.io/dbcraft. On first start DbCraft takes over Pythia's settings, connections, workspace, history and saved passwords. The installers can't replace Pythia: DbCraft installs next to it, and Pythia is uninstalled by hand. - Table copies that make the table as it is: on PostgreSQL row level security (#373), column collations (#375), inheritance (#376), partitions (#470, #488), foreign tables (#409), rules and column storage (#378), comments on indexes and constraints (#379); on SQL Server descriptions (#410, #472), user-defined types with their schema (#372), ledger tables (#381) and renamed objects (#450); on Oracle virtual, invisible and identity columns (#458, #459), NVARCHAR2 and NCHAR (#460), collations (#484), VECTOR dimensions (#486) and every kind of index (#466, #467).
- Result editing that never touches the wrong row: a MySQL
#comment no longer deletes the wrong rows (#390), floating-point columns aren't keys (#417), comma joins (#449) andOUTER APPLY/PIVOTresults (#416) stay read-only, SQLite rows are checked beside their rowid (#465), MySQL TIMESTAMP keys are matched by their instant (#474). - Read-only and production connections guard every change (#455, #464), and changes that were committed at once wait for Commit: MySQL's
WITH … UPDATE/DELETE(#453), SQL Server batches that start with a SELECT (#454). - Text in any encoding: UTF-16 scripts (#394), CSV files in Windows-1252 and UTF-16 (#446), SQLite text that isn't UTF-8 (#413), PostgreSQL's
client_encoding(#451) and SQL_ASCII databases (#487), SQL Server's invalid UTF-16 (#371), Oracle's national types throughunistr(#480). - Windows: DirectX 12 before Vulkan (#491): with Intel's Vulkan driver the whole window flickered now and then.
- About 120 more fixes across scripts, DDL, forms, imports and exports on every database.
Changed
- Pythia is now DbCraft (#493): the program is
dbcraft, its app idcom.ortic.dbcraft, the repository ortic/dbcraft and the website ortic.github.io/dbcraft. On first start, settings, connections, the workspace, history and recovered editors move over from Pythia's folders (copied, when Pythia still holds them), and saved passwords, SSH secrets and AI keys move over from Pythia's keychain entries when first used. The installers can't replace Pythia: DbCraft installs next to it, and Pythia is uninstalled by hand.PYTHIA_WAYLANDstill keeps Wayland under WSLg; its new name isDBCRAFT_WAYLAND.
Fixed
The list below names each fix in a line; CHANGELOG.md says what each one did and does.
Result grid and result editing
- MySQL: Edit on a query whose select list ends with a
#comment deleted the wrong rows (#390); a floating-point key matched its neighbours' rows (#417). - Results stay read-only where a value would go to another table: comma joins with
ASor keyword aliases orWITH (NOLOCK)(#449), SQL Server'sOUTER APPLY,PIVOTandUNPIVOT(#416). - SQLite: rows of a table without a primary key are checked beside their rowid, which VACUUM renumbers (#465); a text with a NUL character can be changed (#425); a column typed from its first rows is typed again for later blobs (#482).
- MySQL: a TIMESTAMP key finds its row by its instant in the hour that repeats (#474); a
VECTORshows as hex and rows with one can be changed (#436); Edit works on temporary tables, on SQL Server too (#388). - Computed, generated and rowversion columns stay read-only and are left out of INSERT statements, which say when an identity takes the values (#457).
- A binary value held cut short is read-only in the value editor (#392); a new row's cell set to NULL is inserted as NULL (#405); the calendar keeps a date without a time so (#428).
- The grid's filter finds NULLs and binary values as the cells show them (#478); a chart's tooltip shows values below 0.0001 with their exponent (#439).
- Oracle: Follow foreign keys keeps a key's columns together across schemas (#401) and opens rows over a DATE or TIMESTAMP key (#426).
Values and types
- SQL Server:
moneyandsmallmoneyshow every digit (#186); anumericof scale 0 shows as123(#389);nvarcharthat isn't valid UTF-16 reads with U+FFFD (#371). - PostgreSQL:
moneysorts and adds up by its amount (#407); dates are ISO whatever DateStyle says (#475);client_encodingstays UTF8 (#451); SQL_ASCII text says how to read it (#487). - Oracle: JSON keeps Oracle's dates, timestamps, intervals and binary values as extended objects (#370); a TIMESTAMP WITH TIME ZONE in the repeated hour keeps its abbreviation (#481); national types past ASCII are written as
unistr('…')(#480). - SQLite: text that isn't UTF-8 shows as Windows-1252 (#413); tables with another application's collation can be read (#476).
Table and object DDL
- PostgreSQL: row level security (#373), column collations (#375), inheritance (#376), rules, replica identity and column storage (#378), comments on indexes and constraints (#379), foreign tables (#409), partitions (#470), a partition as a partition of its table (#488), a trigger's enabled state (#415), and a table's and a function's grants of one name apart (#429).
- PostgreSQL and SQL Server: a foreign key on the table's own unique index comes after the index (#396).
- SQL Server: user-defined types with their schema (#372), ledger history tables (#381), table descriptions (#410) and those of views, routines and triggers (#472), a trigger's first or last place (#440), renamed or moved objects (#450), a numeric sequence's precision (#461).
- MySQL and MariaDB: a default with a string as SHOW CREATE TABLE writes it (#387), a trigger's
PRECEDES(#421), a trigger's or routine'ssql_mode(#422) and collation (#452). - Oracle: table copies and Schema Compare make virtual and invisible columns (#458), keep
DEFAULT ON NULLandGENERATED ALWAYS(#459), NVARCHAR2 and NCHAR withoutCHAR(#460), column collations (#484), VECTOR dimensions (#486) and index kinds (#467); the index form keeps an index's attributes when it makes it again (#466).
SQL window and scripts
- Oracle:
WITH FUNCTION … SELECTruns as one statement (#358);&1is substituted in code too (#435). - PostgreSQL and SQL Server: block comments nest (#391); PostgreSQL dollar quotes with letters past ASCII (#468) and array slices that aren't binds (#398).
- MySQL:
NO_BACKSLASH_ESCAPESis read in windows (#412); events with aDO BEGIN … ENDbody and MariaDB's aggregate functions are one statement (#432); Explain plan with binds says it takes none (#400); binds aren't put into strings with\', on PostgreSQL too (#399). - SQLite: a trigger with columns named
beginorendis one statement (#433); SQL Server:END CONVERSATIONdoesn't end a block (#448). - A
--comment at the end of a filter, WHEN or expression no longer comments out what follows (#404); a filter that is all comment is none (#427). - PL/SQL snippets in Oracle's windows only (#469); Find/Replace In selection reads the text around it and follows it (#418); the formatter no longer renames names (#419).
Transactions and connections
- Changes that were committed at once wait for Commit: MySQL
WITH … UPDATE/DELETE(#453), SQL Server batches starting with SELECT, PRINT or USE (#454). - Read-only connections refuse, and production connections confirm, statements that look like queries but change (#455), and every other change in forms, the browser, Import, Maintenance and the monitor (#464).
- PostgreSQL: Commit of a failed transaction says nothing was committed (#423); a statement that took the transaction with it says the changes are undone (#431).
- A window whose session couldn't connect answers its next statement (#424); SQL Server lookups chosen as deadlock victims run again (#473).
- PostgreSQL connect strings are read as libpq reads them (#393); SQL Server's ADO.NET strings with non-ASCII characters connect (#414);
user:password@in a MySQL or SQL Server address is refused (#406). - SQLite: in-memory databases wait for locks (#374), and a window with rows to fetch doesn't keep another from committing (#185).
Names and forms
- Oracle: the program window finds quoted subprograms (#359); forms keep a name's case (#365); DESCRIBE, Compare data and Import take quoted names (#369); names are folded to uppercase as Oracle does (#380).
- Oracle: forms that drop and create an object say so when the create fails, and Apply creates it (#395); the table builder refuses a foreign key on a new temporary table before anything runs (#489).
- PostgreSQL: Edit of a constraint trigger (#397) and of a trigger whose name is on several tables (#377).
- MySQL and MariaDB user and role forms: passwords with
\(#402),DELETE HISTORY(#403), Edit of triggers withIF NOT EXISTS(#420), a default role's admin option (#462), other login methods kept (#463), a role's server privileges (#445).
Files, exports and imports
- UTF-16 scripts open and save as UTF-16 (#394); Import reads CSV files in Windows-1252 and UTF-16 (#446) and takes values as they are into text columns (#456).
- A file changed on disk while DbCraft was closed is read again (#411); the workspace is saved with non-UTF-8 file names (#430); DbCraft starts while a file's share doesn't answer (#479).
- Export: a
.in a name is%2Ein its file's name (#408); Excel's limits say which row and column (#434); Oracle exports and data compare read invisible columns (#444) and leave out virtual ones (#443). - Generate INSERT and UPDATE leave generated (#471) and identity columns (#490) out where the database refuses them.
Browser, completion, search and monitor
- Search data with Exact gives each column a literal of its type (#363), BINARY_DOUBLE and BINARY_FLOAT as since #339; Find in Source finds text past 4000 bytes of a view (#437) and searches text as typed (#438).
- Columns tabs: generated columns (#471), Oracle identities (#485), MySQL
auto_increment,on updateand SRID (#483); MySQL Constraints name a referenced table's database (#477); SQLite triggers show their event (#386). - MySQL completion offers only a table's own columns where names differ in case (#447); SQL Server's dropped ledger tables aren't listed (#382).
- Maintenance: MySQL figures are current (#441); PostgreSQL partitioned tables show their partitions' facts (#442).
Windows
- DirectX 12 before Vulkan (#491).
Full Changelog: v0.11.0...v0.12.0