DB Browser for SQLite (SQLite Browser)

Versione: 
3.13.0
Data rilascio: 
Martedì, 5 Giugno, 2012
Home: 
https://sqlitebrowser.org/

Categorie:

Licenza:

  • LGPL

Interfaccia:

  • PMShell
  • Workplace Shell

Authors/Port authors:

Netlabs

Port per OS/2 ed eCS di SQLite Browser. Si tratta di uno strumento open-source per la creazione e l'editing di database compatibili con SQLite. Il programma è stato realizzato utilizzando il QT Toolkit. Port di differenti autori.

Il programma è ad uso di utenti e sviluppatori che vogliono creare database, gestire ricerche ed editare dati. Utilizza l' interfaccia familiare tipica dei fogli di calcolo e non richiede l'apprendimento di complicati comandi SQL.

Sono disponibili controlli e procedure automatizzate che consentono:

  • Creazione e compattazione di file di database
  • Creazione, definizione modifica e cancellazione di tabelle
  • Creazione, definizione e cancellazione di indici
  • Funzioni per la navigazione interna del database, editazione, aggiunta e cancellazione di dati
  • Ricerca dati
  • Importazione ed esportazione di dati come testo
  • Importazione ed esportazione di tabelle da/verso file CSV
  • Importazione ed esportazione di database da/verso file dump SQL
  • Creazione e verifica del funzionamento delle query SQL
  • Esame di un log di tutti i comandi SQL inerenti l'applicazione

Il programma non è una shell visuale per gli strumenti a linea di comando di sqlite e non richiede familiarità con i comandi SQL. E' uno strumento che possono usare sia gli utenti comuni che gli sviluppatori e pertanto deve restare quanto più semplice possibile per poter soddisfare tali requisiti.

Questo software è distribuito con due modalità:
  • come pacchetto compresso, da scaricare e installare manualmente; se ci sono prerequisiti da soddisfare, andranno anch'essi scaricati e installati manualmente;
  • come pacchetto RPM, installabile tramite il gestore pacchetti rpm preferito, che provvederà a scaricare e installare sia il software che gli eventuali prerequisiti.
Scegli la modalità di installazione che preferisci, tenendo conto del fatto che non tutte le versioni del software sono disponibili per entrambe le modalità.

Installazione con rpm

Questo programma si può installare usando il gestore pacchetti rpm. Vedi sotto per la stringa di installazione. I prerequisiti richiesti sono gestiti dal gestore pacchetti e, se necessario, scaricati e installati automaticamente.

