APIs
Cursor Agent System Prompt (March 2025)
Cursor Agent System Prompt (March 2025). GitHub Gist: instantly share code, notes, and snippets.
Code Arena
Code Arena lets developers compare how top LLMs build apps, websites, games, and more. Watch AI models code, refine, and deploy real software live.
How Cursor (AI IDE) Works
Turning LLMs into coding experts and how to take advantage of them.
2255 STONE MOUNTAIN LITHONIA RD, LITHONIA, GA 30058 | Climate Risk Report | First Street
2255 STONE MOUNTAIN LITHONIA RD, LITHONIA, GA 30058 has risk from flooding, risk from wildfire, and risk from windstorms
First Street API
Comprehensive application programming interfaces for quantifying physical climate risk
Flood, Wildfire, Wind and Heat Risk Model Methodology
Nationwide models built off of decades of peer-reviewed research forecast the physical climate risk of flood, wildfire, wind and extreme heat.
Flood Factor® Flood Risk Model Methodology
Nationwide physically-based flood model forecasts how climate change will impact flood risk from rain, streamflow, sea level rise, and storm surge.
Real Estate Development Models — developer 0.3.0 documentation
What is GIS? | Geographic Information System Mapping Technology
Find the definition of GIS. Learn how this mapping and analysis technology is crucial for making sense of data. Learn from examples and find out why GIS is more important than ever.
DB schema design guide | PostgresAI
Database design principles and best practices for PostgreSQL schema design
publiclab/leaflet-environmental-layers: Collection of different environmental map layers in an easy to use Leaflet library, similar to https://github.com/leaflet-extras/leaflet-providers#leaflet-providers
Collection of different environmental map layers in an easy to use Leaflet library, similar to https://github.com/leaflet-extras/leaflet-providers#leaflet-providers - publiclab/leaflet-environmenta...
GIS
🐘 PostgreSQL Power User Cheatsheet: The Guide for DBAs & Developers
🚀 Supercharge your PostgreSQL skills! This cheatsheet covers architecture, performance tuning, advanced SQL, JSONB, MVCC, security, replication & essential commands. A must-have for DBAs & Developers looking to master Postgres.
Character encodings: Essential concepts
Introduces a number of basic concepts needed to understand other articles that deal with characters and character encodings.
pgModeler - PostgreSQL Database Modeler
Open source data modeling tool designed for PostgreSQL. No more DDL commands written by hand. Let pgModeler do the job for you!
Leaflet Environmental Layers
Collection of different environmental map layers in an easy to use Leaflet library.
jc5577/armcop: ArcGIS Map Server Copy To GeoJson
ArcGIS Map Server Copy To GeoJson
PostGIS Data Ingestion — CartoLab
PostGIS Data Ingestion
Clockwork Micro: Map tools that work like clockwork | Clockwork Micro
Map tools that work like clockwork. Map Tools. Modular, Interactive, Low code/no code
Dbdbml
tabde/R/utils-sfmisc.R at master · s-fleck/tabde
Work with table designs (col_names, col_types) in csv format - s-fleck/tabde
tabde/R/as_sql.R at master · s-fleck/tabde
Work with table designs (col_names, col_types) in csv format - s-fleck/tabde
From API to Database: A Step-by-Step Guide on Efficient Data Integration
A helpful step-by-step guide to learn about the benefits of integrating APIs with databases and how to do it.
Storing External Requests
I’ve worked in payment systems for a long time, and one common theme is that they make a lot of 3rd party API calls. For example, there are numerous payment networks and banks, fraud and risk checks, onboarding and KYC/KYB (Know Your Customer/Business) services, and more. And then there are the inbound calls as well, such as webhooks and callbacks from integration partners, e-commerce stores, and other outside interactions.
The first step is storing all inbound and outbound API calls. People will often use logs for this, but I think it’s far more valuable to put them in the database instead. This makes them easier to query, easier to aggregate, and easier to join against other data.
You can use one table for both inbound and outbound or separate them depending on preferences, but generally it’s useful to store most of the available information, such as:
URL of the request
Datetime of the request
Request body
Response body
Response status/code (e.g. 200, 500)
Total time spent on the request
Request headers
Response headers
Metadata
For metadata, I like to use a JSON column and add in any metadata that links this request to an entity in the system. For example, it could include user_id, order_id, request_id, etc. As a JSON column, you can include more than one, and even include other complex nested information.
Response headers often include extra debugging information, such as request or trace Ids, version numbers, etc. It’s common when asking for 3rd party support to provide these values so they can go look in their own logging to find your requests.
Rather than try to write code for every API call, it’s often better to hook into the request/response lifecycle in one place and instrument all calls.
The way you do this depends on the language and libraries, but they are generally called interceptors.
Where possible, I like to record the request fields before the outbound call is started (e.g. request body, request headers) and then go back and update the row to store the response fields once the call is completed. There are several advantages over a single write at the end of the request cycle:
feddelegrand7/rlowdb: Lightweight, JSON-based database for R 🦩🦩🦩
Lightweight, JSON-based database for R 🦩🦩🦩
Customising condition messages — topic-condition-customisation
Various aspects of the condition messages displayed by abort(), warn(), and inform() can be customised using options from the cli package.
mkquartodocs
mkquartodocs extension
Understanding Slope and Aspect (Terrain Analysis)
Slope and Aspect (Terrain Analysis)
Slope 101
Slope is an important data point in insurance, enabling companies and agents to accurately price their policies.