@PGSQLforMac profile picture
PostgreSQL for Mac @PGSQLforMac

PostgreSQL for Mac Project, an ongoing effort to create tools, distributions and documentation for best leveraging the PostgreSQL RDMS on the Mac and iOS.

Joined April 2011
  • Tweets 241
  • Following 1
  • Followers 113
Photos and videos
Inching closer to a release of PGSQLSwift, a ground up rewrite of our old PGSQLKit Objective C access library in Swift adopting modern Swift syntax and designs. Todays milestone, passing 78 / 78 unit tests.
Well, progress is moving right along. A new version of PGSQLKit is in the works, completely rewritten in Swift. The first milestone has been reached: It connects, runs commands, and returns results. Next, complete the interfaces before enhancements
PostgreSQL on the Mac - Value Question? Is there enough value in supporting back to 10.14 or just going 12.0 and moving on? ( leaning towards 12, simply because the tool chain to properly support older versions in mixed version binaries is kinda painful )
Well, after a LONG time of neglect, I am finally free enough from day job obligations to circle back to my PostgreSQL for Mac work. Build scripts updated to build a universal binary. Done. Updated universal builds of PGSQLKit.framework. Done. New installer. In process.
While MS and T-SQL may have a really robust stored procedure environment, PostgreSQL remains the better complete toolkit.
Dealing with system level services in a UX on the Mac is a maze of security and interprocess communication that is a headache. A valuable one, but still a headache.. #workmarcheson
Swift is a great language with a steep unlearning curve…
MacOS PostgreSQL Distro’s? EDB, Postgres.app, HomeBrew, Ports, Fink. What are we missing?
PostgreSQL on Apple Silicon works quite well in case you wondered. Yes, all of our work is being done with M1 and beyond in mind.
Well after an educational weekend, work is underway to revamp the PG4Mac tools to support any PG distro using a modern Swift environment. This should be a LOT of fun.
Upon further inspection, the framework is built and working but only when referencing libpq.dylib, and not libpq.a. More research required.
PGSQLKit Framework updated and rebuilt for use on Apple Silicon is coming this week. ( If anyone is still interested ) Universal Version being tested as this is posted.
In case you are wondering…. Yes, we are briging PGSQLKit to Apple Silicon. Initial work is done, and it works. Refining some details surrounding OpenSSH support in the connection, and then we will release.
2
Yes. We are planning to make any needed updates to have ARM support ASAP.
1
2
With PostgreSQL and Docker, is there value in maintaining a Mac specific installation anymore?
1
The battle of what I want to do (work on my PostgreSQL desktop tools) versus what I need to do (work on paying code against MSSQL data).
There are days when you wish you could change the world. Today, I’d settle for not having to use MSSQL.
1
biggest challenge recreating PGSQLKit in Swift? keeping it platform neutral
I really like Swift as a language, but man the syntax is annoying at times. PostgreSQL Swift interfaces coming along though.
1
Thinking about rebooting our Postgres on Mac work with full rewrite in Swift and a rethink about how we integrate to the OS. Your thoughts?
1
Load more