Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

HeidiSQL 11.0 with SQLite support

ansgar's profile image ansgar posted 10 months ago in Anouncements Permalink

Grab it from the download page

New features and enhancements in this version:

  • Support connecting to SQLite database files
  • drop schema support for PostgreSQL
  • support foreign keys in PostgreSQL
  • support foreign keys in MS SQL
  • read-only mode for grid cell editors, if underlying query or table does not allow updates
  • support scram-sha-256 authentication on PostgreSQL
  • enhanced readability of release notes
  • enhanced readability of help links with dark themes
  • support column comments of PostgreSQL
  • support disabling "Full table status" on PostgreSQL
  • new filter edit box on session manager, for filtering sessions using regular expressions
  • close query tabs via middle mouse click
  • trim text in various text inputs of session manager, to prevent leading and trailing spaces after pasting
  • sort collation drop down on "Bulk table editor" alphabetically
  • place icons on the 3 new/save/delete buttons on the session manager, to make them more noticeable
  • performance: use first 1000 rows only for calculating the CSV export size, and interpolate the rest.
  • widen buttons on search/replace dialog by one quarter, so translations fit better on them
  • use default library of given network type in command line receiver
  • refreshed application icon

Bugfixes:

  • fix crashes when restoring tabs: expect no UTF-8 BOM
  • Procedure body changes invisible when parameter tab is active
  • last active session was no longer scrolled into view area of session manager
  • crash when mouse moves over data grid with broken connection
  • clicking too fast on session folder opens connection instead of collapse
  • passphrase input for SSH tunnel now masked
  • detect columns from PG table keys only in current schema, do not mix these with columns from an equally named table in a different schema
  • fix crash when accessing data from data tab on a disconnected session
  • fix crash when active main tab changes and data grid is disabled (due to disconnect)
  • make copy/cut safer against harmless crashes, and show occurring error messages in log panel
  • MSSQL: Remove surrounding parentheses from default value
  • fix state of checkboxes on the session manager's Advanced tab
  • fix crash by click on "Add column" in table editor, when columns list has a minimum height

Third party libraries and components:

  • update libmariadb.dll to v3.1.7
  • update libpq.dll to v10.0.11
  • introduce additional libpq.dll v12.0.1
  • update InnoSetup compiler to v6.0.3
  • update VirtualTree component to v7.3
  • introduce sqlite3.dll v3.30.1

Complete change list: https://github.com/HeidiSQL/HeidiSQL/milestone/4?closed=1

yaec's profile image yaec posted 9 months ago Permalink

thanks

Horus Sirius's profile image Horus Sirius posted 9 months ago Permalink

thanks

wmezasoria's profile image wmezasoria posted 7 months ago Permalink

awesome...one step more to ms sql compliant..great job!!!

mrforsythexeter's profile image mrforsythexeter posted 5 months ago Permalink

Is there an ability to create a new sqlite3 database from within heidi?

ansgar's profile image ansgar posted 5 months ago Permalink

Yes, you can create a new session with a non existent database file. HeidiSQL will just create it when you connect to it.

Also, in a connected session, you can click "Attach database", and point to a not yet existing filename: Description

Same here: HeidiSQL will just create that file.

Note that a new SQLite database file is just an empty file.

coolcurrent's profile image coolcurrent posted 2 weeks ago Permalink

I cannot set a password the SQLite database, it is encrypted

1 attachment(s):
  • 2021-01-04_162125
ansgar's profile image ansgar posted 2 weeks ago Permalink

Yes, HeidiSQL does not yet support authentication for a SQLite database. Adding support for a login will require changes to HeidiSQL itself, and probably a different sqlite3.dll than the one shipped with Heidi.

I just read about authentication on sqlite.org and ran some tests here, but it seems sqlite3.dll does not provide the required sqlite3_user_authenticate interface.

Feel free to shed some light on SQLite authentication here.

ansgar's profile image ansgar posted 2 weeks ago Permalink

@coolcurrent I got a hint with precompiled binaries containing that sqlite3_user_authenticate on https://github.com/utelle/SQLite3MultipleCiphers

If you file a feature request, I will have a look how to implement that authentication.

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.