Optimizing Queries for Not So Big Data in PostgreSQL
Optimizing PostgreSQL queries for medium-sized datasets: strategies for efficient database design, query optimization, and maintenance to handle high-volume data and requests.
Introducing Asynchronous SQLAlchemy
Explore SQLAlchemy's new asyncio support, including AsyncEngine setup, avoiding pitfalls, and using synchronous functions in async contexts. Ideal for developers with ORM and asyncio experience.
The Right Tool for the Right Job - Serving Data From SQL Server
Strategies for efficient data retrieval from SQL Server, comparing methods like stored procedures and ORMs. Includes implementation examples in .NET and tips for performance tuning and database structuring.
AngularJS ORM
Explore AngularJS ORM techniques for efficient data management and improved application performance in this insightful conference talk by Dean Sofer.
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.
Defensive Coding Bootcamp
Learn essential security practices to build robust, hack-resistant software. Explore vulnerabilities, evasive coding techniques, and fundamental principles applicable across programming languages.