squashql VS todo.txt-cli

I am building a SQL like query engine with a typescript query builder. It aims to provide multidimensional query capabilities (think about olap cube). The query engine is compatible with several databases (sucks, clickhouse, bigqueryx, snowflake...). Our users are developers building decision making applications. They are using for instance duckdb to develop locally their application and use a cloud provider in production. Here's the link https://github.com/squashql/squashql. Feel free to ask me any questions.

I am building a sort of SQL query engine compatible with several databases (bigquery, snowflake, duckdb, clickhouse, spark) in order to add more power to the SQL query language bringing multi dimensional capabilities to SQL (and more). The project was released few months ago and available on GitHub https://github.com/squashql/squashql

I am building squashql-js for a slightly different use case (database agnostic SQL-like Typescript query builder among others) but Kysely and pypika (for Python) have been a great source of inspiration.

https://github.com/squashql/squashql/blob/main/documentation...

FSNotes for macOS and iOS is one I used for a little while.

https://fsnot.es/

todo.txt is another thing that comes to mind.

http://todotxt.org/

And of course pretty much all of *nix.

Since at least 2012 I've also been using a text file format from http://todotxt.org/ and more recently I wrote a program that takes a crontab-like list to pre-generate entries on a daily, by-day-name (every Sunday for example), and I also pull in a list of holidays from gov.uk, so they are also populated.

[^1]: (https://github.com/blacksmithgu/obsidian-dataview)

It's a web app implementing the todo.txt format (see http://todotxt.org/). It's an exercise to learn frontend currently, I doubt I could successfully monetize it. Would appreciate any feedback!

That format is really similar to todo.txt format, worth taking a look at http://todotxt.org/ (which in turn has application links).

For todo and schedule I use todo.txt (http://todotxt.org/) a plain file managed by scripts which build agenda and plumber to keep track of unique keys.

The ToDo.Txt format makes it easy to use across devices/software, but this is really limited to ToDos.

Here’s the todo.sh features for those interested. There are several addons for it as well: https://github.com/todotxt/todo.txt-cli

Good idea, something similar to todotxt.org. But no 1) iPhone app 2) you need to sigh up and keep your notes at developers servers 3) subscriptions?! come on!

There are a couple different routes you can go down. If your goal is to learn CLI stuff, it's hard to beat using shell-scripting for a simple app like a todo manager. Storing them in a plain-text file, a little sed/grep/awk and you're well on your way. For inspiration & hints, you might check out https://todotxt.org However, you can rapidly hit performance issues and limitations on available tooling if you stick to just POSIX tools.