The Post 1 is for download from Torrent, i put to download directly from delphi.
A few months after the release, Embarcadero has just made available InterBase 2017 Update 1. If you are an existing InterBase user, this is a nice update the install, given it has some performance improvements, bug fixes, and new features, as explained in the announcement article I just publsihed at:InterBase is a great embedded database, and the IBLite/IBToGo versions come included with RAD Studio for all supported platforms (desktop and mibile). The Windows developer edition of the full RDMBS (a fast, hassle free, fully powered SQL engine) is also included in RAD Studio and helps power the RAD Server database. Not only InterBase is on par with most competing (and often more expensive) solution, but it has unique features like ChangeViews that can be leveraged to greatly optimize the data traffic, something even more important in today's mobile and distributed world.While RAD Studio Tokyo ships with the previous version, InterBase XE7, the InterBase 2017 versions of the developer server and IBLite/IBToGo are available in GetIt - currently still the original release, Udpate 1 will be made available early next week. Read the linked article above for current download links and more information on this version of InterBase.posted by@. InterBase 2017 Update 1 and DelphiNot only InterBase is on par with most competing (andoften more expensive)solutionWhich solutions would those be? Interbase is about $7KUSD for the unlimited users version.
I can't think ofmore expensive RDBMSes other than DB2, SQL Server andOracle. PostgreSQL is free and absolutely nothingadded in Interbase 2017 wasn't already present inPostgreSQL. For instance, the addition of Common TableExpressions (CTEs) was most appreciated, butPostgreSQL had them 8 years previously.
In addition,the 'recursive' keyword was reserved for CTEs, but thefunctionality was not implemented yet. PG has therecursive functionality. Even worse, expressionindexes were present in PostgreSQL since at leastversion 8.1, which was released 12 years ago!Interbase lacks many modern (and not so modern) SQLfeatures.
The timestamp data type, for instance,doesn't even store a time zone.:-( There is no seriestype, decimal precision and scale is limited to 18 (inPG it's 131,072 before the decimal point and 16,383after!), varchar is limited to 32K, no spatial typesfor GIS, no enums, no JSON type, no support for XML,no full text search, no range types, no custom definedtypes, no ability to directly run procedures writtenin other languages, no parallel query support, nopartitioning support, no compression support, nowindowing functions, etc. Given this, I'm leftwondering what.mainstream. database solutions youthink Interbase is competitive with (I know there area lot of obscure Delphi-only databases with limitedfunctionality, but they're also not priced anywherenear Interbase).Comment by Joseph on October 2, 04:24. InterBase 2017 Update 1 and DelphiJoseph,each tool has strengths and weaknesses, InterBase has uniquefeatures like change views, a very small footprint including on deviceinstallation with the same binary compatible DB file, extensiveencryption support, just to name a few. Anyway, while some of theitems you list as missing are correct, others I think are available.If you compare the price with open source solutions, anything is moreexpensive. InterBase is free for local DB with no encryption, and theprice depends on the users - not everyone needs unlimited users.There are still quite a few database engines that are paid (and oftenalso very expensive, including those you mention), so the factInterBase isn't free should not be a surprise - I know it was once,long story.Comment by Marco Cantuon October 3, 12:47Post Your CommentClickyour feedback to this blog.There are currently 0 pending (unapproved) messages.