Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

A powerful and practical software utility specifically built to extract data from databases and improve performance by removing obsolete entries.

Apache License 2.0

Whats new:>>

New "Where Condition" Editor allows quick and easy narrowing of table contents to the relevant data.

http://jailer.sourceforge.net/

[SiLæncer]

Exportizer is a free database export tool. It allows you to export data to a file, clipboard, or printer. Exportizer works via BDE or ADO. It can convert DB, DBF, text, CSV to text, CSV, XLS, RTF, XML, HTML, DBF, and INSERT statements. Many export options ensure full control over output. There is an ability to specify the source-to-target field mappings. Export operations can be performed either via the program interface or via command line with large number of parameters. You can easily generate needed command line directly from the GUI. It is possible to copy data to the clipboard or print it. There are several utility functions for data manipulating and bookmarking.

Features:

Opening tables from multi-table database files like XLS, XLSX, XLSM, XLSB, MDB, ACCDB, HTML, GDB, IB, FDB, UDL, and other multi-table databases like ODBC data sources etc.
Exporting data from all files, which are located in one folder, or all tables from a multi-table data source, at once (from interface or via command line).
Ability to specify custom increment number for Increment Field Value function.
Exporting data to Excel (XML-based) and DATABASE formats.
Using extra command line line options like /Silent, /LogFile, /CloseOnError etc.
Using extra export modes like Append and Empty+Insert.

Whats new:>>

Minor improvements and bug fixes.

http://www.vlsoftware.net/

[SiLæncer]

Whats new:>>

    The new "Where Condition" Editor allows quick and easy narrowing of table contents to the relevant data.
    Code completion feature has been significantly improved.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

    Data viewer:

    Record mode now supports multiple records view
    Double-click behavior in filters popup was fixed
    Spatial viewer now allows to copy point coordinates
    Source tables resolution was fixed for CTE queries and sub-selects

    Navigator:

    Quick filter was fixed (show connected only)
    “Set connection from navigator” action behavior was fixed

    SQL editor:

    Auto-completion for identifiers with special characters was fixed
    SQL console now opens for selected schema
    Table columns are shown in original order for auto-completion
    Formatting of queries with embedded comments was fixed
    Local variables coloring was added (Sybase, SQL Server, MySQL)

    Metadata editor:

    Metadata search now supports search in procedures/views definition
    Object info refresh was fixed
    Table triggers loading performance was significantly improved for most databases

    Clickhouse:

    Table DDL was fixed
    Nested comments support was added
    Data edit (update/delete) queries generator was fixed
    DB2 iSeries: schemas with long names loading was fixed
    Hive: constraints definition was fixed

    MySQL:

    Execution plan explain for CTE queries was fixed
    Use password escape was fixed
    PrestoDB/Trino: data and metadata editors were improved

    PostgreSQL:

    Data type fully-qualified name now used instead of scale/precision
    Custom data types (including geometry) resolution was improved
    SAP HANA: stored procedures results loader was improved (multiple cursors + atomic values)
    Snowflake: $$ parser was improved

    SQL Server:

    Temporary table support was improved (metadata load, SQL auto-suggest)
    datetime data type DDL was fixed
    Active schema selector was fixed
    BEGIN/END blocks support was added

    Vertica:

    Flex tables metadata was fixed
    Function body parser was fixed

[close]

https://dbeaver.io/

[SiLæncer]

Database .NET is a powerful and intuitive multiple database management tool. The program allows the administration of local or remote databases to browse objects, design tables, edit rows, export data, create new databases and run queries with a consistent interface. The program includes table/data editor, index editor, syntax highlighting, SQL profiler, code manager and multiple query tabs.

Supported databases include SQL Server, SQL Azure, Firebird, SQLite, MySQL, PostgreSQL, Oracle, IBM DB2 and Informix, Sybase ASE, MS Access and Excel, dBase IV, FoxPro, Data Sources, ODBC DSN and OData. Can export to CSV, XML, TXT, XLS, or SQL Print Query Results.

License:    Free for personal or non-profit use

Changelog

- Query Tabs ):

    Add: Support Custom Database Type Tab Colors (7857)
       User Interface->Query Tabs->Database Types

