Autor Thema: Datenbanksoftware und Tools diverses ...  (Gelesen 303393 mal)

0 Mitglieder und 5 Gäste betrachten dieses Thema.

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 191383
  • Ohne Input kein Output
    • DVB-Cube
Metabase 0.42.3
« Antwort #1500 am: 25 März, 2022, 18:20 »
Thoroughly organize, analyze and share large datasets with the help of this open-source and quite good-looking piece of software.

License: GPLv3

Changelog

    Enhancements:

    Upgrade MySQL/MariaDB JDBC driver to version 2.7.5
    "Show error details" in Query Builder should be toggleable

    Bug fixes:

    Comma Separate Numbers filter not working as it previously did
    Markdown parsing on backend doesn't support autolinks
    Subscription fails, when there's specific characters that causes Markdown failure
    Custom Column allows aggregation functions together with algebra, which fails on query
    Cannot connect Google Analytics because of deprecated OAuth OOB
    Postgres certificate SSL key reference incorrect
    Embedding with Locked parameters does not allow numeric values
    Models should not be shareable (embedding/public)
    BigQuery: Aggregating by a datetime in a saved question fails because of bad aliasing
    "Saved" overlay in data model UI in weird location on smaller screen
    "Compare to the rest" action in drill-through menu looks busted
    Autocomplete suggestions are not working for most of the database tables
    Permissions paths validation is GET API endpoints is too strict; causes numerous endpoints to 500 if unknown entry is present
    Main page loading spinner spins forever on API error
    Cannot use Data Selector when going directly to a question in new tab (or browser refresh)
    No visual feedback when setting column properties in Admin > Data Model
    QP/MBQL: [:relative-datetime :current] doesn't work inside [:between] filter
    Icon on empty activity page is misaligned
    Google Analytics updated Credentials aren't used for Connection
    Google Analytics database connection stopped working. (#14578)
    Binning not working in table with a single row (#13914)
    Fix error in send-abandonment-emails task (#12068)
    Can't change Google Analytics DB settings (#6613)

[close]

https://www.metabase.com/

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 191383
  • Ohne Input kein Output
    • DVB-Cube
Database .NET Free 33.9.8121.1
« Antwort #1501 am: 27 März, 2022, 11:20 »
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


- SQL Editor ( SQL Editor ):

   Fix: Exclude single quote '' content batch command GO and / parsing processing to avoid causing exception (8121)

- Query Builder ( Query Builder )

   Add: Support to select multiple checkboxes using shortcut keys Shift or Ctrl +Click(8121)
   Add: Right-click menu items support Select All and Invert selection (8121)

- Database Diagram ( Database Diagram ):

   Upd: Complete display of reference/referenced/self-reference icons (8121)
   Fix: Fixed connection/grammar/deletion issues when the data table is associated more than once (8121)

- Query Tabs :

   Fix: Avoid the abnormal problem caused by continuously clicking the middle mouse button to close the query tab (8121)
   Fix: Fix the abnormal display of the controls when the horizontal/vertical [multi] tab is dragged and zoomed again (8121)

- Script Generator :

   Upd: Automatic processing of data table creation sequence: In addition to processing [referenced], complete processing such as [reference] is added (8121)

- Filtering Objects :

   Upd: (SQL Server/SQLAzure/SybaseASE) Object filter will include structure description name (SCHEMA.OBJECT)(8121)

- Index Designer :

   Upd: Added processing to add default index name (8121)

- Main program update ( Main ):

   Fix: (Teradata) Fixed the problem that the password expired [hint] and [update] functions do not work (8121)
   Fix: Fixed (8075) the low-level error that the data table field cache could not be obtained twice (the effect includes multiple places) (8089)
   Upd: Connection Explorer : When [Last Access Time] does not exist, it will be created automatically (8089)
   Upd: (ODBC) Allow update of connection dialog settings after connection failure (8089)
   Add: Support YugabyteDB database (PostgreSQL compatible) (8121)
   Upd: Others include cumulative minor updates, corrections and optimizations (8121)

[close]

http://fishcodelib.com/Database.htm

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 191383
  • Ohne Input kein Output
    • DVB-Cube
DbGate 4.7.4
« Antwort #1502 am: 27 März, 2022, 18:40 »
A database management application with support for MySQL, MS SQL and PostgreSQL, with a built-in query designer and a table and SQL editor.

MIT License

Changelog


    ADDED(all): Experimental Redis support (full support is planned to version 4.8.0)
    ADDED(all): Read-only connections
    FIXED(all): MongoDB filters
    ADDED(all): MongoDB column value selection
    ADDED(all): App related queries
    ADDED(all): Fuzzy search #246
    ADDED(docker, npm): New permissions
    FIXED(npm): NPM build no longer allocates additonal ports
    CHANGED(npm): renamed NPM package dbgate => dbgate-serve
    CHANGED(docker): custom JavaScripts and connections defined in scripts are now prohibited by default, use SHELL_CONNECTION and SHELL_SCRIPTING environment variables for allowing this
    ADDED(docker, npm): Better documentation of environment variables configuration, https://dbgate.org/docs/env-variables.html
    ADDED(docker): support for multiple users with different permissions
    ADDED(docker): logout operation

[close]

https://github.com/dbgate/dbgate

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 191383
  • Ohne Input kein Output
    • DVB-Cube
DbGate 4.8.0
« Antwort #1503 am: 29 März, 2022, 17:20 »
Whats new:>>

    ADDED(all): Redis support (support stream type), removed experimental status
    ADDED(all): Redis readonly support
    ADDED(all): Explicit NDJSON support, when opening NDJSON/JSON lines file, table data are immediately shown, without neccesarity to import
    ADDED(app): Opening developer tools when crashing without reload app

https://github.com/dbgate/dbgate

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 191383
  • Ohne Input kein Output
    • DVB-Cube
DbGate 4.8.1
« Antwort #1504 am: 30 März, 2022, 05:15 »
Whats new:>>

FIXED crash after disconnecting from all DBs

https://github.com/dbgate/dbgate

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 191383
  • Ohne Input kein Output
    • DVB-Cube
DbGate 4.8.2
« Antwort #1505 am: 31 März, 2022, 20:40 »
Whats new:>>

ADDED(all): implemented missing redis search key logic

https://github.com/dbgate/dbgate

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 191383
  • Ohne Input kein Output
    • DVB-Cube
DBeaver 22.0.2
« Antwort #1506 am: 03 April, 2022, 22:20 »
Free multi-platform database tool for developers, database administrators, analysts and all people who need to work with databases. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Apache Hive, Phoenix, Presto, etc.

Apache License 2.0

Changelog

    Data editor:
        Option “show whitespaces” was added
        Columns reordering in data filter dialog was fixed
        Line numbers were added to plaintext view
    SQL editor:
        Script error visualization is not configurable
        Block statements (BEGIN, IF, CASE) auto-close was improved
        Auto-completion was fixed for INSERT queries
        “Cancel active query” command was added
        Filtering of aliased columns was fixed
        Problem with DML queries re-execution on connection lost was fixed
        Python source code format was added to Copy As command
        “Hippie” auto-completion was disabled by default (due to performance problems)
        SQL commands parser/navigation was fixed (thanks to @arvillion)
        Parameter bindings dialog was disabled for long strings (like $$)
        CASE/WHEN formatting was fixed
    Driver editor:
        Driver description editor was fixed
        Maven artifacts version resolution was improved
    Data transfer: recreate table mapping support was fixed (saved configuration and tasks)
    SSH tunnels: connection timeout/keep-alive parameters change was fixed
    MacOS: problem with application launch was fixed (problem with plist file modification)
    Dark theme: buttons UI now matches OS theme
    Apache Druid, Apache Kylin:
        Table data read was fixed
        Data type properties were fixed
        Indexes read was fixed
    Azure Databricks driver was added
    Clickhouse: array data type editor was implemented
    DB2: query terminator redefine support was added
    H2:
        System views DDL generation was fixed
        Geometry data type rendering in new H2 driver was fixed (thanks to @ebocher)
    MySQL: functions execute was fixed
    PostgreSQL:
        Nested arrays editor was implemented
        Functions source code generation was fixed (function signature)
    Portuguese localization was fixed (thanks to @TiagoValdrich)

[close]

https://dbeaver.io/

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 191383
  • Ohne Input kein Output
    • DVB-Cube
SQLite GUI 1.7.1
« Antwort #1507 am: 04 April, 2022, 20:40 »
This compact and minimalist Windows GUI for SQLite will enable its users to perform a wide range of database operations and processes.

License: GPLv2

Whats new:>>

    Schema selector (issue #99)
    Filter by value
    Up SQLite to 3.38.2
    Change comment/uncomment behaviour (issue #100)
    Improve scripting
    Fix bugs

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

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 191383
  • Ohne Input kein Output
    • DVB-Cube
pgAdmin 4 6.8
« Antwort #1508 am: 07 April, 2022, 12:40 »
pgAdmin allows multi-database management through an administration interface for PostgreSQL permitting statement, procedure viewing and more.

License: Open Source

Changelog

    New features:

    Added transaction start time to Server activity sessions view.
    Added support for unique keys in ERD.
    Support running the container under OpenShift with alternate UIDs.

    Housekeeping:

    Port Properties panel for collection node, Dashboard, and SQL panel in React.
    Port preferences dialog to React.

    Bug fixes:

    Fixed an issue where SQL for revoke statements are not shown for databases.
    Adds a new LDAP authentication configuration parameter that indicates the case sensitivity of the LDAP schema/server.
    Fixed an issue where the error is shown on logout when the authentication source is oauth2.
    Fixed an issue where the browser tree state was not preserved correctly.
    Fixed an issue where foreign key relationships do not update when the primary key is modified.
    Ensure that the values of certain fields are prettified in the statistics tab for collection nodes.
    Ensure objects depending on extensions are not displayed in Schema Diff.
    Fixed an issue where foreign key is not removed even if the referred table is removed in ERD.
    Fixed an issue where the newly added table is not visible under the Tables node on refresh.
    Correct typo in the documentation.
    Fixed schema diff issue where function’s difference DDL was showing incorrectly when arguments had default values with commas.
    Ensure that the correct user should be selected in the new connection dialog.
    Fixed schema diff issue in which the option ‘null’ doesn’t appear in the DDL statement for the foreign table.
    Fixed an issue where unexpected error messages are displayed when users change the language via preferences.
    Ensure that pgAdmin4 should work with latest jinja2 version.
    Fixed ‘Cannot read properties of undefined’ error while creating the table via the ERD tool.

[close]

https://www.pgadmin.org/

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 191383
  • Ohne Input kein Output
    • DVB-Cube
Metabase 0.42.4
« Antwort #1509 am: 08 April, 2022, 19:10 »
Changelog


    Enhancements:

    Disallow FDW connections in SQLite (#21525)
    Inform the user when a database driver isn't official (#21409)

    Bug fixes:

    Dashboard filter dates by Quarters fails, but works on the question (#21083)
    Custom Column aliasing can cause incorrect results or wrong alias on nested queries (#21131)
    "Invite someone" button overlaps activate/deactivate radio buttons on small screen widths (#16350)
    "Custom mapping" is only available, when "A list of all values" is set (and after a browser refresh) (#16322)
    Nan/Infinity in question's result aused .xlsx exporting fail (#21343)
    Nan/Infinity in question's result aused .xlsx exporting fail (#21343)
    Custom Column aliasing can cause incorrect results or wrong alias on nested queries (#21131)
    Dashboard filter dates by Quarters fails, but works on the question (#21083)
    Autocomplete flicker in SQL Editor (#21034)
    Cannot convert SQL question with Snippet to Model (#20963)
    Serialization does not remove cards from dashboard even with --mode update (#20786)
    Error when filtering date by current quarter in Postgres (#20683)
    Can't load uploaded CA certificate into the TrustManager on 0.42 (#20319)
    Serialization overlaps cards on load (#19762)
    [New question picker] Moved model's collection isn't displayed until page refresh (#19737)
    Date filter selection stays on the foreground when switching to notebook (#18079)
    Ignore empty strings in conditional formatting (#16822)
    "Invite someone" button overlaps activate/deactivate radio buttons on small screen widths (#16350)
    "Custom mapping" is only available, when "A list of all values" is set (and after a browser refresh) (#16322)
    "Replace missing values with" won't work when grouping by minutes (#16037)
    TIME are randomly cast with/without timezone depending on millisecond values (#15876)
    Zero showing as -0.0000...89 in chart x-axis (#15188)
    Mapped value shows random number for 0 instead of string in chart (#14218)
    Missing Filter Box in Mobile Size (#13726)

[close]

https://www.metabase.com/

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 191383
  • Ohne Input kein Output
    • DVB-Cube
HeidiSQL v12.0
« Antwort #1510 am: 13 April, 2022, 19:20 »
HeidiSQL lets you see and edit data and structures from computers running one of the database systems MariaDB, MySQL, Microsoft SQL, PostgreSQL and SQLite.

License: GPLv2

Changelog


3rd party updates:

    Update SQLite libraries to v3.38.0
    Update VirtualTrees component source to v7.6.1
    Update OpenSSL libraries to v1.1.1l (used in PostgreSQL mode)
    Update libmariadb.dll and plugins to current stable versions

New stuff:

    Experimental support for high DPI in default Windows theme/style
    Experimental support for Interbase and Firebird connections (issue #1169)
    Support for Windows 10's built-in SSH client for tunnels, as an alternative to plink (issue #362)
    SQL export: add new menu item "Copy mysqldump command line" in "Options"
    Known function names per server type: function names are now loaded from separated *.ini files, e.g. functions-mariadb.ini
    Create editor commands for moving line up/down (Alt+Up, Alt+Down, "Edit" menu)
    Create "copy with tabs to spaces" action, and place it in Edit menu. (#1285)
    New context menu items "Close query tabs to the right", and "Close all query tabs" (issue #710)
    New item in context menu of headers in grids and lists, for toggling visibility of all columns per one click (#1360)
    New grid export format: SQL UPDATEs (issue #125)
    New grid export format: Jira Textile (issue #1013)
    Empty-tables-confirmation supports disabling foreign key checks (issue #1491)
    Support renaming SQLite tables in database tab (#1427)
    Editor highlights all occurrences of selected word, similar to Notepad++ (issue #670)

Bugfixes and enhancements:

    Loading an sql file does not activate its tab, e.g. when loading multiple files. Fix crash happening when active tab is not a query tab in such cases.
    Remove closing PHP tag from export as PHP array
    Performance enhancement with many opened query tabs
    Fix some potential file related exceptions in text file import
    Support filenames with accented chars in text file import dialog (issue #1387)
    New query tab uses the same memo height as the current tab
    Session background color now used on query result tabs, and in query gutter (issue #932)
    Fix various style/theme related crashes, for instance when closing the grid export dialog
    Reset timezone in SQL exports to zero offset, to be independent from local date/times in TIMESTAMP columns
    Fix missing SET TIME_ZONE.. on export target server (issue #1457)
    Single quotes and backslashes in PostgreSQL connection string values are properly escaped now (issue #1417)
    Prefer SUBSTRING() over SUBSTR() in Postgres mode, to restore Redshift compatibility. (issue #1259)
    Fix "Table x not found in tree" after creating a table with upper case letters on Windows servers. See https://www.heidisql.com/forum.php?t=38150
    Support UINT columns in SQLite mode (issue #1453)
    Update SynEdit's list with known MySQL keywords, taken from https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-in-current-series (issue #1437)
    Run current query: Prefer query left to the current one, if current one contains no text (issue #603)
    SQL export: don't generate ALTER TABLE..DISABLE/ENABLE KEYS for InnoDB tables
    Activate auto-suggest option "Find matches in middle of entered text" by default.
    Don't clear variable from --description cli parameter. (#1295)
    Quote column names for quick filter, when column name matches an SQL function (#1398)
    Session manager: Auto-expand session folder when user filter matches a child session
    Fixes for handling virtual columns (#1210)
    Add option to turn off tab close by doubleclick/middleclick (#1151)
    Activate CLIENT_PLUGIN_AUTH_LENENC_CLIENT_DATA option for MySQL/MariaDB, fixing some SSL issues on MySQL 8 (issue #1539)
    NUL characters in grid values are replaced with a space when editing or copying. Editor gets read-only mode then. (issue #202)
    Binary values in foreign key pulldown now works with hex code, instead of binary garbage (issue #1540)
    Enhanced foreground/background colors for matching brace in dark themes. (issue #887)
    Fix EAbort error when copying text from SynMemo without highlighter

[close]

https://www.heidisql.com/

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 191383
  • Ohne Input kein Output
    • DVB-Cube
DBeaver 22.0.3
« Antwort #1511 am: 17 April, 2022, 22:34 »
Changelog

    Data transfer:
        “Append to existing file” feature was improved (for CSV, TXT and XLSX formats)
        Export wizard now loads saved properties on demand
        Export of result set with reordered/hidden columns was fixed
        Export in SQL format: “split on multiple files” now works correctly
        Task execution notification was improved
        SQL script tasks support was fixed (NullPointer error was resolved)
        Export of many tables into a single target table was fixed
        Import from CSV was fixed (problem with null handling was resolved)
        Trim whitespaces option was added for CSV import
        Table columns mapping UI was fixed on MacOS
    SQL editor:
        Error position information was added in error messages
        Query error highlighting was improved
    Database navigator:
        Support of databases with bug number of schemas was improved
        Column grouping now shows number of grouped elements
        Auto-completion was improved in properties editor
    General:
        DBeaver now shows EULA on start (one time)
        Problem with workspaces on network paths was resolved
        Kerberos configuration load was fixed on RHEL
    Apache Phoenix: connectivity problem was fixed by setting proper driver version
    CockroachDB: ROWID columns support was added
    DB2 i:
        Sequences support was added
        View definitions read was implemented
        Unique and check constraints support was added
        Multiple minor improvements in metadata read were added
    Exasol: search in view/procedure source code was implemented
    MySQL: problem with table lock during database dump was fixed
    Oracle: View source code edit was fixed (problem with view comments was resolved)
    PostgreSQL:
        pg_dump and pg_restore version was upgraded (to PG 14)
        Script execute task now shows all script errors
    Snowflake: support of LIMIT for custom SQL queries was added (affects performance)
    Italian localization was significantly improved (thanks to @capitanfuturo)

[close]

https://dbeaver.io/

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 191383
  • Ohne Input kein Output
    • DVB-Cube
Metabase 0.43.0 RC 1
« Antwort #1512 am: 19 April, 2022, 05:45 »
Changelog

    Enhancements:

    [Epic] Give users a chill and useful starting page (#21322)
    [Epic] Reduce waiting cost in slow dashboards (#21247)
    Admin troubleshooting page changes (#21206)
    Timeline event modal does not show selected icon (#20932)
    Creating a new dashboard from the New button in a collection should take me to that dashboard (#20638)
    [Epic] Sync multiple schemas, with controls (#20609)
    [Epic] Rethink Starting Points (Homepage and Collections) (#20605)
    Upgrade Liquibase (#20600)
    "SQL Query" in UI for MongoDB/Druid/GA native queries (#20499)
    Replace Clojure-land data migrations with Liquibase migrations (#20449)
    [Epic] Mention advanced permissions features in OSS edition (#20398)
    [Epic] General permissions (#20397)

    Bug fixes:

    Converting time series from GUI to SQL can cause frontend reload in some cases (#21615)
    Custom Expression validator too strict when field name is the same as a function (#21513)
    Pie chart series are not displayed correctly in the config (using timestamp instead of short date) (#21504)
    POST firing on each keystroke when changing series display name on cumulative calculations (#21452)
    Some strings not being translated in setup page (#21404)
    Setup should automatically detect locale and translate the UI (#21403)
    Dropdown filter list does not allow filtering for the FK remapped value (#21382)
    Superfluous stack traces logged when database does not have SSL support (#21278)
    Send email fails when <10 items rendered as table and custom (verbose) logging level (#21166)
    Combining question modal does not wrap long question names (#21056)
    Save fails on a question started from the new collection "New..." menu from Our Analytics (#21055)
    Native query preview overflow window when there are no space (#21018)
    Embedding Preview of questions does not limit the results in visualization, which can freeze the browser (#20938)
    Subdimensions/binnings do not exist for time column (#20882)
    Bad Field Filter references can cause the question to fail to load (#20865)
    Static visualization ignores granularity in X-axis ticks in some cases (#20807)
    Default timeline's icon is not used for new events (#20597)
    Restricting and unrestricting access to a table results in the DB-level permission still being "Granular" (#20436)

[close]

https://www.metabase.com/

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 191383
  • Ohne Input kein Output
    • DVB-Cube
Jailer 12.3
« Antwort #1513 am: 20 April, 2022, 20:10 »
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:>>

Logging has been migrated to SLF4J, with log4j2 2.17.2 as the logging framework.

http://jailer.sourceforge.net/

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 191383
  • Ohne Input kein Output
    • DVB-Cube
Database .NET 34.0.8148
« Antwort #1514 am: 23 April, 2022, 10:40 »
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


- Main program update ( Main ):
   Add: Support Firebird Read-Only Mode (8148)
   Upd: Improve object parsing when quote identifiers contain . exception characters (8148)
   Upd: If the position of the window exceeds the current screen after startup, it will be automatically corrected to prevent the same setting from being abnormal in different display environments (8148)
   Upd: Transaction Mode : Fixed and improved initial command handling (8148)
   Upd: Others include cumulative minor updates, corrections and optimizations (8148)
- SQL Editor ( SQL Editor ):
   Upd: (SQL Server/SQL Azure) Automatically jump to wrong column (or position): Added support for Microsoft.Data.SqlClient (8148)
- Form Editor ( Form Editor ):
   Upd: Added column comment display (8148)
- Table Designer ( Table Designer ):
   Add: DragDrop Support (8148)
   Fix: Fixed the problem that the cache is not updated synchronously after the field is changed (including the object browsing delete and renaming fields) (8148)
- Index Designer :
   Add: DragDrop Support (8148)
   Upd: Added processing default index name will automatically include the selected field name (8148)
- Object Explorer :
   Upd: (ODBC/OleDB) Object names are displayed and sorted according to SCHEMA.OBJECT (8148)
- Filtering Objects :
   Upd: (ODBC/OleDB) Object filter will include structure description name (SCHEMA.OBJECT)(8148)
- Database Tools:
   Upd: (Firebird) Update backup and restore processing, and support interrupt processing (8148)
   Upd: (Firebird 3+) Rewrite the database compression process, support remote database, support interruption and improve processing speed (8148)
- Database Migration (Pro):
   Upd: All updates with dbMigration .NET Software(8148)

[close]

http://fishcodelib.com/Database.htm

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )