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
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
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/
Создание контейнера для базы данных отнюдь не является излишеством. На самом деле, это позволит вам привнести все преимущества контейнеров в вашу БД.
Мы рассмотрим, как создавать контейнеры 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
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
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
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
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
Oracle
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…
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
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
Oracle
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
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
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
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
👋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
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
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
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/
Read: https://aws.amazon.com/blogs/database/achieve-cost-effective-multi-region-resiliency-with-amazon-aurora-global-database-headless-clusters/
Jobs 3E May 2022 Senior Enterprise Data Architect
Role
Verisk 3E is looking for an experienced Enterprise Data Architect to join the team. Although our preference would be for someone to sit locally with the team in Carlsbad, CA, fully remote candidates based in the United States will be considered....
Read: https://kb.mdmdm.org/jobs-3e-may-2022-senior-enterprise-data-architect
Role
Verisk 3E is looking for an experienced Enterprise Data Architect to join the team. Although our preference would be for someone to sit locally with the team in Carlsbad, CA, fully remote candidates based in the United States will be considered....
Read: https://kb.mdmdm.org/jobs-3e-may-2022-senior-enterprise-data-architect
How Oracle builds REST APIs on top of SQL
While SQL may appear on just about every list of skills an IT professional today should strive to attain, SQL isn't always the best way to interact with your data.
Source: insights.dice.com
Using SQL assumes you actually have access to a database......
Read: https://thatjeffsmith.hashnode.dev/how-oracle-builds-rest-apis-on-top-of-sql
While SQL may appear on just about every list of skills an IT professional today should strive to attain, SQL isn't always the best way to interact with your data.
Source: insights.dice.com
Using SQL assumes you actually have access to a database......
Read: https://thatjeffsmith.hashnode.dev/how-oracle-builds-rest-apis-on-top-of-sql
April Round-up: Multiple Widget Reflow, Readable URLs, More Product Updates
If you’ve followed Appsmith for a while, you know that we can do a lot in 30 days!
I am here to give you all the deets; follow along!
Introducing Multiple Widget Reflow
We’ve received a lot of positive feedback on our new drag and drop experience. Us...
Read: https://appsmith.hashnode.dev/april-round-up-multiple-widget-reflow-readable-urls-more-product-updates
If you’ve followed Appsmith for a while, you know that we can do a lot in 30 days!
I am here to give you all the deets; follow along!
Introducing Multiple Widget Reflow
We’ve received a lot of positive feedback on our new drag and drop experience. Us...
Read: https://appsmith.hashnode.dev/april-round-up-multiple-widget-reflow-readable-urls-more-product-updates
PDB Management for Exadata Database Services and Database Cloud VM
Announcement of PDB management for Exadata Database Service on Cloud@Customer, Exadata Database Service on Dedicated Infrastructure, and DBCS VM.
Read: https://blogs.oracle.com/database/post/pdb-management-for-exadata-database-services-and-database-cloud-vm
Announcement of PDB management for Exadata Database Service on Cloud@Customer, Exadata Database Service on Dedicated Infrastructure, and DBCS VM.
Read: https://blogs.oracle.com/database/post/pdb-management-for-exadata-database-services-and-database-cloud-vm
Oracle
PDB Management for Exadata Database Services and Database Cloud VM
Announcement of PDB management for Exadata Database Service on Cloud@Customer, Exadata Database Service on Dedicated Infrastructure, and DBCS VM.
Correlation With Rapid Miner
Sarah is a regional sales manager for a nationwide supplier of fossil fuels for home heating.
Recent volatility in market prices for heating oil specifically, coupled with wide variability in the size of each order for home heating oil, has Sarah con...
Read: https://designegycreatives.hashnode.dev/correlation-with-rapid-miner
Sarah is a regional sales manager for a nationwide supplier of fossil fuels for home heating.
Recent volatility in market prices for heating oil specifically, coupled with wide variability in the size of each order for home heating oil, has Sarah con...
Read: https://designegycreatives.hashnode.dev/correlation-with-rapid-miner
SQL FUNCTION WHERE(How to get the rows you want)
Here are examples of SQL Where Function
Matching Values
Case
Clause
Matching Values Inexactly
Matching On Calculations
Matching Text Value Inexactly With LIKE
Link To Dataset For Practice
Read: https://designegycreatives.hashnode.dev/sql-function-wherehow-to-get-the-rows-you-want
Here are examples of SQL Where Function
Matching Values
Case
Clause
Matching Values Inexactly
Matching On Calculations
Matching Text Value Inexactly With LIKE
Link To Dataset For Practice
Read: https://designegycreatives.hashnode.dev/sql-function-wherehow-to-get-the-rows-you-want
👎1