-Main Program Update ( Main ):

    Upd: Compatible with Microsoft Windows 11(7857) ) Add:
    (SQLite) Add LOCALIZED custom collation (7857)
    Add: (SQLite) Add AES256 encryption database REGEX function support (7857)
    Upd: (PostgreSQL 14) Update multirange data types output problem (7857)
    Upd: Run query To text display (Execute query to text): restore the original output mode after completion (to Grid/File/Text) (7857)
    Upd: unified sort processing of all database names and example items (7857)
    Upd: optimized interface and HiDPI high zoom Scale display problem (7857)
    Upd: Others include cumulative minor updates, corrections and optimization processing (7857) -Filtering and Sorting columns

( Filtering and Sorting columns ):

    Add: The column type is displayed directly to the right of the column name (7857)
    Upd: default click copy to copy the whole election process field (7857)

- SQL editor ( SQL editor ):

    the Add:When the database file Drag & Drop to the editor will automatically detect the type and open to the database form (7857)

- Code Management ( Code Manager ):

    Upd: Search List height allows the scaling process (7857)

- Database Migration ( Database Migration )(Pro):

    Upd: All updates are the same as dbMigration .NET software (7857)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

This is viewer and editor for Paradox tables. It has password protection removing and fix & repair ability. It uses BDE.
Built-in BLOB viewer, filtering and searching, column statistics, index management and structure viewer are tools that covers most needed operations.
Data can be exported to many formats e.g. HTML, SYLK, Excel, RTF or XML and CSV and printed.
Data can be imported from XML and CSV.

Freeware

Whats new:>>

* Fixed empty database opening

http://www.mitec.cz/pde.html

[SiLæncer]

Whats new:>>

Minor fixes and improved error reporting mechanism.

http://jailer.sourceforge.net/

[SiLæncer]

Thoroughly organize, analyze and share large datasets with the help of this open-source and quite good-looking piece of software.

License: GPLv3

