Database Centric Applications with Spring Boot and jOOQ
Explore advanced database querying with jOOQ in Spring Boot applications. Learn type-safe SQL generation, database migrations, and how to expose complex analytics as HTTP APIs.
Do You Really Need Hibernate
Explore alternatives to Hibernate for database-centric applications. Learn how jOOQ and Java Records can simplify data access, improve performance, and avoid common ORM issues.
Functional Programming for the Web with Elm
Explore Elm, a functional language for reliable web apps. Learn syntax, tooling, and architecture while discovering its benefits for web development and functional programming.
Handling Large Volumes of Immutable Structured Data With ClickHouse
Explore ClickHouse, an open-source column-oriented database for handling large volumes of immutable structured data, with SQL querying capabilities and efficient analytics on modest hardware.
CMake - A Case Study
Explore advanced CMake techniques for integrating unsupported libraries and tools, focusing on embedded SQL in C++ applications with Oracle databases. Learn expert-level build setup strategies.
MySQL for System Administrators
Aprenda habilidades essenciais para manter bancos de dados MySQL, equilibrando funções entre administrador de sistemas e DBA. Aborda autenticação, backups, monitoramento e práticas recomendadas.
Who Needs Hibernate When There Is SQL?
Explore the power of SQL as an alternative to Hibernate for efficient database management and querying in modern applications.
I Would Never Use an ORM
Explore the drawbacks of ORMs and discover Platformatic DB as an alternative solution for efficient database management in JavaScript projects.
Sweating the Small Stuff - Brace Initialization, Unions and Enums
Explore C++11's less-discussed features: brace initialization, unions, and enums. Learn practical applications and benefits for beginner to intermediate C++ developers.
Variations on Variants
Explore std::variant in C++, its implementation, and alternative approaches for serialization. Learn about Intrusive-Variant and Variant-of-Base techniques, and gain insights into modernizing C-style code with variants.
Comparing the Different Ways to Scale Python and Pandas Code
Explore scaling Python and Pandas code with Fugue, a unified interface for distributed computing. Learn to execute functions across Pandas, Spark, and Dask for efficient data workflows.
Data Analysis with SQLite and Python
Hands-on tutorial for Python users to master SQLite, covering advanced SQL features, data manipulation with sqlite-utils, and exploration using Datasette. Learn to build and deploy data applications.
Aspettando PostgreSQL 9.1
Esplorazione delle nuove funzionalità di PostgreSQL 9.1, con focus su miglioramenti di prestazioni, sicurezza e scalabilità per database aziendali.
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.
Air Quality & Python - Developing Online Analysis Tools
Explore Python-based online tools for analyzing air quality data, integrating libraries like Pandas and NumPy with Django and Plot.ly to create interactive visualizations and support research and education.
Leveraging Linked Data Using Python and SPARQL
Explore Python and SPARQL to extract structured knowledge from Wikipedia, creating datasets and corpora for data science projects without traditional web scraping techniques.
Elephants, Ibises and a More Pythonic Way to Work with Databases
Explore a Pythonic approach to database interactions using Ibis, comparing it with traditional SQL methods and showcasing its versatility across various database engines.
DuckDB - Bringing Analytical SQL Directly to Your Python Shell
Explore DuckDB's seamless integration with PyData ecosystem, enabling efficient analytical SQL queries without a server. Live demo showcases performance and usability alongside Pandas for data science tasks.
Building Your T-SQL Tool Kit - Window Function Fundamentals
Explore T-SQL window functions to enhance data analysis skills, improve query performance, and solve complex business problems efficiently.
Index Fragmentation - Internals, Analysis, and Solutions
Explore index fragmentation in SQL Server, covering internal structures, analysis techniques, and practical solutions for optimizing database performance and query efficiency.
10 Dicas para Escrever Codigos T SQL Melhores
Aprenda 10 dicas essenciais para aprimorar seus códigos T-SQL, melhorando a eficiência e qualidade das suas consultas e procedimentos armazenados.