How to create and test a GitHub Action that generates types from Supabase database
Recently I started a side project Billy, a React Native bill tracker app which uses Supabase for user management & database. Initially, I wasn’t too sure of all the fields that the Bill model should have, so as I developed the project, the data model...
Read: https://blog.esteetey.dev/how-to-create-and-test-a-github-action-that-generates-types-from-supabase-database
Recently I started a side project Billy, a React Native bill tracker app which uses Supabase for user management & database. Initially, I wasn’t too sure of all the fields that the Bill model should have, so as I developed the project, the data model...
Read: https://blog.esteetey.dev/how-to-create-and-test-a-github-action-that-generates-types-from-supabase-database
Creating A Hot Standby In PostgreSQL
In today’s post, I will show you Creating A Hot Standby In PostgreSQL. PostgreSQL Community 13 Installation: [crayon-624d7770b7251200400556/] To create Stanby, we need two servers with Postgresql Community 13 installed. If you have not installed, you can install from the link above. There are operations that need to be done on both the master and …
Read: Creating A Hot Standby In PostgreSQL.
In today’s post, I will show you Creating A Hot Standby In PostgreSQL. PostgreSQL Community 13 Installation: [crayon-624d7770b7251200400556/] To create Stanby, we need two servers with Postgresql Community 13 installed. If you have not installed, you can install from the link above. There are operations that need to be done on both the master and …
Read: Creating A Hot Standby In PostgreSQL.
Securely connect to an Amazon RDS or Amazon EC2 database instance remotely with your preferred GUI
Read: https://aws.amazon.com/blogs/database/securely-connect-to-an-amazon-rds-or-amazon-ec2-database-instance-remotely-with-your-preferred-gui/
Read: https://aws.amazon.com/blogs/database/securely-connect-to-an-amazon-rds-or-amazon-ec2-database-instance-remotely-with-your-preferred-gui/
QVentures and MongoDB Partner to Support the Next Generation of B2B SaaS Founders
Read: https://www.mongodb.com/blog/post/qventures-mongodb-partner-support-next-generation-b2b-saas-founders
Read: https://www.mongodb.com/blog/post/qventures-mongodb-partner-support-next-generation-b2b-saas-founders
Introducing Gap Filling for Time Series Data in MongoDB 5.3
Read: https://www.mongodb.com/blog/post/introducing-gap-filling-time-series-data-mongodb-5-3
Read: https://www.mongodb.com/blog/post/introducing-gap-filling-time-series-data-mongodb-5-3
Cut-over logic in vitess schema migrations
Read: https://vitess.io/blog/2022-04-06-online-ddl-vitess-cut-over/
Read: https://vitess.io/blog/2022-04-06-online-ddl-vitess-cut-over/
Migrate self-managed MariaDB to Amazon Aurora MySQL
Read: https://aws.amazon.com/blogs/database/migrate-self-managed-mariadb-to-amazon-aurora-mysql/
Read: https://aws.amazon.com/blogs/database/migrate-self-managed-mariadb-to-amazon-aurora-mysql/
Building a Blog with FastAPI, MySQL, SQLAlchemy, and Alembic
In this tutorial you'll learn how to build an API using FastAPI and MySQL. we'll be interacting with the database using mysqlclient, sqlalchemy, and alembic for migrations.
App Overview
these are the endpoints we are going to be building in this app...
Read: https://pneuma.hashnode.dev/building-a-blog-with-fastapi-mysql-sqlalchemy-and-alembic
In this tutorial you'll learn how to build an API using FastAPI and MySQL. we'll be interacting with the database using mysqlclient, sqlalchemy, and alembic for migrations.
App Overview
these are the endpoints we are going to be building in this app...
Read: https://pneuma.hashnode.dev/building-a-blog-with-fastapi-mysql-sqlalchemy-and-alembic
Readable MultiAZ Cluster with AWS RDS MySQL under the hood.
Read: http://mydbops.wordpress.com/?p=11236
Read: http://mydbops.wordpress.com/?p=11236
Understanding Triggers in SQL Server
A trigger is an object having a collection of code or codes which fires automatically when an event occurs in the database server. The most used database events which cause the database to execute triggers are DDL(DATA DEFINITION LANGUAGE) Event and ...
Read: https://mssqlserver.dev/understanding-triggers-in-sql-server-with-examples
A trigger is an object having a collection of code or codes which fires automatically when an event occurs in the database server. The most used database events which cause the database to execute triggers are DDL(DATA DEFINITION LANGUAGE) Event and ...
Read: https://mssqlserver.dev/understanding-triggers-in-sql-server-with-examples
Import sample database into AWS RDS MySQL using Workbench & Shell
Bytebase open-sourced an Employee sample database for MySQL https://github.com/bytebase/employee-sample-database-mysql with two variations: A Full dataset (~170 MB) including 300024 employee records and a Small dataset (~6 MB) including 10000 employe...
Read: https://devrel.bytebase.com/import-sample-database-into-aws-rds-mysql-using-workbench-and-shell
Bytebase open-sourced an Employee sample database for MySQL https://github.com/bytebase/employee-sample-database-mysql with two variations: A Full dataset (~170 MB) including 300024 employee records and a Small dataset (~6 MB) including 10000 employe...
Read: https://devrel.bytebase.com/import-sample-database-into-aws-rds-mysql-using-workbench-and-shell
👍1
Анонс стрима 07.04.22: Сжать данные в SQL Server в десятки раз, а ускорить запросы в сотни
У меня в планах на этот год на Хабре было опубликовать пару статей по колумсторам и XML. Материала за годы накопилось предостаточно и выходило на 30..40 страниц текста - фактически мини-книга. Но когда за окном Градами и прочей дичью херячили месяц... оно как-то не складывалось настроиться на конструктив. Вначале агрессия на виновников этой дичи, потом паника за близких... печаль что все планы порушились и непонятно что ждать. А сейчас прям совсем ровно на все жизненные трудности ибо как-то получается разруливать все и помогать людям.
Так вот... со знакомым решили вернуться к прежней теме и постримить сегодня о колумсторах. Без политики, срача и прочего. Очень много шутеек о том как живеться в условиях спецоперации и немного полезной инфы о колумсторах на SQL Server.
Кто хочет из коллег послушать: https://www.youtube.com/watch?v=wXH3fUN0PsM
You are welcome!
...
Читать: https://habr.com/ru/post/659541/
У меня в планах на этот год на Хабре было опубликовать пару статей по колумсторам и XML. Материала за годы накопилось предостаточно и выходило на 30..40 страниц текста - фактически мини-книга. Но когда за окном Градами и прочей дичью херячили месяц... оно как-то не складывалось настроиться на конструктив. Вначале агрессия на виновников этой дичи, потом паника за близких... печаль что все планы порушились и непонятно что ждать. А сейчас прям совсем ровно на все жизненные трудности ибо как-то получается разруливать все и помогать людям.
Так вот... со знакомым решили вернуться к прежней теме и постримить сегодня о колумсторах. Без политики, срача и прочего. Очень много шутеек о том как живеться в условиях спецоперации и немного полезной инфы о колумсторах на SQL Server.
Кто хочет из коллег послушать: https://www.youtube.com/watch?v=wXH3fUN0PsM
You are welcome!
...
Читать: https://habr.com/ru/post/659541/
What Directory Am I In Linux?
In today’s article, we will look for an answer to the question What Directory Am I In Linux? Pwd : With this command, we can see which directory we are in. We entered the /var/log/ directory in my article named “entering the directory in Linux”. Let’s verify that we are in that directory by typing …
Read: What Directory Am I In Linux?.
In today’s article, we will look for an answer to the question What Directory Am I In Linux? Pwd : With this command, we can see which directory we are in. We entered the /var/log/ directory in my article named “entering the directory in Linux”. Let’s verify that we are in that directory by typing …
Read: What Directory Am I In Linux?.
Amazon Aurora PostgreSQL blue/green deployment using fast database cloning
Read: https://aws.amazon.com/blogs/database/amazon-aurora-postgresql-blue-green-deployment-using-fast-database-cloning/
Read: https://aws.amazon.com/blogs/database/amazon-aurora-postgresql-blue-green-deployment-using-fast-database-cloning/
Forward, Together: How MongoDB Invests in (and Helps Grow) Modernization Consultancies for Our Customers
Read: https://www.mongodb.com/blog/post/forward-together-how-mongodb-invests-helps-grow-modernization-consultancies-customers
Read: https://www.mongodb.com/blog/post/forward-together-how-mongodb-invests-helps-grow-modernization-consultancies-customers
Notion is underrated
https://curious-woolen-937.notion.site/ASSIGNMENTS-e4aeb29e51e345b5b326d67dfd8207c8
I'm learning to create templates onNotion Course practice
the notion and later will sell them.
Read: https://shreyashbuilds.hashnode.dev/notion-is-underrated
https://curious-woolen-937.notion.site/ASSIGNMENTS-e4aeb29e51e345b5b326d67dfd8207c8
I'm learning to create templates onNotion Course practice
the notion and later will sell them.
Read: https://shreyashbuilds.hashnode.dev/notion-is-underrated
A List of PostgreSQL Commands for Beginners
Yes, My First-ish Time
I've dabbled with SQL a couple times, but never truly dove all the way in. I took Google's Data Analytics certification last year, and it gave a nice cursory overview of SQL, Big Query, Tableau and the R language. But, I'm read...
Read: https://blog.eamonncottrell.com/a-list-of-postgresql-commands-for-beginners
Yes, My First-ish Time
I've dabbled with SQL a couple times, but never truly dove all the way in. I took Google's Data Analytics certification last year, and it gave a nice cursory overview of SQL, Big Query, Tableau and the R language. But, I'm read...
Read: https://blog.eamonncottrell.com/a-list-of-postgresql-commands-for-beginners
Auditing & Implementing Data Change Capture with Triggers in SQL Server
Database Auditing is a process of tracking and logging all events and capturing data changes in database objects, it not only helps businesses but is also a compliance requirement.
In most cases when we want to implement capturing of data changes in ...
Read: https://mssqlserver.dev/auditing-and-implementing-data-change-capture-with-triggers-in-sql-server
Database Auditing is a process of tracking and logging all events and capturing data changes in database objects, it not only helps businesses but is also a compliance requirement.
In most cases when we want to implement capturing of data changes in ...
Read: https://mssqlserver.dev/auditing-and-implementing-data-change-capture-with-triggers-in-sql-server