![]() ![]() Includes GUI for constraints.Understand the layout of the DB Browser for SQLite and the key facilities that it provides Click "Action" button under entity list, choose "Alter", then add column. Drops and creates table, but doesn't bring triggers. Right click table, choose "Alter", "Add Column" No, but can set text to show (default 'NULL') Shows as grey and has "Set Null" context menu. Yes, pink (adjustable) cell color for nulls. No in column mode, NULL appears same as 'NULL' literal text. No, but does have "Set to null" command in cell entry. Can autocommit or begin/end transaction via buttons. Can use auto commit or manual commit.Ĭhanges not marked. Incorrectly updates whole row instead of just changes. Yes, optional connection type for commit/rollback. Yes, but only works if the view contains a "rowid" key column. Generate saved "Report" in HTML or other text based format.Įntry in views (with "instead of" triggers) ![]() Set the long text threshold in Preferences. Yes, via expand button next to cell in line mode. Form view text cells are large, or click "Text" button. Yes, via right click on cell, choose "Edit Value" Select cell in column mode appears in own text entry field Selected cell shown in large field in line mode ("Record Editor") Yes "Form view", initiated from hilighted row in column mode, but can't move to another record in form mode. Yes, for tables not views, as panel over column view without next/previous. Click "Info" button to show in pane over columns. Yes, click pencil button to show "Record Editor". Edits direct in cell if numeric, opens text in cell mode when double clicked. No, but can select column in entity browser, pop up menu select "Geometries" Yes, key icon in header, tooltip shows column info. No, but can see column names and types in Info for table/view ![]() No, not in column view, but entity browser can be expanded to show columns of a table, which includes type and PK. Yes, can also "send to SQL" to make select query. Click "Filter Wizard" button, then File -> Apply Filter. Can also drag cell from result set to filter, hold option to filter out, or drag to table browser to search another table. Fails for column names that should be quoted. Or click on "Set multiple sort" button to show dialog. Click header to sort ascending/descending Click on first sort column, control click on second. Or click "Sort Query Results" button to sort via popup menus. Yes, click on "Limit columns" button, or right click on column to choose "Hide column" from context menu. Yes, via pop up menu on right of column headers Yes, if preferences set to "Always add Horizontal Scroll" and "Columns can't be smaller than 80 pixel" Yes manually or via "Set to natural widths" button. Free 21 eval version on automated request, allows data entry.ġ5 minute sessions. Limited print.Ģ0 launches, with the ability to extend the trial period.ģ0? day eval period, thereafter can't launch.įree version doesn't allow editing of data, but doesn't explain that. Disabled export, import, report generator, dump database. Also available for MySQL, Oracle, PostgreSQLĬan open database file on AppleShare volume US$99 or $69 non-commercial, for the SQLite only versionġ.0.0 beta 060509_2330 (1.0.1 according to, but devloper website has disappeared) ![]()
0 Comments
Leave a Reply. |