Akshat Jainblog.akjn.dev·Sep 19, 2023Correlated Subqueries and Why You Need To Know ThemIntroduction Let's say you have 2 tables: table1: Having a column col1 table2: Having a column col2 create table table1 (col1 int); create table table2 (col2 int); Let's discuss a query: select * from table1 where col1 in (select col1 from table...Ashwani Yadav and 6 others are discussing this7 people are discussing thisDiscuss·51 likes·290 readsPostgreSQLI love how you describe things sir! 3
Kennethe Glelegkennethe.hashnode.dev·14 hours agoAspirante Data Analyst: Du Stockage Massif à l'Analyse de Données avec Python et SQLLe monde de la technologie évolue à une vitesse vertigineuse. À mesure que notre capacité à stocker d'énormes quantités d'informations s'accroît, l'analyse de données devient de plus en plus cruciale. Dans les prochaines semaines, je vous ammène avec...DiscussPython
Naveen Sargamblog.congineal.com·16 hours agoUnveiling the Magic of Django ORM: A Powerful Tool for Effortless Database Management.Introduction In the world of web development, managing databases is a crucial task. Storing, retrieving, and manipulating data efficiently is essential for building robust applications. This is where Object-Relational Mapping (ORM) comes into play, a...DiscussDjango
pengwei songqtmuniao.hashnode.dev·18 hours agoStep by step, dissecting the most challenging parts of the database transaction — IsolationWhen it comes to database transactions, most people's first reaction is often ACID. However, the importance and complexity of the four attributes are not equivalent. The most challenging aspect to comprehend is Isolation (I). One primary reason for t...Discussisolation
RisingWave Labsrisingwavelabs.hashnode.dev·19 hours agoStream Processing Engines and Streaming Databases: Design, Use Cases, and the FutureIn the fast-evolving field of real-time analytics, many stream processing engines have emerged over the past decade. Notable examples include Apache Storm, Apache Flink, and Apache Samza. These engines have become widely accepted in various enterpris...DiscussDatabases
Carlos Magalhãesblog.cadumagalhaes.dev·Sep 22, 2023How to setup a PostgreSQL database with Docker ComposeWhen I started learning about databases, Docker didn't even exist yet. So I spent hours trying to make both the database engine and the workspace interface to work, and there are so many little details in the setup that I'm sure you'll find thousands...Discuss·10 likesDocker
RisingWave Labsrisingwavelabs.hashnode.dev·Sep 22, 2023Why Kafka Is the New Data Lake?The shift in data management towards data lakes is indeed transformative. Data lakes are fundamental in managing vast amounts of raw, unstructured, and semi-structured data. Their ability to store historical data as a single source of truth is crucia...Discusskafka
Vikraman Svikraman.hashnode.dev·Sep 22, 2023Unveiling the Pioneers: A Study of Leading Vector Database TechnologiesIntroduction: In today’s digital age, we’re surrounded by an overwhelming amount of data. From the songs we stream to the photos we share, the digital footprints we leave are vast and varied. But have you ever paused to wonder how platforms like Spot...Discussvector database
Gigi Kennethbluegenes.hashnode.dev·Sep 21, 2023Data Management Best Practices for Modern Backend Data SecurityAhoy, fellow developers! Ready to shed that outdated armour and upgrade to an impenetrable fortress for your data? In the digital realm, where treasure troves of information fuel our businesses, data security isn’t just a buzzword — it’s our battle c...Discuss#datamanagement
RisingWave Labsrisingwavelabs.hashnode.dev·Sep 21, 2023Streaming Databases: Everything You Wanted to KnowIn today's fast-paced digital landscape, the ability to harness real-time data has become essential for organizations striving to make informed decisions and remain competitive. This comprehensive guide explores the world of streaming databases, shed...DiscussDatabases
Ishioma Ubahishiomaubah.hashnode.dev·Sep 21, 2023Sql For Data AnalyticsI am now learning SQL for Data Analytics. It is interesting because I am figuring out different ways to solve a problem, getting different results for each applied step, figuring out why and deciding on the required output based on business requireme...DiscussSQL