{"id":81,"date":"2009-06-12T01:27:08","date_gmt":"2009-06-11T15:27:08","guid":{"rendered":"http:\/\/www.desiderata.com.au\/blog\/?page_id=81"},"modified":"2009-06-12T01:27:08","modified_gmt":"2009-06-11T15:27:08","slug":"blackfish-sql","status":"publish","type":"page","link":"https:\/\/www.desiderata.com.au\/blog\/?page_id=81","title":{"rendered":"Blackfish SQL"},"content":{"rendered":"<p><strong>Information relating to Blackfish SQL database.<\/strong><\/p>\n<p><a href=\"http:\/\/www.embarcadero.com\/products\/blackfish_sql\/\">Embarcadero&#8217;s web page on Blackfish SQL<\/a><\/p>\n<p>Blackfish SQL is a high-performance, small-footprint (1.3Mb .NET 2.0 assembly), SQL-92 compliant transactional database that runs on both .NET framework and the Java platform, with database files compatible between the two platforms.<\/p>\n<p>Blackfish SQL for .NET 2.0 is fully integrated with CodeGear RAD Studio, Delphi, C++Builder and Delphi Prism and supports stored procedures written in the Delphi, C#, VB or Delphi Prism languages (but not SQL as with Interbase).<\/p>\n<ul>\n<li>Architect and Enterprise editions of the IDEs include unlimited Blackfish SQL database desktop or server deployment on systems with up to 5 users \/ 20 connections (max. 4 connections per user), and support for databases up to 2GB and RAM cache limit of 1Gb<\/li>\n<li>Professional editions of the IDEs include unlimited Blackfish SQL desktop database deployment on systems with 1 local user \/ 4 connections, and support for databases up to 512 MB and RAM cache limit of 512Mb. Thus no remote server licence!<\/li>\n<li>additional licenses available for single deployments of 1, 5, 10, 25, or unlimited users<\/li>\n<li>Blackfish SQL RAD Studio Edition licensing supports multi-core CPUs<\/li>\n<li>deployment requires copying the assembly file and licence file to destination server &#8211; no installer or configuration needed<\/li>\n<li>dbExpress 4 drivers for Win32 Delphi and C++<\/li>\n<li>ADO.NET 2.0 providers for .NET- ideal for hosted ASP.NET apps as very easy to deploy<\/li>\n<li>JDBC for Java<\/li>\n<li>JavaBeans data access components for Java<\/li>\n<li>XA\/JTA Distributed transactions for Java<\/li>\n<li>Unicode storage of character data<\/li>\n<li>Unicode-based collation key support for sorting and indexing<\/li>\n<li>can be run as a Windows Service, as a standalone server or as an inprocess, embedded database<\/li>\n<li>Zero-administration, single assembly or single-jar deployment<\/li>\n<li>automatic crash recovery<\/li>\n<li>SQL-based security with support for roles<\/li>\n<li>Database incremental backup and failover<\/li>\n<li>BUT .NET version does not support mirroring or failover clustering according to <a href=\"http:\/\/www.embarcadero.com\/products\/blackfish_sql\/faq.php\">faq<\/a>, whereas java version and Interbase do<\/li>\n<\/ul>\n<p><strong>Compared to mySQL:<\/strong><\/p>\n<ul>\n<li>MySQL is not always free. It might be for you. It depends on how you deploy it.<\/li>\n<li>Blackfish SQL is not always free, but for small deployments on .Net it is.<\/li>\n<li>Blackfish SQL requires .Net 2.0 or higher,\u00a0 or Java for the database. MySQL is native.<\/li>\n<li>Blackfish SQL has native stored procedures. That means you can write them in pure Java or any .Net application that generates an assembly.<\/li>\n<li>Blackfish SQL is easy to deploy\/redeploy on web hosted environments.<\/li>\n<li><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Information relating to Blackfish SQL database. Embarcadero&#8217;s web page on Blackfish SQL Blackfish SQL is a high-performance, small-footprint (1.3Mb .NET 2.0 assembly), SQL-92 compliant transactional database that runs on both .NET framework and the Java platform, with database files compatible &hellip; <a href=\"https:\/\/www.desiderata.com.au\/blog\/?page_id=81\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-81","page","type-page","status-publish","hentry"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.4 - aioseo.com -->\n\t<meta name=\"description\" content=\"Information relating to Blackfish SQL database. Embarcadero&#039;s web page on Blackfish SQL Blackfish SQL is a high-performance, small-footprint (1.3Mb .NET 2.0 assembly), SQL-92 compliant transactional database that runs on both .NET framework and the Java platform, with database files compatible between the two platforms. Blackfish SQL for .NET 2.0 is fully integrated with CodeGear RAD\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.desiderata.com.au\/blog\/?page_id=81\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.4\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Desiderata software\u00ae and consultancy blog | specialising in clinical database solutions for Australian hospitals\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Blackfish SQL | Desiderata software\u00ae and consultancy blog\" \/>\n\t\t<meta property=\"og:description\" content=\"Information relating to Blackfish SQL database. Embarcadero&#039;s web page on Blackfish SQL Blackfish SQL is a high-performance, small-footprint (1.3Mb .NET 2.0 assembly), SQL-92 compliant transactional database that runs on both .NET framework and the Java platform, with database files compatible between the two platforms. Blackfish SQL for .NET 2.0 is fully integrated with CodeGear RAD\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.desiderata.com.au\/blog\/?page_id=81\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2009-06-11T15:27:08+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2009-06-11T15:27:08+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Blackfish SQL | Desiderata software\u00ae and consultancy blog\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Information relating to Blackfish SQL database. Embarcadero&#039;s web page on Blackfish SQL Blackfish SQL is a high-performance, small-footprint (1.3Mb .NET 2.0 assembly), SQL-92 compliant transactional database that runs on both .NET framework and the Java platform, with database files compatible between the two platforms. Blackfish SQL for .NET 2.0 is fully integrated with CodeGear RAD\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.desiderata.com.au\\\/blog\\\/?page_id=81#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.desiderata.com.au\\\/blog\\\/#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.desiderata.com.au\\\/blog\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.desiderata.com.au\\\/blog\\\/?page_id=81#listItem\",\"name\":\"Blackfish SQL\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.desiderata.com.au\\\/blog\\\/?page_id=81#listItem\",\"position\":2,\"name\":\"Blackfish SQL\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.desiderata.com.au\\\/blog\\\/#listItem\",\"name\":\"Home\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.desiderata.com.au\\\/blog\\\/#organization\",\"name\":\"Desiderata software\\u00ae and consultancy blog\",\"description\":\"specialising in clinical database solutions for Australian hospitals\",\"url\":\"https:\\\/\\\/www.desiderata.com.au\\\/blog\\\/\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.desiderata.com.au\\\/blog\\\/?page_id=81#webpage\",\"url\":\"https:\\\/\\\/www.desiderata.com.au\\\/blog\\\/?page_id=81\",\"name\":\"Blackfish SQL | Desiderata software\\u00ae and consultancy blog\",\"description\":\"Information relating to Blackfish SQL database. Embarcadero's web page on Blackfish SQL Blackfish SQL is a high-performance, small-footprint (1.3Mb .NET 2.0 assembly), SQL-92 compliant transactional database that runs on both .NET framework and the Java platform, with database files compatible between the two platforms. Blackfish SQL for .NET 2.0 is fully integrated with CodeGear RAD\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.desiderata.com.au\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.desiderata.com.au\\\/blog\\\/?page_id=81#breadcrumblist\"},\"datePublished\":\"2009-06-12T01:27:08+10:00\",\"dateModified\":\"2009-06-12T01:27:08+10:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.desiderata.com.au\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.desiderata.com.au\\\/blog\\\/\",\"name\":\"Desiderata software\\u00ae and consultancy blog\",\"description\":\"specialising in clinical database solutions for Australian hospitals\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.desiderata.com.au\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Blackfish SQL | Desiderata software\u00ae and consultancy blog","description":"Information relating to Blackfish SQL database. Embarcadero's web page on Blackfish SQL Blackfish SQL is a high-performance, small-footprint (1.3Mb .NET 2.0 assembly), SQL-92 compliant transactional database that runs on both .NET framework and the Java platform, with database files compatible between the two platforms. Blackfish SQL for .NET 2.0 is fully integrated with CodeGear RAD","canonical_url":"https:\/\/www.desiderata.com.au\/blog\/?page_id=81","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BreadcrumbList","@id":"https:\/\/www.desiderata.com.au\/blog\/?page_id=81#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.desiderata.com.au\/blog\/#listItem","position":1,"name":"Home","item":"https:\/\/www.desiderata.com.au\/blog\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.desiderata.com.au\/blog\/?page_id=81#listItem","name":"Blackfish SQL"}},{"@type":"ListItem","@id":"https:\/\/www.desiderata.com.au\/blog\/?page_id=81#listItem","position":2,"name":"Blackfish SQL","previousItem":{"@type":"ListItem","@id":"https:\/\/www.desiderata.com.au\/blog\/#listItem","name":"Home"}}]},{"@type":"Organization","@id":"https:\/\/www.desiderata.com.au\/blog\/#organization","name":"Desiderata software\u00ae and consultancy blog","description":"specialising in clinical database solutions for Australian hospitals","url":"https:\/\/www.desiderata.com.au\/blog\/"},{"@type":"WebPage","@id":"https:\/\/www.desiderata.com.au\/blog\/?page_id=81#webpage","url":"https:\/\/www.desiderata.com.au\/blog\/?page_id=81","name":"Blackfish SQL | Desiderata software\u00ae and consultancy blog","description":"Information relating to Blackfish SQL database. Embarcadero's web page on Blackfish SQL Blackfish SQL is a high-performance, small-footprint (1.3Mb .NET 2.0 assembly), SQL-92 compliant transactional database that runs on both .NET framework and the Java platform, with database files compatible between the two platforms. Blackfish SQL for .NET 2.0 is fully integrated with CodeGear RAD","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/www.desiderata.com.au\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/www.desiderata.com.au\/blog\/?page_id=81#breadcrumblist"},"datePublished":"2009-06-12T01:27:08+10:00","dateModified":"2009-06-12T01:27:08+10:00"},{"@type":"WebSite","@id":"https:\/\/www.desiderata.com.au\/blog\/#website","url":"https:\/\/www.desiderata.com.au\/blog\/","name":"Desiderata software\u00ae and consultancy blog","description":"specialising in clinical database solutions for Australian hospitals","inLanguage":"en-US","publisher":{"@id":"https:\/\/www.desiderata.com.au\/blog\/#organization"}}]},"og:locale":"en_US","og:site_name":"Desiderata software\u00ae and consultancy blog | specialising in clinical database solutions for Australian hospitals","og:type":"article","og:title":"Blackfish SQL | Desiderata software\u00ae and consultancy blog","og:description":"Information relating to Blackfish SQL database. Embarcadero's web page on Blackfish SQL Blackfish SQL is a high-performance, small-footprint (1.3Mb .NET 2.0 assembly), SQL-92 compliant transactional database that runs on both .NET framework and the Java platform, with database files compatible between the two platforms. Blackfish SQL for .NET 2.0 is fully integrated with CodeGear RAD","og:url":"https:\/\/www.desiderata.com.au\/blog\/?page_id=81","article:published_time":"2009-06-11T15:27:08+00:00","article:modified_time":"2009-06-11T15:27:08+00:00","twitter:card":"summary","twitter:title":"Blackfish SQL | Desiderata software\u00ae and consultancy blog","twitter:description":"Information relating to Blackfish SQL database. Embarcadero's web page on Blackfish SQL Blackfish SQL is a high-performance, small-footprint (1.3Mb .NET 2.0 assembly), SQL-92 compliant transactional database that runs on both .NET framework and the Java platform, with database files compatible between the two platforms. Blackfish SQL for .NET 2.0 is fully integrated with CodeGear RAD"},"aioseo_meta_data":{"post_id":"81","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"WebPage","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"created":"2021-12-06 10:55:31","updated":"2026-10-23 02:55:50","focus_keyword":null,"additional_keywords":null,"truseo_locale":null,"ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.desiderata.com.au\/blog\/\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tBlackfish SQL\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.desiderata.com.au\/blog\/"},{"label":"Blackfish SQL","link":"https:\/\/www.desiderata.com.au\/blog\/?page_id=81"}],"_links":{"self":[{"href":"https:\/\/www.desiderata.com.au\/blog\/index.php?rest_route=\/wp\/v2\/pages\/81","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.desiderata.com.au\/blog\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.desiderata.com.au\/blog\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.desiderata.com.au\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.desiderata.com.au\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=81"}],"version-history":[{"count":2,"href":"https:\/\/www.desiderata.com.au\/blog\/index.php?rest_route=\/wp\/v2\/pages\/81\/revisions"}],"predecessor-version":[{"id":85,"href":"https:\/\/www.desiderata.com.au\/blog\/index.php?rest_route=\/wp\/v2\/pages\/81\/revisions\/85"}],"wp:attachment":[{"href":"https:\/\/www.desiderata.com.au\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=81"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}