Google Cloud Storage vs PostGIS

Overview

Google Cloud Storage

Stacks2.0K

Followers1.2K

Votes75

PostGIS

Stacks381

Followers377

Votes30

GitHub Stars2.0K

Forks407

Google Cloud Storage vs PostGIS: What are the differences?

What is Google Cloud Storage? Durable and highly available object storage service. Google Cloud Storage allows world-wide storing and retrieval of any amount of data and at any time. It provides a simple programming interface which enables developers to take advantage of Google's own reliable and fast networking infrastructure to perform data operations in a secure and cost effective manner. If expansion needs arise, developers can benefit from the scalability provided by Google's infrastructure.

What is PostGIS? Open source spatial database. PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL.

Google Cloud Storage and PostGIS are primarily classified as "Cloud Storage" and "Database" tools respectively.

Some of the features offered by Google Cloud Storage are:

High Capacity and Scalability
Strong Data Consistency
Google Developers Console Projects

On the other hand, PostGIS provides the following key features:

Processing and analytic functions for both vector and raster data for splicing, dicing, morphing, reclassifying, and collecting/unioning with the power of SQL
raster map algebra for fine-grained raster processing
Spatial reprojection SQL callable functions for both vector and raster data

"Scalable" is the primary reason why developers consider Google Cloud Storage over the competitors, whereas "De facto GIS in SQL" was stated as the key factor in picking PostGIS.

PostGIS is an open source tool with 636 GitHub stars and 242 GitHub forks. Here's a link to PostGIS's open source repository on GitHub.

Evernote, Bugsnag, and Wix are some of the popular companies that use Google Cloud Storage, whereas PostGIS is used by HotelTonight, Key Location, and DNT. Google Cloud Storage has a broader approval, being mentioned in 179 company stacks & 74 developers stacks; compared to PostGIS, which is listed in 53 company stacks and 14 developer stacks.

Share your Stack

Help developers discover the tools you use. Get visibility for your team's tech choices and contribute to the community's knowledge.

View Docs

CLI (Node.js)

Manual

Advice on Google Cloud Storage, PostGIS

Gabriel

CEO at NaoLogic Inc

Dec 24, 2019

Decided

We offer our customer HIPAA compliant storage. After analyzing the market, we decided to go with Google Storage. The Nodejs API is ok, still not ES6 and can be very confusing to use. For each new customer, we created a different bucket so they can have individual data and not have to worry about data loss. After 1000+ customers we started seeing many problems with the creation of new buckets, with saving or retrieving a new file. Many false positive: the Promise returned ok, but in reality, it failed.

That's why we switched to S3 that just works.

330k views330k

Comments

Ben

May 18, 2020

Decided

We choose Backblaze B2 because it makes more sense for storing static assets.

We admire Backblaze's customer service & transparency, plus, we trust them to maintain fair business practices - including not raising prices in the future.

Lower storage costs means we can keep more data for longer, and lower bandwidth means cache misses don't cost a ton.

120k views120k

Comments

Detailed Comparison

Google Cloud Storage	PostGIS
Google Cloud Storage allows world-wide storing and retrieval of any amount of data and at any time. It provides a simple programming interface which enables developers to take advantage of Google's own reliable and fast networking infrastructure to perform data operations in a secure and cost effective manner. If expansion needs arise, developers can benefit from the scalability provided by Google's infrastructure.	PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL.
High Capacity and Scalability;Strong Data Consistency;Google Developers Console Projects;Bucket Locations;REST APIS;OAuth 2.0 Authentication;Authenticated Browser Downloads;Google Account Support for Sharing	Processing and analytic functions for both vector and raster data for splicing, dicing, morphing, reclassifying, and collecting/unioning with the power of SQL;raster map algebra for fine-grained raster processing;Spatial reprojection SQL callable functions for both vector and raster data;Support for importing / exporting ESRI shapefile vector data via both commandline and GUI packaged tools and support for more formats via other 3rd-party Open Source tools
Statistics
GitHub Stars -	GitHub Stars 2.0K
GitHub Forks -	GitHub Forks 407
Stacks 2.0K	Stacks 381
Followers 1.2K	Followers 377
Votes 75	Votes 30
Pros & Cons
Pros 28 Scalable 19 Cheap 14 Reliable 9 Easy 3 Chealp	Pros 25 De facto GIS in SQL 5 Good Documentation
Integrations
No integrations available	PostgreSQL

What are some alternatives to Google Cloud Storage, PostGIS?

Amazon S3

Amazon Simple Storage Service provides a fully redundant data storage infrastructure for storing and retrieving any amount of data, at any time, from anywhere on the web

dbForge Studio for MySQL

It is the universal MySQL and MariaDB client for database management, administration and development. With the help of this intelligent MySQL client the work with data and code has become easier and more convenient. This tool provides utilities to compare, synchronize, and backup MySQL databases with scheduling, and gives possibility to analyze and report MySQL tables data.

dbForge Studio for Oracle

It is a powerful integrated development environment (IDE) which helps Oracle SQL developers to increase PL/SQL coding speed, provides versatile data editing tools for managing in-database and external data.

dbForge Studio for PostgreSQL

It is a GUI tool for database development and management. The IDE for PostgreSQL allows users to create, develop, and execute queries, edit and adjust the code to their requirements in a convenient and user-friendly interface.

dbForge Studio for SQL Server

It is a powerful IDE for SQL Server management, administration, development, data reporting and analysis. The tool will help SQL developers to manage databases, version-control database changes in popular source control systems, speed up routine tasks, as well, as to make complex database changes.

Amazon EBS

Amazon EBS volumes are network-attached, and persist independently from the life of an instance. Amazon EBS provides highly available, highly reliable, predictable storage volumes that can be attached to a running Amazon EC2 instance and exposed as a device within the instance. Amazon EBS is particularly suited for applications that require a database, file system, or access to raw block level storage.

Liquibase

Liquibase is th leading open-source tool for database schema change management. Liquibase helps teams track, version, and deploy database schema and logic changes so they can automate their database code process with their app code process.

Sequel Pro

Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases.

DBeaver

It is a free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, Teradata, MongoDB, Cassandra, Redis, etc.

dbForge SQL Complete

It is an IntelliSense add-in for SQL Server Management Studio, designed to provide the fastest T-SQL query typing ever possible.

Related Comparisons

Bootstrap vs Materialize

Django vs Laravel vs Node.js

Bootstrap vs Foundation vs Material UI

Node.js vs Spring-Boot

Flyway vs Liquibase