Pure Functional Database Programming Without JDBC
Explore pure functional database programming in Scala without JDBC, focusing on PostgreSQL communication, socket interfaces, and protocol layers for efficient and type-safe database interactions.
The Realities of Running a Rails App Long Term
Explore the evolution of a Rails app over a decade, covering design choices, testing, integrations, and challenges faced in long-term development and maintenance.
Processing Data at Scale with Rails
Strategies for handling large datasets using Rails, covering data ingestion, transformation, and storage with tools like ActiveRecord, Sidekiq, and Postgres.
Call Me Back, Postgres
Explore Postgres triggers as an alternative to Active Record callbacks, enabling seamless data syncing and process management in complex Rails applications.
Puny to Powerful PostgreSQL Rails Apps
Scaling Rails apps on PostgreSQL: Practical solutions for safe migrations, connection management, query optimization, maintenance, replication, and partitioning.
Business in the Front, Party in the Back - Office
Learn to build efficient back office interfaces for Ruby on Rails apps using Retool, streamlining admin tasks and integrating with Postgres and API services for improved productivity.
Migrating Shopify's Core Rails Monolith to Trilogy
Explore Shopify's migration from Mysql2 to Trilogy, covering MySQL protocols, Active Record adapters, and open source contributions. Learn about implementation challenges and the impact on Shopify's monolith.
Building Production Applications Using Go & SQLite
Explore building scalable applications using Go and SQLite, focusing on recent advancements, configuration tips, and strategies for improving data durability and performance.
Schema Liberation with JSON and PLV8
Explore JSON integration in Postgres using PLV8, enabling flexible schema design and efficient data management. Learn from Mozilla's production use case for crash reporting.
Making Relational Cool Again - JavaScript on ACID
Explore the revival of relational databases in JavaScript, focusing on ACID principles, transactions, and maintaining a structured data layer in hybrid applications.
Modern Data Applications with Entity Framework 7
Explore Entity Framework 7's new architecture, extensibility, and support for diverse data stores. Learn to build powerful, cross-platform applications with enhanced data handling capabilities.
Engineering for Engineering's Sake
Explores the pitfalls of engineering-focused solutions, emphasizing the importance of asking "why" and considering broader impact. Advocates for pragmatic approaches over cutting-edge technologies.
Building a Serverless API With Google, Firebase and PostgreSQL
Explore serverless API development using Google Cloud, Firebase, and PostgreSQL. Learn to leverage Firebase Functions, real-time database, and cloud-hosted PostgreSQL for efficient, infrastructure-free business solutions.
.NET Blub - Frameworks Beyond Microsoft
Exploring alternatives to common .NET frameworks, including NancyFX, Dapper, and Postgres. Challenges "Blub Paradox" thinking and encourages developers to expand their toolkit beyond Microsoft's offerings.
Exploiting Relationship Graphs to Isolate Tenant Data
Explore building a future-proof data exporter using Node.js and PostgreSQL metadata to graph database relationships, isolate tenant data, and generate constraint-safe scripts for multi-tenant architectures.
Efficient Time Series with PostgreSQL
Explore efficient time series data management in PostgreSQL, covering data models, access patterns, and scalability. Learn how this versatile SQL database can handle time series at scale, reducing system complexity.
Probing the Mysteries of Saturn’s E-Ring with PostgreSQL
Explore Saturn's E-Ring using PostgreSQL for data analysis, including flyby speed calculation and chemistry analysis, to prepare for future space missions and potential life discovery.
Database as API with PostgreSQL and Massive.js
Explore PostgreSQL integration with Node.js using Massive.js, a data mapper that leverages database capabilities for efficient and flexible application development.
Build Modern Web Apps Using Apollo, React, MobX, GraphQL, Db, and Node.js
Learn to build serverless web apps using Apollo, React, MobX, GraphQL, databases, and Node.js. Explore modern JavaScript stack for efficient full-stack development.
Dev and Test Agility for Your Database with Docker
Containerize SQL Server for agile database development and testing. Learn to use Docker for efficient database management, CI/CD integration, and improved dev workflows.
Building a Realtime Backend in a Box with PostgreSQL and Vue
Learn to build a realtime, document-based backend using PostgreSQL, GraphQL, Node, and Vue. Discover how to create a powerful API with Velzy, integrating VueX and leveraging PostgreSQL's advanced features.