mjaniczek

Joined 10 years ago

Karma
457
Submissions
165
Member since
Aug 15
https://bsky.app/profile/janiczek.cz https://github.com/janiczek
View on Hacker News

Recent submissions

Comment · 10 days ago
Thanks for the "Ski-bi dibby dib yo da dub dub" earworm
Comment · 1 month ago
I wonder what the modus operandi of preset makers is. Like, the "Boards of Casio" patch data here is amazing, usable, playable. But the official patch banks of many synths, VSTs etc. are quite unusable. Maybe they're aiming to show the breadth of what sounds you can get out of it, rather than provide good defaults?
Comment · 2 months ago
I like the idea of a fast Spotify player, but I can't get over my doubts of LLM code quality when the audio playback stutters even with the 200ms output buffer setting (on macOS).
Comment · 2 months ago
AI blindness is making my reviews of others' PRs harder and harder.
Comment · 2 months ago
Having reusable functions and pipelines compiling to SQL sounds amazing. (EDIT: and sum types!) Will want to try this out on some side project later.

Although for my Elm + backend needs I feel like I still prefer Lamdera: https://dashboard.lamdera.app/ - WebSocket communication and being able to push new data to clients immediately instead of juggling HTTP endpoints and the client having to pull/refresh. `sendToBackend`, `sendToFrontend`, `broadcast` are a great primitive.

Comment · 3 months ago
Congratulations to Hillel for finishing the book!
Comment · 3 months ago
Thank you for another check on my bingo card.
Comment · 6 months ago
Oh cool, I have to try these fonts on my amber CRT getting commands from an Elm webapp ([demo](https://youtu.be/M9Q5tFPtGaA?t=121), [code](https://github.com/Janiczek/crt-esp32-elm/tree/main/vdom/)) - there's not a lot of real estate in a 400x240 NTSC resolution. But the scanlined rendering has so much charm!

EDIT: realized a better demo for this discussion would be the photos I took of all the tiny bitmap fonts I had converted to the C array style at the time. Thread has more but here are my favorites: https://bsky.app/profile/janiczek.cz/post/3mh25atboz224

Comment · 8 months ago
The choice to use Count was made before I joined the company; IIRC they migrated to it from Tableau.

We wanted to migrate (to Streamlit, back then) to have the SQL not live locked in a tool, but inside our git repository; to be able to run tests on the logic etc. But the spaghetti mess was felt too, even if it wasn't the main reason to switch.

(But then, 1) some team changes happened that pushed us towards Metabase, and 2) we found that Streamlit managed by Snowflake is quite costly, compute-time wise. (The compute server that starts when you open a Streamlit report, stays live for tens of minutes, which was unexpected to us.)

----

Export to DBT sounds great. Count has "export to SQL" which walks the graph of the cell dependencies and collects them into a CTE. I can imagine there being a way to export into a ZIP of SQL+YML files, with one SQL file per cell.

Comment · 8 months ago
Look at count.co for a Figma-like approach to databases.

We were using it at work (transitioning to Metabase); it's great for exploring and debugging and prototyping but it ends up too much of a tangled spaghetti mess for anything long-term. Would not recommend for user-/other-company-departments-facing reports or dashboards.

Comment · 8 months ago
I'm optimizing performance of PBT generation and shrinking in [elm-test](https://github.com/elm-explorations/test/compare/master...ja...) - on its own PBT-heavy test suite I got it down from 1336ms to 891ms by using JS TypedArrays.

I'm also experimenting with coverage-guided PBT input generation in the same library, AFL-style -- right now elm-test only has random input generation.

Comment · 9 months ago

Live from the official Hacker News API

A modern reader for Hacker News · SvelteKit + Skeleton