Changelog

    We're back with another big update to Metabase. Here's what's new.

    Dashboards just got a lot easier to build:

    We've outfitted the dashboard editing mode with two major upgrades:

    A new and improved way to add questions to your dashboards:
    Up until now, you've only been able to add questions to a dashboard one at a time. But now you can open up the sidebar to easily search for and add as many questions as you want. It's more satisfying than popping bubble wrap.

    Vastly improved reordering and resizing:

    When you move or resize a card, other cards float away to make room for the new card placement.

    A more intuitive way to start new questions from SQL results:

    One cool feature in Metabase is the ability to use the results of a saved question as the starting point for a new one. In particular, you can use SQL to wrangle some particularly unwieldy tables, save the query as a question, then let other people explore the results using the graphical query builder.
    With saved SQL questions, you'll now see a handy Explore results button that fires up the graphical query builder, with the SQL results loaded up as the starting data for your new question.

    Improved data selection:

    We've overhauled the search bar in the data picker for your new questions so that it now searches through all of your tables and saved questions instead of simply filtering the list.

    New in Metabase Enterprise Edition:

    Here are some new tricks we've added to the Enterprise edition to help you tame large Metabases.

    We've made it easy to find queries to optimize in the Audit tab:

    View query runs, average execution time, and total time running to help you track down and focus your optimization efforts on heavily-used queries.

    Better serialization:

    You can download your application metadata to take snapshots of your Metabase, or preload new Metabase instances with questions and dashboard. Serialization now captures customizations, like custom click behavior on dashboard cards, so your dashboards will be all wired-up and ready to go when you load them. Check out this article on serialization to learn more about what serialization can do, and how.

    Even more polish and enhancements:

    We've made a whole host of additional improvements to Metabase.
    Manage more people, faster: we've added search and pagination to the People tab in the Admin panel.
    Paginated search results (so you get results faster).
    Stronger password requirements (no more password123).
    Better human-friendly field names.
    URLs now show friendly names for databases, questions, dashboards, and collections. No links will break; we're just tagging on titles to the URL (e.g., "/question/123" becomes "/question/123-Orders-by-product")
    Better filter names.
    Metabase can now infer data types for custom columns, so it knows to show you the right filter options for that column.
    Date string formatting coercion.
    Links to docs to help you connect databases.
    Friendly custom expression error messages to help you debug faulty formulas.
    Better visibility into database connection pooling.
    Link settings for visualizations on columns (set up a link setting for a question once, so you don't have to redo it every time you add the question to a dashboard).

    Here is the full list of enhancements and bug fixes:

    Enhancements:

    Fix funnel appearance (#16626)
    Confusing UI when adding GeoJSON with no identifiers (#16613)
    Can't move item to "Our analytics" using drag-n-drop (#16498)
    Collections Metadata FE Implementation (#16356)
    Cannot filter only on longitude/latitude range - UX is forcing user to fill out values for both fields (#16291)
    Display link to database integration docs when connecting a new database (#16018)
    Infer the data type for Expression Dimension (custom column) (#15952)
    fix funnel dashboard card overflow (#15869)
    make TableInteractive cell more button-like (#15833)

    Bug fixes:

    Error message missing when logging in to a disabled account with Google sign-in (#16701)
    unix-timestamp->honeysql implementation for h2 is incorrect for microseconds (#16628)
    Better error handling when adding malformed GeoJSON (#16611)
    Can't archive a question from the Question page (#16512)
    Can't "Select All" collection items if all items are pinned (#16497)
    Bulk archive doesn't work (#16496)
    Selecting bin count on intermediate data question fails (#16379)
    Group by on a :Coercion/YYYYMMDDHHMMSSBytes->Temporal postgres column fails (#16335)
    Double binning menu for date fields when using Saved Question (Native) (#16327)
    Bug in values on data points for waterfall charts (#16246)
    Table view on Permissions shows error on browser refresh (#16237)
    Password login on SSO instance drops the redirect URL (#16216)
    No error is reported when adding SQLite database that doesn't exist (#16199)
    Specific combination of filters can cause frontend reload or blank screen (#16198)
    Dashboard Contains filter doesn't remain when clicking on Question title (#16181)
    Normal login errors are not surfaced if SSO is also active (#16122)
    Search endpoint breaks if single model asked for in postgres before 10 (#16059)
    Version info and hash missing in 'About Metabase' in master (#16045)
    Google sign-in client ID setting regularly fails to save (#15974)
    Surface password change error messages to users (#15954)
    Incorrect selection range leading to aggressive popover (#15851)

[close]

https://www.metabase.com/

[SiLæncer]

Whats new:>>

    Improved automatic arrangement of table windows in the data browser.

http://jailer.sourceforge.net/

[SiLæncer]

This compact and minimalist Windows GUI for SQLite will enable its users to perform a wide range of database operations and processes.

License: GPLv2

Changelog

    Highlight all occurrences of selected word in editor
    Ctrl + Space allows to select one of column values in Data editor
    Export query result to CSV when row limit is exceeded (issue #58)
    Show a result row number in the statusbar (issue #59)
    Add vsv extension (issue #56)
    Popup menu in terminal output
    Fix minor bugs (issues #57, #61)

[close]

https://github.com/little-brother/sqlite-gui

[SiLæncer]

Changelog

    Enhancements:

    Remove Multi-Release from manifest (#17026)
    Global search suggestions dropdown appears behind the dataset search widget when starting a simple question (#16897)
    Clean up the user-facing strings for coercion options (#16547)

    Bug fixes:

    An error occurs when opening a public question with filters having default parameters (#17033)
    Questions filters does not work in Embedded/Public (#17019)
    Long titles in collections push out the last-edited-by and last-edited-at columns (#16991)
    Only first 50 databases are displayed (#16983)
    After hiding the column and then setting a required default value for SQL field filter (connected to that column) shows all fields as hidden and breaks SQL filters completely (#16914)
    Clicking Visualize in Notebook makes the question "dirty" even if no changes was made (#13470)

[close]

https://www.metabase.com/

[SiLæncer]

Changelog

- Script Generator ( Script Generator ):

    Upd: Generate UNIQUE index method and process it in CREATE mode (7866)
    Upd: (SQLite/SQL Server/SQL Azure/Firebird) Omit the default data row ordering to simplify the generated content (7866)
    Fix: (Informix ) Fix the problem of automatically created index generation (7866)
    Fix: (Firebird) Avoid repeated generation of UNIQUE index (7866)
    Fix:(VistaDB/MySQL) Fix the problem that the field comment contains the exception character (') (7866)
    Upd: Whether to include the conditional constraint name, add PK processing (default PK/FK not included) (7866)-Main

program update ( Main ) :

    Upd: (Firebird) Optimize and unify the data type output processing of all objects (7866)
    Upd: (SQL Server/SQL Azure) Add a prompt message when the Azure Active Directory authentication item is selected (7866)
    Upd: Improve user experience: Click no longer contains a child node (7866) of the node collapsing
    Upd: other minor updates contain accumulated, correction and optimization (7866)

- design table ( the table Designer ):

    Fix: (Firebird) corresponding to the correction is not included when setting COLLATE CHARACTER SET NAME question (7866)

- rows browsing and editing (the data browser and editor):

    Upd: Support (>2D) Multidimensional Arrays related processing (7866) -SQL Editor
( SQL Editor ):

    Upd: Improve statement parsing and multi-line annotation processing to avoid freezing (7866)-Data
import ( Data Import ):

    Fix: Fix and improve the problem of copy and paste preset encoding processing (7866) -Connection Process Manager

( Connection Process Manager ):

    Upd: Automatically close after execution due to permission cannot be opened (7866) )

- database migration ( database migration ) (Pro):

    Upd: all updates with dbMigration .NET software (7866)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

pgAdmin allows multi-database management through an administration interface for PostgreSQL permitting statement, procedure viewing and more.

License: Open Source

Changelog

    New features:

    Issue #1975 - Highlighted long running queries on the dashboards.
    Issue #3893 - Added support for Reassign/Drop Owned for login roles.
    Issue #3920 - Do not block the query editor window when running a query.
    Issue #5940 - Added support for OAuth 2 authentication.
    Issue #6559 - Added option to provide maximum width of the column when ‘Resize by data?’ option in the preferences is set to True.

    Housekeeping:

    Bug fixes:

    Issue #4189 - Ensure that the Data Output panel can be snapped back after it is detached.
    Issue #6388 - Fixed replace keyboard shortcut issue in the query tool on the normal keyboard layout.
    Issue #6398 - Fixed an issue where detaching the query editor panel gives a blank white panel.
    Issue #6427 - Remove leading whitespace and replace it with ‘[…] ‘ in the Query Tool data grid so cells don’t look empty.
    Issue #6448 - Fixed an issue in the search object when searching in ‘all types’ or ‘subscription’ if the user doesn’t have access to the subscription.
    Issue #6489 - Fixed an issue where Execute/Refresh button should not be disabled when we run the empty query.
    Issue #6505 - Fixed an issue where the New Connection Drop Down has lost default maintenance database, auto-select, and tab-through functionality.
    Issue #6536 - Fixed directory selection issue with the folder dialog.
    Issue #6541 - Ensure that setting ‘Open in new browser tab’ should be visible, it should not be based on the value of ‘ENABLE_PSQL’.
    Issue #6547 - Fixed copy/paste issues for PSQL tool terminal.
    Issue #6550 - Disable email deliverability check that was introduced in flask-security-too by default to maintain backwards compatibility.
    Issue #6555 - Fixed Czech translation string for ‘Login’ keyword.
    Issue #6557 - Fixed an issue where incorrect column name listed in the properties of Index.

[close]

https://www.pgadmin.org/

[SiLæncer]

Changelog

    Alt + F8/F9 to get plan/execute an query under cursor
    Save query result as a table
    Query results comparison
    Ora-extension: levenshtein distance
    Add replacement to Find dialog
    Fix issues #63, #64

[close]

https://github.com/little-brother/sqlite-gui

[SiLæncer]

Changelog

    SQL editor:

    Output/Execution Log panels layout was changed
    Variables/parameters management panel was added
    SQL template variables completion was fixed
    Command for assigning query results to variable was added

    Data transfer:

    Custom transformations were added for table column mapping
    Referential integrity disablement was added for MySQL, SQL Server and Exasol
    Column mappings page supports reordering now
    Data export task editor was fixed (task re-configuration support)
    Query based data export task now supports query editing
    Export in HTML format was fixed (extra line breaks)
    Columns auto-assign button behavior was fixed
    Execute process after data transfer supports multiple tables export now
    Mixed case columns auto-mapping was fixed
    Several problems with NullPointerException during editor opening were fixed

    Navigator:

    Open file: last opened folder is saved between app launches
    Object filter: special characters escaping was added

    MySQL:

    Data import performance was significantly improved

    Oracle:

    View indexes reading was fixed
    TNS aliases resolution was improved
    Data export in SQL format was fixed

    PostgreSQL:

    Database backup/restore in custom format was fixed
    Database backup validates output file existence
    Firebird: query execution plan explain was fixed
    Several minor UI bugs were fixed

[close]

https://dbeaver.io/