https://sudonull.com/select-queries-in-clickhouse-differences-from-postgresql-prewhere-sample
PREWHERE, SAMPLE, FINAL, IN vs JOIN, FORMAT, top 10 queries for betting analytics. How to migrate SQL from PostgreSQL to ClickHouse without errors.
Search Articles — Sudonull
Search Results
In this project
https://sudonull.com/database-architecture-for-parsing-tariffs-on-postgresql
Study the star schema for storing internet and TV tariffs: fact tables, dimensions, historicity triggers, indexes. Full SQL code for middle/senior developers. Implement provider monitoring without data loss.
https://sudonull.com/health-score-for-postgresql-health-monitoring
Learn how Health Score combines 150 PostgreSQL metrics into one indicator. Formulas, SQL queries, category weights and auto-diagnostics for DBA. Implement in your infrastructure.
https://sudonull.com/calculation-view-in-asapbi-without-sql
Learn how to visually build analytical models in asapBI for ADB, PostgreSQL and Trino. Export to UDF, clusters without load on DB. For DWH developers.
https://sudonull.com/ltree-in-postgresql-with-jpa-storing-trees
Integration of ltree for hierarchical data in PostgreSQL and JPA. Performance comparison with recursive SQL. Application in microservices for developers.
From the web
GitHub - Beloborod/psql_vcs: Python library for PostgreSQL ...
https://github.com/Beloborod/psql_vcs
The project was created to support an easy-to-develop PostgreSQL database migration system. The library allows for automatic change tracking, creation of SQL scripts for migration, and migration to the latest database version, including creating a database if it doesn't exist.
psql-vcs · PyPI
https://pypi.org/project/psql-vcs/
The project was created to support an easy-to-develop PostgreSQL database migration system. The library allows for automatic change tracking, creation of SQL scripts for migration, and migration to the latest database version, including creating a database if it doesn't exist.
Быстрый старт: Подключение и выполнение запросов к PostgreSQL ...
https://learn.microsoft.com/ru-ru/azure/postgresql/development/vs-code-extension/quickstart-connect-query
Узнайте, как подключиться к базе данных PostgreSQL и запустить первый запрос с помощью расширения PostgreSQL для Visual Studio Code.
Расширение PostgreSQL для VS Code | Microsoft Learn
https://learn.microsoft.com/ru-ru/shows/pycon-2025/postgresql-extension-for-vs-code
Jun 24, 2025 · Это расширение позволяет разработчикам подключаться к базам данных PostgreSQL , записывать и выполнять запросы, а также управлять объектами базы данных без выхода из среды Visual Studio Code.
Разработка автоматической системы проверки SQL — Игорь Тот ...
https://vkvideo.ru/video-101507899_456240109
3 days ago · Смотрите онлайн Разработка автоматической системы проверки.. 20 мин 10 с. Видео от 8 октября 2026 в хорошем качестве, без регистрации в бесплатном видеокаталоге ВКонтакте! 9 — просмотрели.
PostgreSQL: The world's most advanced open source database
https://www.postgresql.org/
1 day ago · PostgreSQL is a powerful, open source object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.
Создание простейшего back-end на Node.js с использованием ...
https://habr.com/ru/companies/otus/articles/828684/
Jul 17, 2024 · На этом открытом уроке расскажем о возможностях PostgreSQL в части создания собственных типов данных.
Trending Now
How to Use React Hooks: Complete Guide with Examples
Learn how to use React hooks effectively with practical examples. Master useState, useEffect, useContext, and custom hooks in this complete guide for modern React.
What Is a Vector Database? Beginner's Guide to AI Search
What is a vector database? Learn how vector databases power AI search, RAG, and recommendations. Discover key concepts and when to use them. Start here.
What Is Object Oriented Programming? Core Concepts Explained
Learn what is object oriented programming, its four pillars, real-world examples, and why it matters for building scalable, maintainable software. Start mastering OOP today.
DeepWay Robotaxi 1000 km: Solid-State Batteries and AI Revolution
Chinese startup DeepWay announced a robotaxi with a range of 1000 km on solid-state batteries. Learn how this changes the electric vehicle market and why it matters.
JavaScript vs Python Which Is Better: Full 2026 Guide
JavaScript vs Python which is better for you? Compare ease of learning, salaries, use cases, and career paths to choose the right first language in 2026. Start now.
GPT-4 vs Claude Comparison: Which AI Model Is Best?
Read our data-driven GPT-4 vs Claude comparison covering accuracy, coding, hallucinations, and cost. Discover which AI model fits your needs in 2026.
What Is React Used For? UI Development Guide
What is React used for? Learn how this JavaScript library builds fast, scalable UIs with components and Virtual DOM. Discover its real-world uses and benefits.
Fine Tuning vs Retrieval Augmented Generation: A Guide
Compare fine tuning vs retrieval augmented generation for LLMs. Learn which approach suits your AI project based on accuracy, cost, and data freshness.
How to Deploy LLM in Production: Step-by-Step Guide
Learn how to deploy LLM in production with this step-by-step guide. Covers model selection, Kubernetes deployment, vLLM, testing, and monitoring for reliable AI systems.
what is the difference between vpn and proxy: Key Privacy Tips
Learn what is the difference between vpn and proxy, from encryption to scope. Discover which tool fits your privacy needs with our expert comparison.