sqlitebrowser-3.13.0-2.oc00 (07/08/2023)
Repository: Netlabs stable
# CHANGELOG for DB4S All notable changes to the **Database Browser for SQLite** - DB4S - project are documented in this file. The format is based on [Keep a Changelog](https://keepachangelog.com/en/1.1.0/), and this project adheres to [Semantic Versioning](https://semver.org/spec/v2.0.0.html). ## [Unreleased - nightly] - soon to be [3.13.0] - 2024-07-xx We are proud to announce DB4S 3.13.0 - a very large update over the previous 3.12.2 version released in 2021. It incorporates literally hundreds of enhancements and bug fixes. The list below highlights the major changes. See the [commit history](https://github.com/sqlitebrowser/sqlitebrowser/commits/master/) for fine-grained details. ### Added - **General** - Update to SQLite version 3.46.0 - Integration with [dbhub.io](https://dbhub.io) - macOS ARM version - Sign Windows builds with [SignPath.io](https://SignPath.io) - **Appearance and GUI Enhancements** - Add .NET DateTime.Ticks to date display format - Add a refresh button to the Database Structure tab - Add an extra tab for editing check constraints to the Edit Table dialog - Add an extra tab for editing foreign keys to the Edit Table dialog - Add auto completion for math functions - Add Ctrl+Enter as shortcut for executing query - Add new menu item to import from CSV data in the system clipboard - Add new menu item to show the row counts of all tables - Allow users to export or import user-settings file in a GUI environment - Add file, line number and function to Error Log - Add GUID display format - Add iif SQL function to the list of known functions in Execute SQL tab - Add new option to freeze columns in the Browse Data tab - Allow multiple TableBrowser tabs in the Browse Data tab - Bar charts now display labels in x axis when NULL values present - Scale large images in ImageViewer to fit the viewport by default - Enable HiDPI on all platforms by default - Change tabbed table browisng to use docks instead - Change mouse cursor to the pointing hand when Ctrl+Shift are pressed - Change to 'Preference' expression for consistent - Data Browser: avoid showing BLOBs containing unprintable characters as text - Data Browser: export query results as JSON - Edit Database Cell: fixed potential for data loss and better feedback - Edit Table: alternating row colors in tables for better readability - Edit Table: Change the key icons from header to tooltips - Fix indentation - always use 4 spaces - Plot Dock: use more precision for small numbers and less for big numbers - Plot: fix selecting points to select corresponding line in table - Plot: show x and y values on a tooltip when hovering over the plot - Table Browser: "Clear Filters" button to clear the global filter - Table Browser: give hint of table sorted or filtered state in the toolbar - Table Browser: Support extended selections - Add copy column name to table viewer - Allow multiple -t/--table parameters on the command line - Open recent files in read-only mode using a different shortcut - Allow selecting fixed format for big integer numbers - Allow the user to change MaxRecentFiles - Always load settings for Browse Data tabs - Always raise new Data Browser tabs to the foreground - **SQL Processing** - parser: Add support for IS (NOT) DISTINCT FROM expressions - Execute SQL: add Ctrl+Shift+T for "Open SQL file(s)" - Fall back to asking SQLite when parsing a table schema has failed - Update schema after attaching/detaching a database in an Execute SQL tab - Also update schema when clicking the Refresh button in Browse Data tab - Improvements for working in the SQL Execution area using keyboard - When modifying a view use DROP VIEW IF EXISTS instead of just DROP VIEW - Add basic support for new RETURNING keyword - Change WHERE clauses of queries to use column names instead of indexes - DB Schema: drag & drop SELECT queries - Export query results as JSON - Export SQL: fix quoting of BLOB values and non-printable strings - Export SQL: option to keep original CREATE statements - Improve support for BLOB columns as primary key - Use LIMIT + OFFSET when generating SELECT statements instead - **Files** - Import: Add import-csv option to command line to import CSV files - Move recent files items to new submenu and add clear recent file function - CLI: Reuse `--table` as table name for a CSV Import - CSV Export: binary BLOB to base64 - CSV Import: fix importing into existing table - CSV Import: give option to use system locale conventions - Import: allow CSV separator and quote to be passed from command line - Import: announce support for CSV files in Desktop file - Import: do not remove characters from CSV header fields - Import: don't assume an empty file is a text file - Import: support importing the single file argument as a CSV file - **Configuration** - New setting for configuring brace matching background - New setting for having close button on tabs (default) or not - New settings for changing the selection appearance in editors - Add the ability to support custom config files ### Changed There have been too many changes since the last full release to list separately. Important changes are listed in the **Added** section above. ### Fixed There have been too many bug fixes since the last full release to list separately. Please check out 3.13.0 and let us know if your issue still exists ### Removed - _none_ ### Translation - Add Dutch, Indonesian, Swedish translation - Update Arabic, Brazilian Portuguese, Chinese, French, German, Italian, Japanese, Korean, Polish, Spanish translation ## [3.12.2] - 2021-05-17 Release version of DB4S - DB Browser for SQLite. The basic features of the program are described in the [README.](https://github.com/sqlitebrowser/sqlitebrowser) Download release versions from [https://sqlitebrowser.org/dl/](https://sqlitebrowser.org/dl/)

Installazione manuale

