{"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":"http:\/\/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=\"http:\/\/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":[],"_links":{"self":[{"href":"http:\/\/www.desiderata.com.au\/blog\/index.php?rest_route=\/wp\/v2\/pages\/81","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.desiderata.com.au\/blog\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/www.desiderata.com.au\/blog\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/www.desiderata.com.au\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.desiderata.com.au\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=81"}],"version-history":[{"count":2,"href":"http:\/\/www.desiderata.com.au\/blog\/index.php?rest_route=\/wp\/v2\/pages\/81\/revisions"}],"predecessor-version":[{"id":85,"href":"http:\/\/www.desiderata.com.au\/blog\/index.php?rest_route=\/wp\/v2\/pages\/81\/revisions\/85"}],"wp:attachment":[{"href":"http:\/\/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}]}}