practical-sql
Code and Data for the First Edition of "Practical SQL" by Anthony DeBarros, published by No Starch Press (2018). (by anthonydb)
pgstac
Schema, functions and a python library for storing and accessing STAC collections and items in PostgreSQL (by stac-utils)
| practical-sql | pgstac | |
|---|---|---|
| 1 | 1 | |
| 637 | 128 | |
| - | 5.5% | |
| 0.0 | 7.7 | |
| almost 2 years ago | 3 days ago | |
| PLpgSQL | PLpgSQL | |
| GNU General Public License v3.0 or later | MIT License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
practical-sql
Posts with mentions or reviews of practical-sql.
We have used some of these posts to build our list of alternatives
and similar projects.
-
Having trouble with INNER JOIN
(The tables I'm using for data are on GitHub here, in chapter 4 for the 2010 data and chapter 6 for the 2000 data.)
pgstac
Posts with mentions or reviews of pgstac.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-11-29.
-
Extending PostGIS with TiMVT/TiFeatures and PgSTAC
PgSTAC is a set of schema, functions and triggers for a PostgreSQL database to provide for the storage and discovery of Items in a STAC Catalog. It focuses on the storage and search parts of creating a STAC API entirely at the database level with the goal of keeping core functionality as close to the data as possible.
What are some alternatives?
When comparing practical-sql and pgstac you can also consider the following projects:
helium-etl-queries - A collection of SQL views used to enrich data produced by a Helium blockchain-etl
titiler-pgstac - TiTiler + PgSTAC
pg_partman - Partition management extension for PostgreSQL
ogcapi-tiles - OGC API - Tiles draft specification
stac-api-spec - SpatioTemporal Asset Catalog API specification - an API to make geospatial assets openly searchable and crawlable
zombodb - Making Postgres and Elasticsearch work together like it's 2023
titiler - Build your own Raster dynamic map tile services
practical-sql-2 - Code and Data for the Second Edition of "Practical SQL" by Anthony DeBarros, published by No Starch Press (2022).