Il programma è distribuito come pacchetto ZIP/7 ZIP: scaricare in una cartella temporanea e scompattare nella cartella di destinazione. Vedi sotto per il(i) link di download.

  • Il widget ExtendedSysTray per xCenter/eCenter è opzionale ma si suggerisce l'installazione
  • Per stampare è necessario il sistema Cups, opzionale.
I prerequisiti seguenti devono essere installati manualmente perché il programma possa funzionare:

E' possibile installare i prerequisiti con rpm, eseguendo la stringa seguente in una finestra comandi:

yum install libc libcx libgcc1 libssp libstdc++6 libstdc++ libsupc++6 libsupc++ libgcc-fwd libqt4 libqt4-gui libqt4-webkit libqt4-sql-mysql libqt4-sql-psql cups cups-filters qt5-qtbase* ghostscript
I link seguenti sono a programmi aggiuntivi, utili ma non indispensabili per il funzionamento:

Documentazione in linea

Qui di seguito trovi i link di download per l'installazione manuale del software:

DB Browser for SQLite (SQLite Browser) v. 3.12.99 (Release 2, 6/10/2023, Elbert Pol (TeLLie)) Readme/What's new
# CHANGELOG for DB4S All notable changes to the **Database Browser for SQLite** - DB4S - project will be documented in this file. The format is based on [Keep a Changelog](https://keepachangelog.com/en/1.1.0/), and this project adheres to [Semantic Versioning](https://semver.org/spec/v2.0.0.html).
 hobbes.nmsu.edu/download/pub/pub/os2/util/database/SQLiteBrowser_3-12-99r2.zip
DB Browser for SQLite (SQLite Browser) v. 3.9.1 (3/10/2016, Elbert Pol (TeLLie)) Readme/What's new
This is a small release that prepares the terrain for a new upcoming feature called DBHub plus a few old bugs fixed and some others that were introduced by 3.9.0: Major features DBHub.io was recently announced. Future releases of DB Browser for SQLite will optionally be able to save and retrieve your SQLite databases "in the cloud". 2016-10-01 file menu options 1b You can enable/disable this new submenu in Preferences. Enhancements Decreased lagging with long strings (further work still needed) - #761 (thanks to @innermous and @MKleusberg) Indicate when display strings are being truncated - #767 (thanks to @justinclift) Focus the newly created field after clicking 'Add field' - 64ee665 (thanks to @revolter) Improved Execute current SQL line action - #780, 45affc9, 531eddb (thanks to @revolter) Bug fixes Fixed default font selected being incorrectly detected - b15c7f2, 49786e1 (thanks to @innermous and @justinclift) Increased custom Page Size upper limit - e12e043 (thanks to @MKleusberg) Fixed program not being able to uninstall from "Programs and Features" in Windows 7 - 90c094e (thanks to @justinclift) Fixed executing current line action incorrectly logging the entire SQL - 55d8905 (thanks to @revolter) Added HTML entities escaping in output when executing SQL - b9dd11d (thanks to @innermous) Fixed Indexes with spaces around their name not being able to be deleted - 8be2c54 (thanks to @MKleusberg) Removed quotes around content when a single cell is copied - 8c510ff (thanks to @revolter) Help button should not be present in Windows title bar - #796 (thanks to @schdub) Translations Updated Russian translation - #795 (thanks to @schdub) Updated Spanish translation - #794, #801 (thanks to @lulol) Updated German translation - #798 (thanks to @FriedrichFroebel) Updated Korean translation - #797 (thanks to @progh2) Updated Brazilian Portuguese translation - #802 (thanks to @mafagafogigante)
 ftp.netlabs.org/pub/qtapps/sqlitebrowser-3.9.1-os2.7z
