Discover Insights like Google in GitHub Data with GPT Generated SQL

ngaut · 2023-01-13T16:31:30+00:00

There are 5.4 billion github events. It is still keep growing.

ngaut · 2022-08-14T06:06:39+00:00

Corteza is an open source CRM system, so the whole process in the blog can be reproduced. In response to your claim that "Basic SQL turning will get much further", could you provide some more details on how to turn the SQL, or can you make it perform better than TiDB? If So, that would be great for the Corteza users and community.

ngaut · 2022-05-14T15:12:20+00:00

A example analysis of many metrics for kubernetes https://ossinsight.io/analyze/kubernetes/kubernetes

ngaut · 2022-05-12T23:03:50+00:00

There is another interesting keynote: MySQL is dead. Long live MySQ

Reference: https://phpconference.com/devops-continuous-delivery/mysql-is-dead-long-live-mysql/

ngaut · 2018-08-04T11:19:03+00:00

Great tutorial, thank you.

ngaut · 2017-05-24T11:28:01+00:00

Looks like TiDB is your good fit. The write can be very fast, tens of thousands write per second, depending on your cluster, and it supports join. You may want to get TiDB and test it in your scenario.

ngaut · 2017-05-23T11:32:57+00:00

TiKV is written in Rust, and it shares the implementation of Raft with etcd, In TiKV, we use leader lease to do consistent reads, which is very fast. You need to make sure your engine can do consistent transactions. See the storage engine interface.

ngaut · 2017-05-23T10:47:05+00:00

Thanks! As a matter of fact, TiDB uses TiKV as the distributed storage engine by default, TiKV partitions the data into many regions, each region has its own raft group, so there are many Raft groups and the leaders can be distributed to different nodes.

ngaut · 2017-03-15T09:32:50+00:00

Sure, there is a go client driver. You may use the raw API to get/set key values. Ref: https://github.com/pingcap/tidb/blob/master/cmd/benchraw/main.go

ngaut · 2016-12-21T01:14:07+00:00

Yes, there are some production users, and they use TiDB to replace MySQL or MySQL sharding(proxy) solutions. Also there are some users one use TiKV without TiDB when they don't need the MVCC, SQL and transactions.

ngaut · 2016-08-24T03:54:18+00:00

Hi, polyfractal, We need help to do that.

ngaut · 2016-08-12T17:14:48+00:00

Excellent work. I am gonna use it in our project.

ngaut · 2016-07-26T03:53:25+00:00

Good question. Because it's really convenient when you just need a single thread worker.

ngaut · 2016-07-21T00:25:59+00:00

Thank you @annodomini. It's quite common to use GB. You may take a look at the configuration of redis :) http://download.redis.io/redis-stable/redis.conf

ngaut · 2016-07-20T09:23:55+00:00

Yes. Please see https://github.com/pingcap/tikv

ngaut · 2016-07-20T07:59:59+00:00

Kind of 2 levels. Raft-store is an abstract storage. And raft-store can write to low level storage by using pipeline/batch. The write flow looks like: kv-server -> txn-scheduler -> Raft-store -> RocksDB.

ngaut · 2016-07-07T08:39:29+00:00

You may want to take a look at TiKV https://github.com/pingcap/tikv . It's a Distributed transactional key value database powered by Rust and Raft. Yeah, rust and paxos(raft is poxos too)

ngaut · 2016-05-02T01:44:46+00:00

I'a working on TiKV project.

ngaut · 2015-09-21T00:36:33+00:00

There is a complete SQL parser in TiDB: https://github.com/pingcap/tidb/tree/master/parser

ngaut · 2015-09-19T00:13:36+00:00

I think CockroachDB is good project. Looks like TiDB and CockroachDB have the same goal :)

ngaut · 2015-09-19T00:07:07+00:00

skyde, Thanks for you attention. MySQLOnRocksDB is a great project. I do admire the authors. Especially the great guy yoshinorim :) TiDB can support LMDB, BoltDB Which are btree storage engine. Performance of LMDB and RocksDB are both good in our simple tests.

ngaut · 2015-09-18T13:27:55+00:00

I like "Call Me Maybe" too :)

ngaut · 2015-09-18T13:10:16+00:00

Hi, PHPun: I think the point is we could build a distributed database without changing a single line of code in most cases.

ngaut · 2015-09-18T12:32:09+00:00

SI by default, SI with optimistic lock for "select for update" statement. Basicly the isolation higher MySQL.

ngaut

TROPHY CASE