Database

Django is one of the most popular web frameworks that is written in Python. It follows the principle of Don’t Repeat Yourself (DRY) and promotes rapid development by providing a set of tools, libraries, and conventions that handle common web development tasks. What makes Django powerful is that it has…

Quell is back with some of our most exciting updates to date: a context visualizer to give developers valuable visual feedback on the structure of their queries, an updated developer tool to help you manage your GraphQL queries, more robust client-side caching algorithms, a website redesign, and so much more. GraphQL: an effective and simpler alternative to REST …

Introduction: In the world of data engineering, building a robust and efficient ETL (Extract, Transform, Load) pipeline is crucial for organizations to harness the power of their data. Fivetran, dbt (Data Build Tool), Amazon S3, Apache Airflow, and Snowflake form a powerful stack of tools that seamlessly integrate to create an…

We find Subreddits with the largest increase in new subscribers each month using our Reddit/Subreddit Dataset on the Snowflake Marketplace. This dataset allows us to identify the Subreddits that experience the most significant growth in new subscribers every month. …

For those who don’t know what window function is and how it works, let’s understand it. Window function applies aggregate like sum(), avg(), count() and ranking functions rank(), dense_rank(), row_number() over a particular window i.e set of rows it is followed by OVER clause. OVER clause is used with window…

Meet Sundeck, a new way to interact with Snowflake. It’s a SaaS platform for query engineering that revolutionizes the way data engineers interact with Snowflake alongside their preferred existing tools. It empowers data engineers, analysts, and DBAs to elevate their workflow by enhancing syntax, executing pre- and post-queries, capturing and…

Making sense of database normalization through examples: A simple guide to rules, stages, and examples with ER diagrams for better database design. — The Concept of Database Normalization

One of the android applications I was recently working on stores a maximum of 10000 rows in the database. This data then gets synced to the server at specific time intervals. To sync the data to the server, the list from the database gets converted into a json string using…

Starting with Oracle Database 23c, the new role “DB_DEVELOPER_ROLE” allows administrators to quickly assign all necessary privileges developers need to design, build, and deploy applications for the Oracle Database (including System privileges required to build a data model and Object privileges required to monitor and debug applications). By using this…