Oracle Database World '22 Presentations Available On-Demand

All the latest Oracle Database World 2022 (ODW'22) are now available for replay on-demand on YouTube (with no registration required)!

Read: https://blogs.oracle.com/database/post/oracle-database-world-22-presentations-available-on-demand

I have tables, but I want JSON, CSV, and yes...Excel!

After 20 some years in the database world, I know at least two things:

the database is almost always the best place to store your data
developers and analysts want Excel files, CSV, or JSON

I don't want to argue the first point. There is plenty to ...

Read: https://thatjeffsmith.hashnode.dev/i-have-tables-but-i-want-json-csv-and-yesexcel

Day 39/100

Designing Data-Intensive Applications [Book Highlights]
[ Part II : Chapter V ] Distributed Data
Implementation of Replication Logs
Statement-based replication

In the simplest case, the leader logs every write request (statement) that it executes an...

Read: https://rawdatareaders.hashnode.dev/day-39

The first day of learning MongoDB

Before We Begin
So this is my summary for the playlist of introduction to a MongoDB, at this post we will interact only with the pure environment so you could implement it in any web framework.

Download
1- Download MongoDB
Note
Download the latest ...

Read: https://hamdysaad.hashnode.dev/the-first-day-of-learning-mongodb

Working with SQLAlchemy

Create an engine

Create session

Create a table

Migrate


Getting Started
Open your code editor (vs code)
save the file students.py
navigate to the directory of students.py from the terminal on your vs code

HOW TO CREATE AN ENGINE
from the termina...

Read: https://rukayat-balogun.hashnode.dev/working-with-sqlalchemy

Любопытные и неочевидные особенности при работе со Snowflake

Без долгих вступлений, сразу к делу.

Знаете ли вы, что в Snowflake можно создавать объекты с пустыми именами? Например: CREATE DATABASE ""; CREATE SCHEMA ""."";

Это работает на момент публикации и потенциально создаёт массу проблем для внешних систем, которые не ожидают такого поворота. Также это обычно приводит в восторг админов DWH.

Более интересные и практичные советы под катом.


Читать: https://habr.com/ru/post/663922/

Polymorphic Relationships: A database relationship your college probably won't teach you

Introduction
Most of the colleges with computer science course have a subject called Database Management system or DBMS where you are taught topics like Entity Relationships, Normalization, Relational Algebra, SQL, etc. Recently, I came across a new ...

Read: https://blogs.aayushkurup.dev/polymorphic-relationships-a-database-relationship-your-college-probably-wont-teach-you

Day 40/100

Designing Data-Intensive Applications [Book Highlights]
[ Part II : Chapter V ] Distributed Data
Reading Your Own Writes

Many applications let user submit and view the data immediately such as comment section.
So if the write goes to the leader and...

Read: https://rawdatareaders.hashnode.dev/day-40

Внедрение Postgres из Docker в Kubernetes

Создание контейнера для базы данных отнюдь не является излишеством. На самом деле, это позволит вам привнести все преимущества контейнеров в вашу БД.

Мы рассмотрим, как создавать контейнеры Postgres с помощью Docker и перезапускать их без потери данных, а в конце статьи с помощью нестандартного метода (использующего ConfigMaps и StatefulSets) мы развернём внутри подов Kubernetes — Postgres.


Читать: https://habr.com/ru/post/662784/

Why You Should Avoid Offset in Your DB Queries

We often use offset or skip in our database queries to fetch paginated data. This helps in implementing server-side pagination where it is not convenient to fetch all the data at once for performance reasons.
Real-world use cases for this might be wh...

Read: https://rrawat.hashnode.dev/why-you-should-avoid-offset-in-your-db-queries

Day 41/100

Designing Data-Intensive Applications [Book Highlights]
[ Part II : Chapter V ] Distributed Data
Multi-Leader Replication

Multi-datacenter operation - we have a database with replicas in several different datacenters. With a normal leader-based repl...

Read: https://rawdatareaders.hashnode.dev/day-41

Factors to consider when choosing a SQL client

Working with SQL through the command line can be tedious and difficult. But interacting with your data doesn't have to be that way. Instead, you can use a SQL client.
A SQL client is a front-end application that uses the services provided by a databa...

Read: https://arctype.hashnode.dev/factors-to-consider-when-choosing-a-sql-client

Announcing Spatial Studio 22.1

Oracle Spatial Studio is a no-code web tool for working with the Spatial features of Oracle Database. For general information about Spatial Studio and to get started, please click here. The latest release, Oracle Spatial Studio 22.1, introduces important new capabilities. In this post we explore several of these new capabilities.

Read: https://blogs.oracle.com/database/post/announcing-spatial-studio-221

Move Your Database into the Cloud with the Spring 2022 Update of OCI Database Migration

Announcement of the new Spring 2022 release of OCI Database Migration

Read: https://blogs.oracle.com/database/post/move-your-database-into-the-cloud-with-the-spring-2022-update-of-oci-database-migration

Building a CRM Web App With Python

What motivated me build this web app is my desire to be able to have a personal form app built with my own desired questions and database structure.
It took me a while to finally put this few lines of code together, but i am glad i did.
This CRM Web ...

Read: https://designegycreatives.hashnode.dev/building-a-crm-web-app-with-python

Build an Admin Panel using Redshift and Appsmith

Introduction
Different organizations rely on admin panels to manage, read and mutate data stored in their database. An admin panel is a console used to control features configurations of an application and manage content in that application. Admins i...

Read: https://appsmith.hashnode.dev/build-an-admin-panel-using-redshift-and-appsmith

How to connect Supabase and Nextjs

👋beautiful people in this first tutorial of connecting next js and supabase.
Step1: Go to supabase.com and click on start project and then this 👇page will appear.

You can be signing by creating GitHub account on github.com and then go back to supa...

Read: https://nextdev1111.hashnode.dev/how-to-connect-supabase-and-nextjs

D’Enterprise Account Executive à Regional Director : comment Lucile Tournier a accéléré sa carrière en France

Read: https://www.mongodb.com/blog/post/lucile-tournier-regional-director-france

How MongoDB Could Have Changed Star Wars and Saved the Jedi

Read: https://www.mongodb.com/blog/post/how-mongodb-could-have-changed-star-wars-saved-jedi

From Enterprise Account Executive to Regional Director: How Lucile Tournier Has Accelerated Her Career with MongoDB France

Read: https://www.mongodb.com/blog/post/enterprise-account-executive-regional-director-lucile-tournier-accelerated-career

Achieve cost-effective multi-Region resiliency with Amazon Aurora Global Database headless clusters

Read: https://aws.amazon.com/blogs/database/achieve-cost-effective-multi-region-resiliency-with-amazon-aurora-global-database-headless-clusters/