Unearthing the Past with PostgreSQL...
summary
French archaeologists build a production Postgres/PostGIS database named B.A.D.A.S.S. (Base Archaeological Data: Attributive and Spatial System) with around 40 tables, triggers that enforce stratigraphic and geometry rules, and photogrammetry links for 3D site models. A mobile web UI is generated from plain SQL using SQLPage, giving real-time multi‑user data entry, map components and photo/model viewing, and an offline mode via SQLite for no‑connectivity digs. QGIS remains for heavy GIS work while most field tasks run from the SQL‑driven app.
AI-written summary · about
chapters (8)
- 0:00Introduction to the project
- 2:20Archaeology and data challenges
- 12:23The BADASS database structure
- 18:52Introducing SQLPage
- 21:47Building the application
- 34:43How SQLPage works internally
- 39:08Presentation of Badmobil
- 46:09Conclusion and Q&A
related talks
02h 44mBuilding Geographical APIs with Open Data, PostgreSQL & PostGIS
21mActual trees, not b-trees: or how I found PostgreSQL through PostGIS
21mCreating a geological database using historic and contemporary information
31mMaking Data Dance
34mAnalytics and AI with PostgreSQL - Mission Possible!
18mA journey in geospatial timeseries
34mAnalytics and AI with PostgreSQL - Mission Possible!
21mThe Open Source Geospatial Community, PostGIS, & Postgres