DataCloudGaze Consulting

🚀 Announcing pgextensions.org Your guide to PostgreSQL extensions in the cloud. Compare and discover extensions across most of Cloud provider supporting PosstgreSQL Enhance your database decision! 🌐🔍 #PostgreSQL #DatabaseMigration #Extensions

#Oracle → #PostgreSQL Tip 🚨 Extended Statistics. Oracle auto creates them for function-based indexes (e.g. LTRIM(RTRIM(CODE))). If you migrate the index but not the stats, PostgreSQL may choose bad plans → slow queries. Migration isn’t just correctness untill it’s performant!

Built an Oracle-style DBA_OBJECTS for PostgreSQL! Using event triggers, it tracks all DDLs giving DBAs instant visibility into what changed and when. ✅ Tracks DDL ✅ Auto-updates timestamps ✅ Perfect for Oracle → Postgres migrations datacloudgaze.com/post/tracking-… #Oracle #PostgreSQL

Many PostgreSQL adopters (yes,even app devs) still wonder what those mysterious $$ mean in a DO block, function, or procedure. It’s Dollar Quoting→makes handling strings with quotes/special chars cleaner & safer. 👉 Curious? level up your Postgres skills #666bdfd45842dc1c7ed71e42" target="_blank" rel="nofollow noopener">databasegyaan.com/s/preview/cour…

🚀 Meet dcgmigrator – Your first engineer for smarter database migrations! From Oracle/SQL Server to PostgreSQL? DCGMigrator simplifies, accelerates & de-risks the journey. Like having a senior engineer from Day 1. 📖 lnkd.in/d7gJ86kz #PostgreSQL #Oracle #SQLServer

Introducing DCGMigrator ! DCGMigrator orchestrates the entire database migration journey, from assessment to validation, providing actionable insights at Day 1. datacloudgaze.com/post/introduci…

Here are some key highlights: 👉 Talk by @mahtodeepak05 at pgHyd: What's New in PostgreSQL 17 Video: youtu.be/sZP_oMKrZ6E?si… 👉 Our blog series explores new features in depth and how they can help app developers to build better database apps. databaserookies.wordpress.com/tag/postgresql…

🚀🚀 Latest Release of PostgreSQL 17 is Officially Here! 🎉🎉 At DataCloudGaze Consulting we've already begun exploring the exciting new features and enhancements in PostgreSQL 17 for our Database Developers Community.

We at DCG believe: 'Community thrives on passion, grows by listening, and evolves through innovation.' The 2024 State of PostgreSQL Survey is live! we enjoyed filling it out.Questions for every database role. #PostgreSQL enthusiasts, share your thoughts! form.typeform.com/to/wtUFIZwA

@neondatabase is lit with serverless, zero to scale and Branching! Did a quick #PostgreSQL Extensions comparision between #Neondatabase #AmazonAurora using pgextensions.org. Nice to see plpgsql_check extn available for developer! Give it a Spin for overall comparision.

Explore PostgreSQL Extensions on Cloud Managed Services! We've added sample filters to showcase the impactful use cases you can achieve with pgextensions.org. Check it out. #PostgreSQL #Extensions #Cloud #RDS #AmazonAurora #CloudSQL #Azure #AWS #GCP

@EmericHUNT3R Thanks ! Doing our best to contribute to our database community!

Our 4th Tool release in last 3 month!! SQL Tuning made simpler with statsviaexplainanalyze! combined execution plans and object statistics at one place for better analysis, sharing and stats driven decisions. #postgres #PostgreSQL #sql $tuning github.com/dcgadmin/stats…

Check out our websites (datacloudgaze.com) to find out recents releases and offerings that facilitate better adoption of #PostgreSQL on any Cloud.

Pgextensions Index For PostgreSQL pgextensions.org by @datacloudgaze is an online index of all #PostgreSQL extensions that are available on all Cloud providers' managed instances. @nikosvg explains why it is a useful resource. i-programmer.info/news/84-databa…

🚀 Migrate to #PostgreSQL with DataCloudGaze! Eliminate aws_sqlserver_ext packs and optimize your SQL Server transition in AWS. Learn more in our blog. datacloudgaze.com/post/achieve-a… #DataMigration #AWS #SQLServer #OpenSource #aws_sqlserver_ext

🥳🥳Our work pgextensions.org is listed on #Postgresweekly postgresweekly.com/issues/561

Feeling good about being recognized for our work on enabling truly open Postgres migrations without any hidden lock-ins. Thanks for the shoutout in the blog. drunkdba.medium.com/oracle-to-post… @database_comedy #Postgres #awsct #aws_oracle_ext datacloudgaze.com/post/achieve-a…

App - sct-migrator.vercel.app

Are you using AWS Schema Conversion Tools and want to remove the extension pack introduced during conversion? Try our SCT Migrator app with sample code to see it in action. datacloudgaze.com/post/achieve-a… #awssct #extensionpack #awsoracleext