DB Browser for SQLite (SQLite Browser) v. 3.9.0 (2/10/2016, Elbert Pol (TeLLie)) Readme/What's new
It's been yet another half a year (more precisely, 8 months) since the previous version 3.8.0 was released, and a lot of good things happened. Major features Strong encryption is now supported on Windows, using SQLCipher! - 5d98a19 (thanks to @huy-cong and @justinclift for figuring this out) Keyboard navigation in the "Browse Data" tab now works well Our releases are now digitally signed on both Windows and MacOS Enhancements Add Fedora install instructions - #467, #470 (thanks to @subdriven) Add Windows DATE display format - #471 (thanks to @MyRoGeertGit) Remove ampersands from windows title - d9d2f96 (thanks to @MKleusberg) Feature request: Option to turn off "intellisense"-like suggestions - #537 (thanks to @MKleusberg) Add select and deselect all options for Export SQL dialog - #549 (thanks to @wierzba3) Add Homebrew Cask install instructions - #564, #566 (thanks to @timbroder) Add decimal support to display format - #569 (thanks to @jungle-boogie) Add Edit Database Cell update when selecting a cell from the Execute SQL tab - #570 (thanks to @larsimmisch) Cannot view binary data on BLOB columns containing image - #580 (thanks to @justinclift) Update Fedora install instructions - #586, #587 (thanks to @FreedomBen) Add preference setting for exports line ending - #592, #597 (thanks to @justinclift) Adjust executable/app name according to the project's name - #593 (thanks to @justinclift) Add duplicate record option - #594 (thanks to @innermous) Change default button to No in removal message dialogs - #618 (thanks to @innermous) Add default field type preference setting - #652 (thanks to @revolter) Add option to export only the data in an SQL export - c8f0203 (thanks to @MKleusberg) Remove buggy Edit Dialog and improved Edit Dock - #668, #679 (thanks to @justinclift) Add Ubuntu install instructions on the website - #671 (thanks to @justinclift) Add Rackspace logo on the website - 6fda155 (thanks to @justinclift) Add binary data size to the Edit Dock - #699 (thanks to @revolter) Update installer .dmg on Mac OS - #693 (thanks to @justinclift and @revolter) Add Create Index button in the toolbar and fixed Create Index dialog sizing - #704 (thanks to @revolter) Add backspace alongside delete key for cell empty, for laptops missing the delete key - #705 (thanks to @justinclift) Optimize choosing displayed text for cell - 6b42af7 (thanks to @innermous) Improve copy/pasting in ExtendedTableWidget - #709 (thanks to @innermous) Feature request: We should sign our official releases - #711 (thanks to @justinclift) Reimplement data handling in the Edit Cell widget - #713 #410 (thanks to @justinclift) Bug fixes Fix building on CentOS - #572 (thanks to @Maxim-Mazurok) Fix crash when browsing data in some cases - 730a272 (thanks to @MKleusberg) Fix font blur on retina displays in the SQL Log - #575 (thanks to @nickberry17) Fix crash when trying to delete records from empty table - #590 (thanks to @innermous) Fix database toolbar actions not updating after deleting a table - #600 (thanks to @revolter) Fix cancel button not working in the Export SQL dialog - #608 (thanks to @justinclift) Fix Field separator and Quote character preferences not restoring correctly - #609 (thanks to @justinclift) Fix various small bugs with the quote and separator choices - #611 (thanks to @justinclift) Fix primary keys not being quoted when creating/modifying tables - 7e0adab (thanks to @MKleusberg) Fix crash in Browse Data tab when pasting empty string over non-empty cell - 1ce62d7 (thanks to @innermous) Fix cell Edit Dialog not showing up centered - #644 (thanks to @DelphiGit) Fix Show rowid column option not correctly refreshing the table view - #645 (thanks to @revolter) Fix crash when hovering over any row from the rowid column - #646 (thanks to @revolter) Fix for unquoted path vulnerability in the Windows app - #649 (thanks to @DelphiGit and @justinclift) Fix incorrect app version in Finder's Info view - #658 (thanks to @revolter) Fix crash when trying to Export table(s) as CSV in some cases - 2c1ab5b (thanks to @innermous) Fix navigation keyboard shortcuts not working in Browse Data tab in some cases - 2bcc603 (thanks to @justinclift) Fix DB Toolbar visibility preference setting not restored in some cases - #666 :smiling_imp: (thanks to @innermous) Fix Alt-Delete not setting the selected cell to NULL - #663 (thanks to @justinclift) Fix transactions not being ignored when executing SQL - #656 (thanks to @revolter) Fix elements focus order on Tab press - #676 (thanks to @chrisjlocke) Fix Edit Dialog opening when pressing Enter - a7b5c3f (thanks to @MKleusberg) Fix Filter Input row in RTL Locales - #685 (thanks to @SafaAlfulaij) Fix Edit Dock default position - 30d2ce3 (thanks to @revolter) Fix crash when closing unsaved database (or some other rare cases) - #690 (thanks to @revolter) Fix font preference settings not being reflected in the Edit Dock - 7eb733b (thanks to @justinclift) Fix Arabic translations not showing up correctly - #702 (thanks to @justinclift) Fix cell binary data getting corrupted when trying to edit in place - #708 (thanks to @SafaAlfulaij) Fix foreign key preview not showing up for foreign keys in the first column - #718 (thanks to @schdub) Translations Add Korean translation - #475, #736 (thanks to @progh2) Add Turkish translation - #546, #548 f33a988 (thanks to @firateski) Add Spanish translation - #560, #723, #740 b1c853a (thanks to @lulol) Update German translation - #567, #733 (thanks to @FriedrichFroebel) Add Arabic translation - #642 (thanks to @0xbsec) Update Arabic translation - #706, #716 efba2eb (thanks to @SafaAlfulaij) Update Russian translation - #719 (thanks to @schdub) Add Brazilian Portuguese translation - #730 (thanks to @mafagafogigante) Update French translation - #727 (thanks to @mvt91)
 ftp.netlabs.org/pub/qtapps/sqlitebrowser-3.9.0-os2.7z
