Understanding CRUD Operations in SQL – Real Python

Learn how CRUD operations work in SQL by writing raw SQL queries with SQLite and using SQLAlchemy as an ORM in Python. » Real Python | realpython.com

24 de marzo de 2026 · 1 min · 27 palabras · Nacho Cano

Este ingeniero español y youtuber tiene cursos gratis de programación para aprender Python, Git, SQL y mucho más

Hay pocos profesionales de la informática en España con tanto tirón como Brais Moure. Y es que este ingeniero de software además de dedicarse a la… » eva r. de luis | genbeta.com

11 de marzo de 2024 · 1 min · 33 palabras · Nacho Cano

Setting up a Python venv

At work recently I had a PR open for changing the output of a SQL query to the OSS version of the database we’re building and part of that was outputting data in the Apache Parquet format. To validate this worked I had my integration tests in Rust, but I » Ductile Systems | ductile.systems

25 de febrero de 2024 · 1 min · 55 palabras · Nacho Cano

Conway's game of life...in pure SQL [Postgres]! 💪🏼🤯

OK, for those of you who are new here, I like to do things that have never been done (and should… » DEV Community | dev.to

31 de agosto de 2023 · 1 min · 26 palabras · Nacho Cano

How to Set Up Multi-Master PostgreSQL Replication on Ubuntu 22.04

PostgreSQL is an open-source database management system focusing on extensibility and SQL compliance. This tutorial will install the PostgreSQL databa… » Arvid L | howtoforge.com

17 de marzo de 2023 · 1 min · 25 palabras · Nacho Cano

How to optimize PostgreSQL queries from Django using pgMustard

Slow queries happen, and when they do, it can be tough to dissect why they’re slow. This difficulty is compounded by using Django’s ORM, since it generates the SQL for you, so you may have little idea of the actual queries “under the hood”. » adamj.eu | adamj.eu

14 de julio de 2022 · 1 min · 48 palabras · Nacho Cano

48 libros gratis de programación (PDF en inglés)

Free Programming Books on Android development, C, C#, CSS, HTML5, iOS development, Java, JavaScript, PowerShell, PHP, Python, SQL Sever and more » books.goalkicker.com | books.goalkicker.com

12 de abril de 2022 · 1 min · 25 palabras · Nacho Cano

Example SQL queries: distinct, joins, group by, order by, count, and sorting

Example SQL queries: distinct, joins, group by, order by, count, and sorting » alvinalexander.com | alvinalexander.com

27 de noviembre de 2021 · 1 min · 16 palabras · Nacho Cano

SQL vs NoSQL databases

Learn the differences between SQL and NoSQL databases and how to choose the best type for your application. » CircleCI | circleci.com

12 de septiembre de 2021 · 1 min · 22 palabras · Nacho Cano

Intro to Structured Query Language (SQL)

In the post, I used a simple SQL query to explain how certain things work in SQL. I also outlined problems with the query and potential ways to improve the code » hackernoon.com | hackernoon.com

17 de agosto de 2021 · 1 min · 35 palabras · Nacho Cano