Hacker News Reader

justsomeuseron JSONiq: JSON Query Language

I already have a JSON query language - it’s JavaScript.

> Queries are 80% shorter than imperative code

From the examples they look the same length as the corresponding JS I would write, maybe slightly longer.

What are the advantages to using this language over JS?

JS has a fast JIT which would make filtering data fast. How does this query language compare in performance? Does it have indexes?

justsomeuseron Goodbye CSS Modules, Hello TailwindCSS

OP means you are looking at both the structure of the DOM (JSX) and the CSS (className).

The “tailwind” effect is due to fast feedback and iteration - there is no jumping between two files (DOM file and CSS file).

Of course this also leads components eventually having huge lists of classes.

But I think the fast feedback loop is worth it, because with 2D visual artefacts and the complex CSS language, often the only way to learn/get what you want is change a little, reflect, change a little, … etc.

justsomeuseron Show HN: The most popular newspaper in Denmark, and its insane font sizes

I like it. Most websites split your focus into a million visual things showing at the same time.

This forces your focus to a single element. It’s quite calming compared to other news sites. I only speak English though.

justsomeuseron Async Ruby

It references the function return type:

Colored = Promise<T>

Colorless = T

In "colorless" async/await, async functions are implicit (no async keyword), and when called, the compiler auto-unwraps the promise, so everything looks like "sync" code but any function stack could "save and resume" at an "async point".

justsomeuseron Goodbye Microsoft SQL Server, hello Babelfish

I think the issue is that you cannot test 100% of your SQL queries the way you can with a compiled language.

What if there is an “if” branch taken 1 in 1000 times? You would not encounter the error during development.

justsomeuseron Nearly a third of new code on GitHub is written with AI help

Well, Google is an AI.

justsomeuseron My ideal Rust workflow

I upgraded from a 2014 MacBook Pro (dual core), it is at least 2x faster for both full and incremental Rust builds.

justsomeuseron My ideal Rust workflow

This is how I keep feedback loops short:

- IntelliJ tells me any type issues instantly (I find this makes up some of the time for not having a REPL).

- Small tests kind of work like a REPL.

- watch.sh running in a terminal, re-compiles and runs the code I am working on. In your web server example, I would be testing the units rather than the whole composite program. I can click file references to jump to the error.

- Fast machine (M1)

justsomeuseron How we built a serverless SQL database

Can I connect using an SSH tunnel (without the SSL cert)?

justsomeuseron People who ‘can’t fit into jeans they wore aged 21’ risk developing diabetes

I eat these daily. How would I know my risk of this?

justsomeuseron Data scientists shouldn’t need to know Kubernetes

Sure they don’t need to know how to schedule their computations on CPU’s as another team member can handle it, but I think the reality is that if you work in software you have to constantly be learning.

justsomeuseron Ask HN: How do I get fit and healthy as a software engineer?

https://www.amazon.co.uk/Kettlebell-Simple-Sinister-Revised-...

“Simple Sinister” is a program with kettle bell swings and Turkish get ups - it is a good basic program for general core strength when you have limited time. Look at what Tim Ferriss has to say about the swings.

Add https://stronglifts.com/5x5/ too.

Add some cardio you enjoy, preferably daily and at least 20min, but not too much you are exhausted. You should still feel quite fresh afterwards.

Eat more vegetables, try to hit 5 portions a day minimum. Dr Weils “Optimum nutrition” book is a great book on the basics.

justsomeuseron Chekhov's Gun

I also think that the rifle can “set the frame” for the character or scenario.

E.g. that the character is the kind of person who owns guns.

It does not go off or get used, but the viewer will use that as input to make a judgement about the character.

justsomeuseron The Feds Want to Know What the McFuck Is Going on with the McFlurry Machines

(McFlurry)

justsomeuseron The Feds Want to Know What the McFuck Is Going on with the McFlurry Machines

All those franchises are just making a flurry outta nothin

justsomeuseron Write an SQL query builder in 150 lines of Python

With stored procedures you run your code inside of the SQL server process.

With SQLite, your entire application IS the process, and your SQLite data moves from disk to your app processes RAM.

I think the SQLite model is much better as you get to use your modern language and tooling (which is better than the language used for stored procedures which has not changed in 20 years, and is generally a bear to observe, test, develop).

justsomeuseron My Tungsten Cube (2019)

Blocks of magnesium are not fire hazards are they?

Magnesium only ignites easily when in thin strips?

justsomeuseron More and more humans are growing an extra artery, showing we're still evolving

My understanding is that cell based life never stops evolving - it is a constant feedback loop with the environment to build organic tools to extract resources from the environment.

It always makes me laugh when people have the concept that we humans are completely separate things from the species in the animal kingdom.

justsomeuseron Ask HN: Companies of one, what is your tech stack?

Not making a lot of moolah but here is the current iteration:

- HTTP API: Rust, type checks are really useful as web apps are often just messaging. Not being able to cleanly assert JSON structure in dynamic languages started to become an issue.

- DB: SQLite. Not having to manage servers, and just “click to open in GUI” on Mac OS makes development easier.

- Hosting: Google Container OS, Docker, regional disk replication. Every SQLite tx commit is replicated to two zones, the db is incrementally snapshotted hourly.

- UI: TS, React, MobX. Got tired of Reacts state APIs changing every year so just froze on MobX.

- Editor: IntelliJ. I am happy to pay monthly to not deal with plugins. Search is very fast and type aware. Works with all languages with the same shortcuts.

justsomeuseron Ask HN: Companies of one, what is your tech stack?

Opinion: Don’t put your business data in s3 objects!

It can work if all you will ever need is a key value store, but as soon as you need SQL-like queries (joins, filtering, transactions) you will be stuck reimplementing a sql engine in your app code.

I recommend to try SQLite with some kind of replication (either Linode disk snapshots, Litestream etc).

Having your state observable and local to your application instead of a slow http hop away makes development much easier.

justsomeuseron Strict Tables – Column type constraints in SQLite - Draft

It is possible that the db is shared between many processes with potentially different types

justsomeuseron A future for SQL on the web

Would you not have unique code per customer regardless of if the code is SQL queries or C#?

justsomeuseron A future for SQL on the web

Nice. What kind of business logic are you using SQL queries for?

justsomeuseron Are dynamic languages going to replace static languages? (2003)

I think strong types actually make this easier.

I often build systems, then break them up to take the working parts out, then put a subset back together.

The type system is like magnetic Lego that lets you snap pieces together.

With a dynamic system it is really difficult to break things apart and then put them back together (without ever running the code, and with 100% accuracy and immediate feedback).

justsomeuseron It looks like a product but is secretly a subscription

Why BRScript?

justsomeuseron Hosting SQLite Databases on GitHub Pages

It was deprecated because it was difficult to write a standard spec for the existing SQLite code (but a key value system is much easier to specify as there is no SQL language).

justsomeuseron Thinking About Glue Code

I thought that line was a mistake too.

Your software is just a tiny amount of code (relative to the whole system) making up the control plane between all the pieces.

I think the author probably meant that to personally write less code you need to leverage more external code (libraries and network API's).

Write less code -> Leverage other peoples code -> More integration with different systems

justsomeuseron Thinking About Glue Code

Which language did you use to encode these types?

justsomeuseron My mindfulness practice led me to meltdown

I think you are ignoring the fact that people have different brains. Sure, persist through mild discomfort.

But would you advise people who are hallucinating to do the same?

justsomeuseron The database ruins all good ideas

I think the title implicitly meant “good”, as in “you think it’s a good idea until you press it against the grindstone that is reality”.

Also I think these issues arise at the database because that’s were the write concurrency is pushed.