PostgreSQL VS TiDB

PostgreSQL Reviews

TiDB Reviews

PostgreSQL mentions (15)

• Perfect Elixir: Environment Setup

  I’m on MacOS and erlang.org, elixir-lang.org, and postgresql.org all suggest installation via Homebrew, which is a very popular package manager for MacOS. - Source: dev.to / about 2 months ago

• Rust & MySQL: connect, execute SQL statements and stored procs using crate sqlx.

  According to the documentation, crate sqlx is implemented in Rust, and it's database agnostic: it supports PostgreSQL, MySQL, SQLite, and MSSQL. - Source: dev.to / 8 months ago

• Really tired. Is PostgreSQL even runnable in Windows 10? pgAdmin4 stucks at Loading whatever I try.

  Solution is just downloading and installilng pgAdmin from official pgAdmin homepage version, not the one that is included in the postgresql.org package. Source: 10 months ago

• Why SQL is right for Infrastructure Management

  SQL immediately stands out here because it was designed for making relational algebra, the other side of the Entity-Relationship model, accessible. There are likely more people who know SQL than any programming language (for IaC) or data format you could choose to represent your cloud infrastructure. Many non-programmers know it, as well, such as data scientists, business analysts, accountants, etc, and there is... - Source: dev.to / about 1 year ago

• Ask HN: Hunting for a Framework

  Vapor[0] based on Swift. Advantage of this is that you don't have to evaluate multiple frameworks for Swift and suffer paralysis by analysis. All the Swift community is behind one framework. The next is Actix[1] based on Rust. There are many frameworks in Rust and most of them have not reached 1.0 And which framework will survive becomes a question. Other not so well-known is Wt[2] based on C++. This actually is... - Source: Hacker News / over 1 year ago

TiDB mentions (15)

• A MySQL compatible database engine written in pure Go

  Tidb has been around for a while, it is distributed, written in Go and Rust, and MySQL compatible. https://github.com/pingcap/tidb. - Source: Hacker News / 27 days ago

• Ask HN: Who is hiring? (January 2023)

  PingCAP | https://www.pingcap.com | Database Engineer, Product Manager, Developer Advocate and more | Remote in California | Full-time We work on a MySQL compatible distributed database called TiDB https://github.com/pingcap/tidb/. - Source: Hacker News / over 1 year ago

• Apache Pegasus – A a distributed key-value storage system

  Isn't TiDB built on top of TiKV?[0] [0]: https://github.com/pingcap/tidb. - Source: Hacker News / over 1 year ago

• What is your experience with mixed workload (OLTP and OLAP) databases?

  OLTP usually comes with high throughput of transactions, which means usually write(e.g., IUD - insert, update, delete) to read (e.g., select) ratio is above 4 or 5 or even higher. There are some good benchmarks to test OLTP workload like TPC-C (https://www.tpc.org/tpcc/), and some benchmarks to test OLAP workload like TPC-H (https://www.tpc.org/tpch/). For mixed or hybrid OLTP and OLAP (it's called HTAP, see this... - Source: Hacker News / almost 2 years ago

• NewDB: Fate of an Open Source Database

  I am very agree with some options of this blog. As the maintainer of the open source distributed database TiDB https://github.com/pingcap/tidb, we also face the same problem of choice. We have a community version, an enterprise version(of course, we must sell it to our customers to earn money) and also a cloud service named TiDB cloud. Seven years before, we started to build TiDB to solve MySQL sharding problem,... - Source: Hacker News / almost 2 years ago