DB Browser for SQLite (SQLite Browser) v. 3.8.0 (17/6/2016, Elbert Pol (TeLLie)) Readme/What's new
It is over 6 months since the previous version 3.7.0 was released and a lot has happened since, all the details on which are below and as you can see there is a lot! On MacOS X, this is our first release using Qt5, and it's worth noting we updated the underlying SQLite to version 3.9.2 (on both platforms) this is so we can support the changes made for 3.9.x which impact database schema, see https://www.sqlite.org/releaselog/3_9_2.html for these changes. You will also notice a lot of "user experience" enhancements and fixes, so hopefully you will find this new release a pleasure to use. Happy Christmas! Enhancements Add proper file extension filters to all file dialogs - 6b8f57d (thanks to @MKleusberg) Improved error handling, e.g. more error messages with more detailed error descriptions - #362, #363, 1696ad1 (thanks to @schdub and @MKleusberg) Allow changing table columns even when there is a foreign key constraint on the table - #362 (thanks to @MKleusberg) When holding Ctrl and Shift while clicking on a cell with a foreign key set, the browser now jumps to the referenced record - #192 (thanks to @MKleusberg) Add option for disabling the SQL error indicators in the Execute SQL area - #302 (thanks to @MKleusberg) Add an option for setting the colours of fields with regular and binary data - #377 (thanks to @schdub) Use the name of the imported file as default suggestion for a table name during CSV import - #376 (thanks to @MKleusberg) Save filter values, sort order and column widths for all tables when switching the current table or tab; also save the settings in the project file - 748f06d (thanks to @MKleusberg) Show a small clear button inside each filter box - 944e22a (thanks to @MKleusberg) Add basic support for different 'display formats', i.e. a conversion of the contents of a column into a different format for display purposes (e.g. converting a Unix epoch into an actual date) - 7c1d237, 22e858d (thanks to @MKleusberg) Remove deleted files from list of recently opened files - #379 (thanks to @MKleusberg) Add a new option for horizontal tiling of the code and result view in the Execute SQL area - #380 (thanks to @MKleusberg) Move execution time of the SQL statement to the top of the result view in the Execute SQL area - #381 (thanks to @MKleusberg) Add 'x rows affected' information to the result view of the Execute SQL area - 82292c2 (thanks to @MKleusberg) Add built-in UTF16 and UTF16CI collation - #391 (thanks to @sebastian-philipp) Add Ctrl+R shortcut (besides F5) for the refresh table button - #388 (thanks to @MKleusberg) Add option for setting the font and font size of the text in the table browser view - #383 (thanks to @MKleusberg) Support opening of read only database files - #402 (thanks to @MKleusberg) Add option for showing the rowid column in the data browser view - #408 (thanks to @MKleusberg) Add option for showing the text in the data browser view using a different encoding - #414 (thanks to @MKleusberg) Add option for setting an escape character for the filters in the data browser - #421 (thanks to @MKleusberg) Add a small delay before applying a new filter value instead of performing an instantaneous search to improve performance on large tables - #415 (thanks to @MKleusberg) Automatically add '%...%' wildcards to a filter query - #415 (thanks to @MKleusberg) Add Delete and Alt+Delete keyboard shortcuts for setting the current cell to empty string or NULL in the data browser view - #443 (thanks to @MKleusberg) Add new option for moving the Edit cell data dialog into a dock which is locked to the main window and stays opened - #416, #440, #441 (thanks to @MKleusberg) Allow drag-&-dropping text and files on a cell in the data browser - #441 (thanks to @MKleusberg) Add keyboard shortcuts for recently opened files - #432 (thanks to @MKleusberg) Add new option for setting a SQL script which gets executed whenever any database file is opened - #451 (thanks to @MKleusberg) Allow pasting data (e.g. from a spreadsheet) directly into the data browser view - #453 (thanks to @MilosSubotic) Bug fixes Fix missing SQL log when query contains a line break, also trim the log - #337, #356 (thanks to @schdub and @MKleusberg) Also set foreign key settings when creating a new database instead of just setting them when opening a file - 212116a (thanks to @MKleusberg) Fix drawing of Unicode characters in the SQL editor where the font settings wouldn't apply as they should have - #365 (thanks to @SevenLines) Allow values greater than 10000 in the user_version pragma of a database - #366 (thanks to @schdub) Fix adding new a record into a table where all fields are set to a default value - #369 (thanks to @schdub) Fix resizing of the code and result view in the Execute SQL area - 6806a9b (thanks to @MKleusberg) Fix error message when changing table - #390 (thanks to @MKleusberg and @GeorgijK) Fix parsing of double backticks and double quotes used to escape a single one in create table statements - 160bc87, dce47b3 (thanks to @MKleusberg) Fix handling of tables when their name contains a backtick - #387 (thanks to @MKleusberg) Try to set a better window position when opening the Edit cell data dialog - #342, #394 (thanks to @MKleusberg) Fix possible infinite loop in the Edit cell data dialog - #444 (thanks to @manisandro) Fix bug when pressing the cancel button in the dialog you see when you're closing a database with unsaved changes - #432 (thanks to @MKleusberg) Don't allow conflicting field names in the Edit Table dialog - #460 (thanks to @MKleusberg) Translations Add translation into Traditional Chinese - #425 (thanks to @PeterDaveHello) Cross platform fixes Fix building on OS X 10.10 - #384 (thanks to @jehoffmann)
 ftp.netlabs.org/pub/qtapps/sqlitebrowser-3.8.0-os2.7z
DB Browser for SQLite (SQLite Browser) v. 3.7.8 (5/6/2012, Ruediger Ihle)
 hobbes.nmsu.edu/download/pub/os2/apps/database/sqlitebrowser13j.zip
Scheda aggiornata l'ultima volta il: 08/08/2024 - 05:52

Aggiungi un commento