Hacker News: xyheme

Ask HN: Node v.s. Deno v.s. bun which will win in the end?

xyheme — Tue, 10 Oct 2023 06:00:33 +0000

Comments URL: https://news.ycombinator.com/item?id=37828959

Points: 1

# Comments: 1

Yantrajs: Another Competitor with Node.js

xyheme — Tue, 10 Oct 2023 05:59:30 +0000

Article URL: https://github.com/yantrajs/yantra

Comments URL: https://news.ycombinator.com/item?id=37828952

Points: 1

# Comments: 0

Ask HN: Is it ok to use CamelCase naming convention in C code base?

xyheme — Fri, 06 Oct 2023 08:41:59 +0000

Comments URL: https://news.ycombinator.com/item?id=37788400

Points: 1

# Comments: 4

Show HN: Using File System as Database

xyheme — Thu, 05 Oct 2023 19:42:18 +0000

Article URL: https://readonly.link/manuals/https://code-of-fidb.fidb.app/docs/manual/en.json

Comments URL: https://news.ycombinator.com/item?id=37783310

Points: 4

# Comments: 1

New comment by xyheme in "Ash HN: What if we use file system as database?"

xyheme — Thu, 05 Oct 2023 19:41:33 +0000

directory tree is not as easy to view and edit as JSON.

One big JSON file is harder.

I am not fancy, and the aim is to simply use file system as database.

Not fancy stuff like "database as file system as database".

New comment by xyheme in "Ash HN: What if we use file system as database?"

xyheme — Thu, 05 Oct 2023 19:19:44 +0000

Me and a lot of linux user friends are using btrfs.

New comment by xyheme in "Ash HN: What if we use file system as database?"

xyheme — Thu, 05 Oct 2023 19:18:32 +0000

I should thought about that.

New comment by xyheme in "Ash HN: What if we use file system as database?"

xyheme — Thu, 05 Oct 2023 19:17:43 +0000

Isn't WinFS the reverse of "file system as database"?

Which is "database as file system".

New comment by xyheme in "Ash HN: What if we use file system as database?"

xyheme — Thu, 05 Oct 2023 19:15:00 +0000

That all can be achieved by using file system as database.

Not even complicated to implement.

See couchDB for how to handle "what if two people are editing a file at once".

New comment by xyheme in "Ash HN: What if we use file system as database?"

xyheme — Thu, 05 Oct 2023 19:13:16 +0000

JSON is there for human to read a record of data by group.

I think it is only good to use directory as data table to store JSON data files, but not for JSON data properties.

New comment by xyheme in "Ash HN: What if we use file system as database?"

xyheme — Thu, 05 Oct 2023 14:08:21 +0000

Inode limits depends on the file system you use.

I am using Btrfs.

Btrfs inode limits is in a whole different league (whereas ext4's inodes are allocated at filesystem creation time and cannot be resized after creation, typically at 1-2 million, with a hard limit of 4 billion, btrfs's inodes are dynamically allocated as needed, and the hard limit is 2^64, around 18.4 quintillion.

> -- https://unix.stackexchange.com/questions/18388/what-are-the-...

New comment by xyheme in "Ash HN: What if we use file system as database?"

xyheme — Thu, 05 Oct 2023 13:54:51 +0000

> The main reason is that I can use a variety of tools to view and manipulate files.

This is also the reason I am researching this old "What if" problem.

Because I think comparing to some version of MySQL or PostgreSQL, files are stable, open and timeless.

New comment by xyheme in "Ash HN: What if we use file system as database?"

xyheme — Thu, 05 Oct 2023 13:51:23 +0000

Thanks for the reminder about meaningful pathnames :)

New comment by xyheme in "Ash HN: What if we use file system as database?"

xyheme — Thu, 05 Oct 2023 13:47:29 +0000

Thanks for the link.

I read it, and I think it describes bad ways of using file system, but there are also good ways.

Just like there are bad ways of using SQL databases, and there are also NoSQL, and bad ways of using NoSQL databases.

New comment by xyheme in "Ash HN: What if we use file system as database?"

xyheme — Thu, 05 Oct 2023 13:40:22 +0000

So that I can use subdirectory to model "has many" relationship, like "a user has many projects".

New comment by xyheme in "Ash HN: What if we use file system as database?"

xyheme — Thu, 05 Oct 2023 13:39:24 +0000

I think, unless column-oriented database is used, "one file per row" is similar to normal row-oriented database.

Maybe there are some benchmarks in the past.

New comment by xyheme in "Ash HN: What if we use file system as database?"

xyheme — Thu, 05 Oct 2023 13:35:07 +0000

Why not use one JSON file as one record of data, and use pathname as primary ID?

New comment by xyheme in "Ash HN: What if we use file system as database?"

xyheme — Thu, 05 Oct 2023 13:30:29 +0000

@jqpabc123

I agree.

We (developers) should also design tools to address the need of small scale web apps.

Maybe, we do not even need some general tools to use file system as database, just speak this method more often.

Ash HN: What if we use file system as database?

xyheme — Thu, 05 Oct 2023 11:56:54 +0000

For example:

users/{user}/index.json

users/{user}/projects/{project}/index.json

Comments URL: https://news.ycombinator.com/item?id=37777463

Points: 11

# Comments: 39

New comment by xyheme in "Show HN: Deploying subdomain-based routing like github.io"

xyheme — Wed, 13 Sep 2023 20:31:33 +0000

Thanks, I now learn double content s have this effect on SEO :)