Jeff Gibson 0 Posted 16 hours ago I'm reaching out to get some opinions on "On Prem" database environments. I've got over 30 years experience working in the Sybase SQL Anywhere database environment. SQL Anywhere was an extremely powerful database to use in small on prem applications. SAP takes over and, well, you know the rest. They forgot they bought a tools company. I'm looking for a solid/scalable database that can scale from a single machine to cloud. And frankly, I'm thinking more for smaller subsets. I know that I can go MySQL. PostgreSQL. But I'm wanting to know what this community thinks. SQLA used a T-SQL dialect, so I'm wanting to steer that way. Thoughts? Would love to be able to run this on mobile devices as well. Thanks in advance for any thoughts and opinions. There are no wrong answers. :) Jeff Gibson Nashville, TN Share this post Link to post
Pat Heuvel 1 Posted 12 hours ago I'm advocating for PostgreSQL. Yes, you'll need to learn a new language to replace T-SQL (although you do have choices), but it's a very solid database with great features (including documentation) and a wealth of skills online to take any questions or concerns. Share this post Link to post
MichaelT 7 Posted 9 hours ago Allow me to redefine your question and give the answer. There is noch such thing as a multi user enabled Personal Oracle 8, the one with the traffic lights shipped in the 1990s. From a technical perspective the most close candidate would be the Mimer DB or SQL Server as well as Firebird or Interbase. No idea if Apollo, NexusDB or Elevate DB and such things remein as an applicable choices for you, but I doubt in a first place. MaxDB/SAP DB from SAP would have been a pretty similar choice, just for the records and to a certain extent DB2 for the records as well. I'm assuming that you are using Delphi as the development tool of choice, otherwise you wouldn't ask here. I'd go for PostgreSQL, because PostgreSQL does away with many glitches of the Oracle PL/SQL Language and handling it's own history concerning programming. There exist already too many flavors of 8i style programming, 9i, 10i, 11i style and so on. I think such a makeshift/provisional solution can last long. There is no need to mimic the stored procedure language while debugging. I have chosen for Firebird or Maria DB but I personally don't put business logic into the DB anymore, even if I think it's not a bad practice at all and a pretty flexible approach still. In the end it's about having the information model constraints and extended business logic in one place and a consistent backup. Share this post Link to post
Dorian C 0 Posted 9 hours ago (edited) Using MS Sql Server 2012 free with dbGo (migrated from Ms Access), for more than 8 years with great success for small companies (for accounting and medical software). Not a single file corrupted! Scale perfect from LocalDB - monousers (with automatic installer), to Express edition for remote, but no experience with cloud now. Simple to install and maintain. Worked with success in the past also with Firebird, but they don't have automatic management of versions installed and instances for server like MS Sql Server. In case of migration to .net, the support is exceptional with linq, entity framework, dapper. Edited 9 hours ago by Dorian C Share this post Link to post
Die Holländer 79 Posted 8 hours ago (edited) 1 hour ago, Dorian C said: but no experience with cloud now. Simple to install and maintain. I use Azure cloud with MSSQL (free edition), FireDac and works great. I pay about 5 Euro per month. Very nice is it's Database Management Studio. Edited 8 hours ago by Die Holländer Share this post Link to post
Lars Fosdal 1827 Posted 7 hours ago 9 minutes ago, Die Holländer said: I use Azure cloud with MSSQL (free edition), FireDac and works great. I pay about 5 Euro per month. Is there a limit on usage at that price? Can a DB there be accessed from multiple concurrent instances of your app? Share this post Link to post
Die Holländer 79 Posted 6 hours ago 44 minutes ago, Lars Fosdal said: Is there a limit on usage at that price? Can a DB there be accessed from multiple concurrent instances of your app? Deploy Azure SQL Database for free We access the database with a limit number of users (3-5) and I don't know if this is limited. 1 Share this post Link to post
Die Holländer 79 Posted 6 hours ago and now you want to Create Delphi Azure functions with Azure SQL database (Delphi webbroker app) Getting Started with Azure Cloud Development with Delphi But I didn't find the proper solution (configuration..) Share this post Link to post
Lars Fosdal 1827 Posted 5 hours ago TBH, I prefer C# for Azure functions. Share this post Link to post
Roger Cigol 125 Posted 4 hours ago I use PostgreSQL and all seems good to me. Share this post Link to post
VLDG 1 Posted 40 minutes ago I use MySQL with MyDAC and Firebird with FireDAC. I prefer Firebird. Share this post Link to post