Goodbye Tokyo Cabinet, hello PostgreSQL

http://briancarper.net/blog/545/goodbye-tokyo-cabinet-hello-postgresql

by khingebjerg • 16 years ago

48 14 16 years ago

wkornewald• 16 years ago

That guy has no clue how to use a non-relational DB (he even admits it) and he uses a DB that is wrong for his task and wonders why it's so hard.

The only point he makes is that the APIs for non-relational DBs are much too simple and limited, so you end up building lots of code on top to do the most trivial things.

What we really need is a way to generate indexes or materialized views on these DBs in a standardized way (see CouchDB, for an example).

wvenable2• 16 years ago

He has no clue how to use a relational DB either (he even admits it). How and why is this on the homepage?

briancarper3• 16 years ago

I have a (bit of a) clue how to use a relational DB. But not from Clojure two years ago, when the only interface was a very thin layer over JDBC.

As for why it's on the homepage, I don't think it belongs here either. The intended audience was rather more narrow than HN.

jonhohle• 16 years ago

While I like reading informative articles about hackers mastering their tools, this article doesn't have a lot of general purpose information, or mastery of tools.

A follow up article about the query architecture in all three implementations could be interesting: how he failed with a relational DB, how he failed with a key/value DB, how he succeeded with a relational DB. An article like that could have an interesting story arc and may include information applicable to other developers.

mahmud• 16 years ago

Moved a personal blog from MySQL to TokyoCabinet to Postgres? Why?

He writes:

"I have no idea how to use a key/value store database properly."

You don't need a database, or object-store or anything fancy to get decent performance for a personal blog. I use Chronicle and it spits out flat files; lighttpd uses sendfile(2) and everything is fast. FWIW, his blog software is one he wrote in Clojure:

http://github.com/briancarper/cow-blog/tree/0.2.0

For read-intensive applications, Sqlite3 would do just well.

This write-up should not influence anyone with respect to the (de)merits of MySQL, TokyoCabinet or Postgres.

briancarper3• 16 years ago

Why? Because it's a fun project to play with and a good way to learn. SQLite3 probably would work, yes.

I agree, this post shouldn't influence anyone. Not sure why it was submitted to HN.

khingebjerg• 16 years ago

I submitted it because I like reading about your experiments with your blog, and I thought others would like it too.

A person hacking on his own stuff, just to try out things, is hacker news to me.

seldo• 16 years ago

"I switched to TC to begin with because I was using SQL wrong, and it was too slow and clumsy. Once I figured out how to use SQL correctly, it was a no-brainer to go back."

While k-v stores and other NoSQL solutions have many great, valid use-cases, I expect there are many other people who switched to NoSQL stores on the basis that they were "faster" only to discover that they needed many of the features they'd left behind in SQL databases.

waratuman• 16 years ago

Point number 2 for why not to use TC is not very strong. If you need help installing a database perhaps you need to learn a little bit more before managing a webserver.

lo_fye• 16 years ago

Why is this on the front page? I could understand it IF he switched to PostgreSQL because it outperformed Tokyo Cabinet, but he switched back simply because he finally learned SQL. This isn't about technology, it's about his understanding. This story is lame.

apower• 16 years ago

People who don't understand database/relational-stuff should not touch db-related work.

benatkin• 16 years ago

Why not use both, especially if you're using your blog as a technical playground? Every time you update the document in the Tokyo cabinet, you could make appropriate changes to the PostgreSQL tables, and that way you wouldn't have to worry about writing clever queries for tags.

(Disclaimer: I don't know what I'm talking about. If someone else had mentioned this idea, I wouldn't have said anything.)

Goodbye Tokyo Cabinet, hello PostgreSQL

Related Stories