![Crunchy Data](/img/default-banner.jpg)
- Видео 113
- Просмотров 198 507
Crunchy Data
США
Добавлен 31 мар 2017
Crunchy Data allows companies to build with confidence as the leading provider of trusted open source PostgreSQL and enterprise technology, support and training. Crunchy Data offers Crunchy Certified PostgreSQL, the most advanced and true open source RDBMS on the market. The company also offers Crunchy Bridge, a fully managed cloud Postgres service available on AWS, Azure and Google Cloud. PostgreSQL's active development community, proven architecture, and reputation for reliability, data integrity, and ease of use makes it a prime candidate for enterprises looking for a robust relational database alternative to expensive proprietary database technologies. Learn more at www.crunchydata.com.
Run Postgres Anywhere with Crunchy Data and Red Hat
From healthcare to the automotive sector, cloud-native applications are driving innovation and efficiency. Discover how Crunchy Data supports data-intensive workloads, enabling you to run Postgres anywhere.
Просмотров: 118
Видео
Discover the power of the Postgres-anywhere data stack with Crunchy Data and Red Hat
Просмотров 662 месяца назад
From healthcare to the automotive sector, cloud-native applications are driving innovation and efficiency. Discover how Crunchy Data supports data-intensive workloads, enabling you to run Postgres anywhere.
Crunchy Bridge for Analytics Demo
Просмотров 2783 месяца назад
Crunchy Bridge for Analytics is a new offering in Crunchy Bridge that lets you query and interact with your data lake using PostgreSQL commands via extensions, with a vectorized, parallel query engine. To learn more visit www.crunchydata.com/products/crunchy-bridge-for-analytics
PostGIS Day Introduction
Просмотров 8168 месяцев назад
Welcome to PostGIS Day! Paul Ramsey kicks off the day with a brief introduction.
Using PostgREST to create PostGIS Functions Fast
Просмотров 2 тыс.8 месяцев назад
Krishna Lodha from Rotten Grapes Pvt. Ltd. brings us 'Using PostgREST to create PostGIS Functions Fast'. In this talk, we will introduce PostgREST, a powerful open-source tool that can dramatically simplify the creation of custom PostGIS functions. PostgREST provides a RESTful API over a PostgreSQL database, enabling developers to quickly expose database functions as web services with minimal e...
Trajectory Analysis Using PostGIS
Просмотров 6218 месяцев назад
Benjamin Trigona-Harany from Planet brings us 'Trajectory Analysis Using PostGIS'. PostGIS supports geometries with a Z dimension and geometries with M (measure) values, but there are not a lot of examples of both of these being used together. One use case is the analysis of airplane tracks which requires both - that is to say every vertex has an altitude and a timestamp. This talk will show ho...
Custom Road Network Contraction for Routing
Просмотров 3648 месяцев назад
Laure-Hélène Bruneton from CampToCamp brings us 'Custom Road Network Contraction for Routing'. When computing the shortest path between two locations, the size of the roads dataset is often the number one impacting factor on performances. Let's discuss some ideas on how to reduce the size of this dataset, while preserving topology and attributes. Here is the link to my blog post on the same sub...
Mapping Where the Data is Not
Просмотров 2578 месяцев назад
Brendan Farrell from Clockwork Micro brings us 'Mapping Where the Data is Not'. We present a solution to the problem of displaying the areas in a web map where no data (polygon data) is available. This problem comes up, for example, if polygons designate flood risk areas. One then wants to avoid interpreting an area that has not been mapped at all for flood risk as an area that has been mapped ...
Enabling Mobility Data in Multiple Computing Environments
Просмотров 2568 месяцев назад
Esteban Zimanyi from Université libre de Bruxelles brings us 'Enabling Mobility Data in Multiple Computing Environments'. MobilityDB is an open source data management and analytics platform for mobility data (github.com/MobilityDB). Its core function is to efficiently store and query mobility tracks, such as vehicle GPS trajectories. It implements the Moving Features specification from the Open...
Air Traffic Analysis with PostGIS and MobilityDB
Просмотров 3108 месяцев назад
Wendell Turner from CSSI, Inc. brings us 'Air Traffic Analysis with PostGIS and MobilityDB'. Aircraft flight tracks naturally lend themselves to being stored as moving objects, and the MobilityDB extension to PostGIS is used to store these tracks for analysis. These tracks can then be intersected both geospatially and temporally with airspace elements (called traffic management initiatives) and...
We are part of the infrastructure, not above it
Просмотров 1688 месяцев назад
Bonny McClain from Global Impact Assessment brings us 'We are part of the infrastructure, not above it...'. Recent advances in geospatial analysis and the availability of digital maps have revealed the importance of urban form and built infrastructure as fundamental to understanding the vulnerabilities and vitality of global and local cities. Understanding that in the same way a stethoscope doe...
The PRAM Stack in Production
Просмотров 2508 месяцев назад
Rhys Stewart from Auchindown brings us 'The PRAM Stack in Production'. The database *is* the application. This is my very opinionated take on back-end programming. I discuss running Livewire (see lvwr.io/), a Software-as-a-Service used by distribution engineers in electric utility companies to provide visibility to, and answers for the relevant questions they may have about the network. It also...
Postgres Spatial DBA in a Pinch
Просмотров 3068 месяцев назад
Elizabeth Christensen from Crunchy Data brings us 'Postgres Spatial DBA in a Pinch'. Let's review some of the most important DBA tasks involved in running a database.
Spatial SQL, the Modern Data Stack, and PostGIS
Просмотров 1,2 тыс.8 месяцев назад
Matt Forrest from Carto brings us 'Spatial SQL, the Modern Data Stack, and PostGIS'. SQL, and in turn spatial SQL, is fast becoming the leading language for analytics. More tools are adopting it from data warehouses, to DuckDB, to dbt, and beyond. I believe that PostGIS is and will be the central tool to any modern GIS infrastructure. In this talk we will show practical and ready to implement e...
PgRouting: A Practical Example
Просмотров 1 тыс.8 месяцев назад
Vicky Vergara from pgRouting PSC brings us 'PgRouting: A Practical Example'. The UN OpenGIS initiative along with OSGeo Foundation organized the OSGeo UN Committee Educational Challenge where Challenge 2 was to create material for pgRouting. The challenge supports the objectives of the OSGeo UN Committee, i.e. promoting the development and use of open-source software that meets UN needs and sup...
Refactoring the Way We Talk About SQL: It is Costing us Money
Просмотров 5218 месяцев назад
Refactoring the Way We Talk About SQL: It is Costing us Money
Simple Polygonal Coverages in PostGIS
Просмотров 3978 месяцев назад
Simple Polygonal Coverages in PostGIS
PostGIS Ask Me Anything with Paul and Regina
Просмотров 3248 месяцев назад
PostGIS Ask Me Anything with Paul and Regina
How the USDA is Putting PostGIS to Work in the Dynamic Soils Hub
Просмотров 561Год назад
How the USDA is Putting PostGIS to Work in the Dynamic Soils Hub
Property Data Management with PostGIS, PostgreSQL, QGIS and QField
Просмотров 2,2 тыс.Год назад
Property Data Management with PostGIS, PostgreSQL, QGIS and QField
PostGIS for Conservation Planning and Supply Chain Impact Analysis
Просмотров 452Год назад
PostGIS for Conservation Planning and Supply Chain Impact Analysis
Simple and Fast OGC API Servers for PostGIS with TiFeatures and TiMVT
Просмотров 1,1 тыс.Год назад
Simple and Fast OGC API Servers for PostGIS with TiFeatures and TiMVT
Building an Asset Inventory Database Using PostGIS: The Case of Giswater
Просмотров 757Год назад
Building an Asset Inventory Database Using PostGIS: The Case of Giswater
Kart: A Practical Tool for Versioning Geospatial Data
Просмотров 1,1 тыс.Год назад
Kart: A Practical Tool for Versioning Geospatial Data
Build Beautiful Isochrone Maps Using PostGIS and QGIS
Просмотров 1,4 тыс.Год назад
Build Beautiful Isochrone Maps Using PostGIS and QGIS
Postgres is RDBMS
So sick, I jumped when I saw how few lines of SQL represented a much longer script in Python.
Super que pensez vous de supabase il facilite l'utilisation de postGis sans passer par les configurations de Postgresql
pretty awesome!
Amazing
Is the site mandatory to use postgis, if not, should I use both banks?
well did anyone ever write it in rust?
Great talk, i wish i had the presentation...
Awesome, according to the definition of a trajectory, we cannot add speed as M value, but what if we wanted to add timestamp + speed in M value, I think it is not applicable I guess.
What's the benefit of hooking into notify rather than a logical subscription? In the latter case, you don't need triggers at all, right?
Cool idea!
Promo>SM 😏
This is handy. I am currently working as GIS and I want to learn and upskill my skills relatively in GIS.
Your experience so far?
Great Content. Keep up the good work
How do we install the H3 extensions for PostGIS?
quarter mil flag 😂
The audacity!
This stuff is amazing. Thank you Martin!
Carl Higgs! My neighbor is named Carl Hiatt and I misspoke!
great talk
Fantastic video! Thanks Matt!
In the DuckDB FTS example, the note that results may not have the words "flash" or "flood" is misleading... it looks like the index was built on EPISODE_NARRATIVE but EVENT_NARRATIVE was retrieved and indeed may not contain "flash" or "flood".
wow, unreal!
Very insightful presentation, thank you!
この動画はもっと評価されるべき。
I am interested in this one..
Very interesting presentation.. Am interested in learning more about how to manage different users in qgis projects and different access to datasets.. how can I achieve all this using all this open source tools
ruclips.net/video/_dmH2jFdewo/видео.html, we offer dynamic vector tile solution. more tile format, more function
ruclips.net/video/_dmH2jFdewo/видео.html, we offer dynamic vector tile solution. more tile format, more function
I need some assistance of QGIS to develop a Geo-database.
where all these we can copy?
beautiful explaination, Can I use normal postgres update and insert query instead of pg_featureserv ?
Yes.
Great video. Would like to know more about the PostgreSQL/PostGIS configuration, i.e. how you organized the databases/schemas and what roles were established and with what permissions they were given.
😂😂 biscuits and coffees lol
I came here to learn about using QGIS and PostgreSQL and this nailed it. Ms Kane is absolutely excellent at explaining things like this. I particularly liked the bit where she wanted people to understand that by PostGIS she's really talking about a PostgreSQL database with the PostGIS extension enabled. Also... the video capture the spirit of pandemic perfectly. The host is in a small, picture frames hung at random angles, and a healthy beard. Early technical issues help establish the tone. I love the random rectangle in the middle of the screen. And the coughs, sneezes, and seemingly non-diegetic laughter and other evidence that people are unmuted and just gettin' on with their lives makes it all the more real. I came for the content. Stayed for the coughs.
Is there anyway to work with postgis data offline on qfield?
Nice work and presentation, thank you!
I tried the links and noting work. Pods are always stuck. Theni used openebs as storage class it works but finally I didn't manage install pho Clint and run the backups
great presentation, thanks for the info!
There was a very clear explanation of what STAC is, but I didn't really catch any explanation why STAC is more useful than any other metadata schema? It doesn't seem like there is any technological reason that searches would be more performant or efficacious with stac vs. ISO/FGDC or something bespoke?
Great tutorial, thanks!
You are my favorite content creator. Promote your social media with *Promo SM*!
Very impressive! Thank you for sharing!
legendary
"every thing I do is open source, I am not sure how this integrates with other platforms, like ..." I thought I was alone to do that! 😆I feel vindicated😛
This is such a good idea. Finally an OGC feature API implementation using modern tools and best practices.
Amazing 😍, thank you!
Nice talk and excellent job. I look forward to reading your new book.
This video helps me solve the problem I’m facing at a fortune 500 company. Pls keep uploading more videos
share the download link of ghost town map db