May 14, 2025
seen from Türkiye
seen from Indonesia
seen from Netherlands
seen from United States
seen from Italy
seen from France
seen from Malaysia
seen from China
seen from China
seen from Germany
seen from Brazil
seen from Malaysia
seen from United States
seen from Italy
seen from China
seen from Yemen
seen from Malaysia
seen from Canada
seen from China
seen from Albania
One more weekly task added 🫠
New to SQL and RDBMS concepts? Checkout this ByteByteGo infographic.
(via EP90: How do SQL Joins Work? - ByteByteGo Newsletter)
低 Downtime 將 4TB 的 PostgreSQL 9.6 資料庫升級到 13 的故事
低 Downtime 將 4TB 的 PostgreSQL 9.6 資料庫升級到 13 的故事
前幾天在 Hacker News 首頁上看到的文章，講怎麼把一個 4TB 的 PostgreSQL 從 9.6 升級到 13 的故事：「How we upgraded our 4TB Postgres database (retool.com)」，原文在「How Retool upgraded our 4 TB main application PostgreSQL database」，翻了一下 LinkedIn，這篇文章的作者 Peter Johnston 在 Retool 掛的是 Security Software Engineer，另外他也有在 Hacker News 上的討論出現 (帳號是 mrbabbage)，可以搜尋翻翻看他的回覆。 看完文章後發現方法的概念其實不難，主要是要找到對的工具來用。基本的想法是先生出一個 initial dump，然後架構 logical…
View On WordPress
SQL CHEAT SHEET
SQL STUDY MATERIAL
View On WordPress
What Is SQL?
SQL is a short form of structured query language, and is sometimes referred to as S-Q-L or sometimes as See-Quell. This language is primarily designed to store data in related database management systems. It is a special tool used by professionals to manage structured data (data stored in the form of tables). You can easily create and manage a database, access and modify table rows and columns,…
View On WordPress
Difference b/w dbms vs rdbms, rdbms vs dbms, dbms, rdbms, Learn SQL tutorial for beginners and professionals with sql, Learn SQL (Structured Programming Language) in simple and easy steps starting from basic to advanced concepts with examples including database concepts, Overview, RDBMS Concepts, Databases, SQL Syntax, Data Types, Operators, Expressions, CREATE, DROP or DELETE, SELECT Database, USE Statement, CREATE, DROP or DELETE Table, INSERT, SELECT Query, WHERE Clauses, AND and OR Conjunctive Operators, UPDATE, DELETE Query, LIKE Clause, TOP, LIMIT or ROWNUM, ORDER BY Clause, GROUP BY, DISTINCT Keyword, SORTING Results, Constraints, Using Joins, UNIONS CLAUSE, NULL Values, Alias Syntax, Indexes, ALTER, TRUNCATE TABLE Command, Using Views, Having Clause, Transactions, Wildcard Operators, Date Functions, Temporary, Clone Tables, Sub Queries, Using Sequences, Handling Duplicates, Injection, insert, tutorial, examples, update, delete, select, join, database, table, join,
Top 15 differences between DBMS and RDBMS
Read full post : http://onlinetutorialhub.blogspot.com/2017/11/dbms-vs-rdbms-sql.html
Follow us on : #Blog : https://goo.gl/pYVwZ5 #Facebook : https://goo.gl/zLbihL #twitter : https://goo.gl/dvZFJF #Google+ : https://goo.gl/MXFsc9 #Pinterest : https://goo.gl/hWgQ2i #Instagram : https://goo.gl/ovqzMw
Amazon RDS 支援 readonly instance 當作 Multi AZ 的機器了
Amazon RDS 支援 readonly instance 當作 Multi AZ 的機器了
從來沒在用 RDS 的 Multi AZ，所以根本沒注意到居然沒這個功能：「New Multi-AZ deployment option for Amazon RDS for PostgreSQL and for MySQL; increased read capacity, lower and more consistent write transaction latency, and shorter failover time (Preview)」。 看起來 (加上印象中) 之前的 Multi AZ 是另外一台機器先開著但不能用： In the case of an infrastructure failure, Amazon RDS performs an automatic failover to the standby, so that database operations…
View On WordPress