Hacker News new | past | comments | ask | show | jobs | submit | b33f's comments login

Couchbase mobile has been doing this for over a decade and early versions of membase 15 years ago were using a sqlite backend as a noSQL JSON datastore

I'm using something like this for a small personal project that's only going to have a couple of users. Basically, just an app for myself and my girlfriend for all of the various restaurants, movies, recipes, tv shows, locations, etc. that we plan to go to/do at some point in the future. It's basically just a glorified todo list that uses APIs (TheMovieDataBase, OpenStreetMap, etc.) to grab additional metadata and images to present everything nicely

I want us both to be able to make notes/add ratings to each item, so the set of tables looks like this:

    - TodoItems
    - Notes
    - Ratings
Where every TodoItem can have multiple Ratings/Notes attached. Because each of the TodoItems is going to be of a different type with different metadata depending on the type of item (IMDB/TMDB id, image url, GPS location), and I want it to be extensible in future, its schema has ended up looking like this:

    CREATE TABLE TodoItems (
      id INTEGER PRIMARY KEY NOT NULL,
      kind TEXT NOT NULL,
      metadata BLOB NOT NULL
    );
With SQLite's json manipulation functions, it's actually pretty pleasant to work with. As it grows I might end up adding some indexes, but for now the performance seems like it will be fine for this very low traffic use case. And it makes deployment and backups incredibly simple.

Postgres added native support for JSON in 2012. People have been using RDBMS to store denormalized data and even as a key-value store for way longer than that. In fact, it's very hard not to do that

Aiko is a free app for iOS and macOS that also uses whisper for local TTS


No Place to Hide By Glenn Greenwald and Uncanny Valley By Anna Wiener


Start investing for retirement and long-term care. The best time to start is yesterday, compound interest is a beautiful thing.


Jan is a local app for running LLM models on Windows/Linux/MacOS, including an OpenAI compatible API.


The really nice part of Whisper is being able to use it offline and on-device, it seems whisper memos is uploading your audio and notes to a server of unknown security, confidentiality etc.

I like Aiko for on-device transcription both in macOS and iOS https://apps.apple.com/us/app/aiko/id1672085276


Whisper Memos uses OpenAI API. The upside is that it uses the largest model - that would take 2GB on your iPhone.


If you're talking about flip phones and trying to protect against an eavesdropper of a phone call or SMS, then there's no point. The network that these phones used is full of holes already https://en.wikipedia.org/wiki/Signalling_System_No._7#Protoc...


In MacOS or Linux, you can use openssl on the CLI easily.

$ echo -n "private-message" | openssl enc -e -aes-256-cbc -a -salt enter aes-256-cbc encryption password: Verifying - enter aes-256-cbc encryption password:

Then to decrypt echo 'U2Fsxxxxxxxxxx' | openssl aes-256-cbc -a -d -salt


I think the CLI is not the problem. More that there is a maintained implementation in Ruby, Rust, Go, JS, PHP, .... You get the idea.

I suppose openssl is supported in all of them, but it only provides primitives. I still have to manually define a file format to store the salt and such.



I don't understand how the size of the circles are determined. For example why is the UK with 439 the same size as the UAE with 15 ?


*Fixed that bug.

I adjusted the circle size to try and make some of the smaller ones more visibly, but it had messed up proportions entirely. I reverted back to smaller circles so it doesn't break like that, you'll just have to read the hover text to see the full information.


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: