{"id":49,"date":"2026-03-14T18:19:39","date_gmt":"2026-03-14T18:19:39","guid":{"rendered":"https:\/\/germany.latinai.de\/?page_id=49"},"modified":"2026-03-14T18:19:39","modified_gmt":"2026-03-14T18:19:39","slug":"sophiadb","status":"publish","type":"page","link":"https:\/\/latinai.de\/?page_id=49","title":{"rendered":"SophiaDB"},"content":{"rendered":"\n<iframe loading=\"lazy\" width=\"560\" height=\"315\" src=\"https:\/\/www.youtube-nocookie.com\/embed\/Tu8hkhTlNUE?si=dJeM5Oihn59w-KHO\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n\n\n\n<p class=\"wp-block-paragraph\">SophiaDB \u2013 The modern, portable MySQL\u2011compatible database<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>SophiaDB<\/strong>&nbsp;is a lightweight, cross\u2011platform SQL database that combines MySQL compatibility with a modern architecture, built\u2011in security, and maximum portability.<br>Buy once, use forever \u2014 no subscriptions, no paywalls, no artificial limitations.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Why SophiaDB?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SophiaDB is designed for developers, DevOps teams, and companies that need a reliable, secure, and easy\u2011to\u2011deploy database \u2014 without the complexity of traditional SQL servers and without expensive enterprise licenses.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Key Features<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>MySQL Compatibility (approx. 70% coverage)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SophiaDB supports most of the MySQL syntax and behaves like a familiar MySQL server \u2014 ideal for existing projects, tools, and workflows.<br>The engine is compatible with:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Standard SQL<\/li>\n\n\n\n<li>MySQL DML and DDL<\/li>\n\n\n\n<li>MySQL Shell client<\/li>\n\n\n\n<li>MySQL\u2011like data types and table structures<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\u00a0<strong>MySQL Shell Support<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SophiaDB can be accessed directly using the MySQL Shell (<code>mysqlsh<\/code>).<br>This means:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Autocomplete<\/li>\n\n\n\n<li>Command history<\/li>\n\n\n\n<li>Multi\u2011line SQL<\/li>\n\n\n\n<li>Scripting<\/li>\n\n\n\n<li>A familiar developer experience<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">No additional tools, no configuration required.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Integrated SSH SQL Server<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SophiaDB includes its own SSH server that provides an interactive SQL shell \u2014 without any external clients.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Connect directly via SSH<\/li>\n\n\n\n<li>Execute SQL instantly<\/li>\n\n\n\n<li>No ports to expose<\/li>\n\n\n\n<li>No client installation<\/li>\n\n\n\n<li>Perfect for DevOps, remote servers, and edge devices<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\u00a0<strong>Server\u2011Side Encryption (SSE)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SophiaDB encrypts data transparently on the server \u2014 without plugins and without enterprise licensing.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>AES\u2011256 encryption<\/li>\n\n\n\n<li>Master key fingerprint<\/li>\n\n\n\n<li>Full table\u2011level encryption<\/li>\n\n\n\n<li>Automatic encryption and decryption<\/li>\n\n\n\n<li>Integrated encryption status checker<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Enterprise\u2011grade security without enterprise\u2011grade costs.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Portable binaries for all platforms<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SophiaDB runs everywhere \u2014 no installation, no dependencies.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Windows (amd64, arm64)<\/li>\n\n\n\n<li>Linux (amd64, arm64)<\/li>\n\n\n\n<li>macOS (Intel &amp; Apple Silicon)\u00b3<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">A single binary per platform.<br>Start it and you\u2019re ready to go.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00a0<strong>Zero\u2011Install, Zero\u2011Config<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SophiaDB is ready to use immediately:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>No installers<\/li>\n\n\n\n<li>No registry entries<\/li>\n\n\n\n<li>No system services<\/li>\n\n\n\n<li>No configuration required<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Ideal for:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Local development<\/li>\n\n\n\n<li>Portable tools<\/li>\n\n\n\n<li>Containers<\/li>\n\n\n\n<li>Embedded systems<\/li>\n\n\n\n<li>Offline environments<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\u00a0<strong>Buy once \u2014 use forever<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SophiaDB follows a clear philosophy:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>One\u2011time purchase. All features\u00b9. All updates. Forever.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">No subscriptions.<br>No enterprise paywalls.<br>No artificial limitations.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Who is SophiaDB for?<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Developers looking for a portable MySQL alternative<\/li>\n\n\n\n<li>Startups avoiding expensive enterprise licenses<\/li>\n\n\n\n<li>DevOps teams who love SSH\u2011based SQL access<\/li>\n\n\n\n<li>Embedded and edge computing environments<\/li>\n\n\n\n<li>Security\u2011focused projects requiring SSE<\/li>\n\n\n\n<li>Companies needing a simple, reliable SQL engine<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>In short<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>SophiaDB<\/strong>&nbsp;is a modern, secure, and portable SQL database that combines MySQL compatibility with built\u2011in encryption, SSH access, and a one\u2011time pricing model.<br>A tool that feels like MySQL \u2014 but lighter, safer\u00b2, and fairer.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Platform support includes, but is not limited to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Windows 10<\/li>\n\n\n\n<li>Windows 11<\/li>\n\n\n\n<li>Linux<\/li>\n\n\n\n<li>macOS<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Minimum Hardware requirements:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Windows 10 \/ Linux<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Intel\u00ae Celeron\u00ae 7305L\n<ul class=\"wp-block-list\">\n<li>1 GB LPDDR5\/LPDDR4x RAM<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>AMD\u00ae Phenom II X6 1090T\n<ul class=\"wp-block-list\">\n<li>1 GB DDR3\/DDR2 RAM<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>4 GB disk space<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>macOS<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Intel\u00ae Mac (2012 or newer) with macOS 10.15+<br><em>e.g., Intel Core i5\u20113210M or better<\/em><\/li>\n\n\n\n<li>or Apple Silicon (M1 or newer)<\/li>\n\n\n\n<li>4 GB RAM<\/li>\n\n\n\n<li>4 GB disk space<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Recommended minimum:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Debian<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Intel\u00ae i7-77ooK<\/li>\n\n\n\n<li>16 GB DDR4 RAM<\/li>\n\n\n\n<li>4 TB Disk space<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Windows 11<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Intel\u00ae i9-10900K<\/li>\n\n\n\n<li>32 GB DDR4 RAM<\/li>\n\n\n\n<li>4.5 TB Disk space<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>MacOS<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Not recommended<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u00b9 There is no guarantee for future updates. The product may be discontinued at any time.<br>\u00b2 We take no responsibility for security violations\/issues.<br>\u00b3 Darwin\/MacOS support not guaranteed nor tested. Using it with MacOS is generally not recommended.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Usage:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">No arguments<br>start as regular SQL server on Port 3306, like MySQL<br>-check-encryption<br>inspect bbolt and report encryption status and exit<br>-create-user string -password string<br>create a new user (username)<br>-db string<br>path to bbolt database file (default \u201cdata.db\u201d)<br>-key string<br>path to master key file (default \u201cmaster.key\u201d)<br>-mysql_auth_server_static_file string<br>JSON File to read the users\/passwords from.<br>-mysql_auth_server_static_string string<br>JSON representation of the users\/passwords config.<br>-mysql_auth_static_reload_interval duration<br>Ticker to reload credentials<br>-mysql_clientcert_auth_method string<br>client-side authentication method to use. Supported values: mysql_clear_password, dialog. (default \u201cmysql_clear_password\u201d)<br>-ssh<br>enable SSH shell access (SophiaDB will not listen to regular SQL connections on Port 3306)<br>-ssh-port int<br>SSH listen port (default 2222)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SophiaDB \u2013 The modern, portable MySQL\u2011compatible database SophiaDB&nbsp;is a lightweight, cross\u2011platform SQL database that combines MySQL compatibility with a modern architecture, built\u2011in security, and maximum portability.Buy once, use forever \u2014 no subscriptions, no paywalls, no artificial limitations. Why SophiaDB? SophiaDB is designed for developers, DevOps teams, and companies that need a reliable, secure, and easy\u2011to\u2011deploy&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","footnotes":""},"class_list":["post-49","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/latinai.de\/index.php?rest_route=\/wp\/v2\/pages\/49","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/latinai.de\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/latinai.de\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/latinai.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/latinai.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=49"}],"version-history":[{"count":1,"href":"https:\/\/latinai.de\/index.php?rest_route=\/wp\/v2\/pages\/49\/revisions"}],"predecessor-version":[{"id":51,"href":"https:\/\/latinai.de\/index.php?rest_route=\/wp\/v2\/pages\/49\/revisions\/51"}],"wp:attachment":[{"href":"https:\/\/latinai.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=49"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}