UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Azure Postgresql    
 
   
nvogel
post May 15 2020, 12:18 PM
Post#1



Posts: 1,119
Joined: 26-January 14
From: London, UK


Just in case anyone hasn't seen it, Microsoft offers Postgres (both the standard product and their MPP implementation) at prices that seem to compare favourably with AWS's pricing. Has anyone tried it?

https://azure.microsoft.com/services/postgresql/
Go to the top of the page
 
FrankRuperto
post May 15 2020, 03:34 PM
Post#2



Posts: 1,099
Joined: 21-September 14
From: Tampa, Florida USA


Never tried the cloud version, but we're on our 4th year using the free version installed on our localhost Linux server. I don't recommend the free Windows version of PostgreSQL, as it has not received much love from the open community. The free Linux version is solid, and has no limits on processor cores, threads, users or db size: https://www.postgresql.org/

It's no biggie to localhost a PostgreSQL, (a/k/a "pg") backend on Linux. Like every other db server, you setup the TCP listener ports and use ODBC to link Access FE's to the pg backend. Free open SAMBA is used for Windows/Linux interop that seamlessly integrates Linux Servers with Windows Desktops into Active Directory environments: https://www.samba.org/
This post has been edited by FrankRuperto: May 15 2020, 04:14 PM
Attached File(s)
Attached File  HybridAccessWeb.PNG ( 183.12K )Number of downloads: 6
 

--------------------
Currently supporting pawnbrokers that use my store management system developed with Access 2010 on Windows7. Experienced with Informix, Oracle & PostgreSQL db's.
Go to the top of the page
 
nvogel
post May 15 2020, 04:02 PM
Post#3



Posts: 1,119
Joined: 26-January 14
From: London, UK


I'm a fan of PostgreSQL, I just haven't tried the Azure version. In fact I wasn't actually aware of it until this year.
Go to the top of the page
 
FrankRuperto
post May 18 2020, 11:03 AM
Post#4



Posts: 1,099
Joined: 21-September 14
From: Tampa, Florida USA


If I were to cloud host postgres I would use AWS or even better, an independent host, as they're less expensive than Azure or AWS and work just as well for most situations.

--------------------
Currently supporting pawnbrokers that use my store management system developed with Access 2010 on Windows7. Experienced with Informix, Oracle & PostgreSQL db's.
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    5th July 2020 - 06:20 AM