A long time ago, in a galaxy far far away, threads' were a programming novelty rarely used and seldom trusted. In that environment, the first PostgreSQL developers decided forking a process for each connection to the database is the safest choice. It would be a shame if your database crashed, after all. Since then, a lot of water has flown under that bridge, but the PostgreSQL … [Read more...] about PostgreSQL Connection Pooling: Part 1 Pros & Cons
database
PostgreSQL Trends: Most Popular Cloud Providers, Languages, VACUUM, Query Management Strategies & Deployment Types
PostgreSQL popularity is skyrocketing in the enterprise space. As this open-source database continues to pull new users from expensive commercial database management systems like Oracle, DB2 and SQL Server, organizations are adopting new approaches and evolving their own to maintain the exceptional performance of their SQL deployments. We recently attended the PostgresConf … [Read more...] about PostgreSQL Trends: Most Popular Cloud Providers, Languages, VACUUM, Query Management Strategies & Deployment Types
What is ETL?
In our articles related to AI and Big Data in healthcare, we always talk about ETL as the core of the core process. We do not write a lot about ETL itself, though. In this post, we'll give a short overview of this procedure and its applications in businesses. ETL is the abbreviation for Extract, Transform, Load that are three database functions: Extract is the process of … [Read more...] about What is ETL?
The Database of Tomorrow: The Self-Driving, Autonomous Database
This article is sponsored by Oracle - redefining data management with the world's first autonomous database. In the coming years, the amount of data we create worldwide will grow to 175 zettabytes of data per year by 2025, up from 33 zettabytes in 2018. Over half of this data will be created by the Internet of Things devices and over 60% of it will be enterprise data. By 2025, … [Read more...] about The Database of Tomorrow: The Self-Driving, Autonomous Database
Which Is the Best PostgreSQL GUI? 2019 Comparison
PostgreSQL graphical user interface (GUI) tools help these open source database users to manage, manipulate, and visualize their data. In this post, we discuss the top 5 GUI tools for administering your PostgreSQL deployments. PostgreSQL is the fourth most popular database management system in the world, and heavily used in all sizes of applications from small to large. The … [Read more...] about Which Is the Best PostgreSQL GUI? 2019 Comparison
