HNHacker News
TopNewBestAskShowJobs

nicoritschel

137 karma · joined November 26, 2012

https://nicoritschel.com
submissionscomments
nicoritschel··on Why was Apache Kafka created?
I would take a hard look at Kinesis/Pubsub for these data volumes; should cost in the tens of dollars monthly.
nicoritschel··on Linear sent me down a local-first rabbit hole
I've been down this rabbit hole as well. Many of the sync projects seem great at first glance (and are very impressive technically) but perhaps a bit idealistic. Reactive queries are fantastic from a dx perspective, but any of the "real" databases running in the browser like sqlite or pglite store database pages in IndexedDB as there are some data longevity issues with OPFS (IIRC Safari aggressively purges this with a week of inactivity). Maybe the solution is just storing caches in the users' home directory with the filesystem api, like a native application.

Long story short, if requirements aren't strictly real time collaborative and online-enabled, I've found rolling something yourself more in the vein of a "fat client" works pretty well too for a nice performance boost. I generally prefer using IndexedDB directly— well via Dexie, which has reactive query support.

nicoritschel··on If you're remote, ramble
You should do this in normal channels relevant to the discussion topic to facilitate discussion, not a separate channel per person. What.
nicoritschel··on Uber to introduce fixed-route shuttles in major US cities
San Clemente (south of LA) replaced local bus service with subsidized ($2)lyft rides for a select list of pickup/dropoff spots a few years ago. I receive vouchers every month just for having used Lyft in the town.

Similar; surely more expensive big picture, but far more convenient.

nicoritschel··on Why on Earth is OpenAI buying Windsurf?
The redesign was ~5 months ago. If you switched in October, you 100% have not used the current Cursor experience.
nicoritschel··on SQL pipe syntax available in public preview in BigQuery
Also is in DuckDB https://github.com/ywelsch/duckdb-psql
nicoritschel··on Databases in 2024: A Year in Review
Adtech/ML
nicoritschel··on Databases in 2024: A Year in Review
I am grateful for Redis and I agree you pioneered a lot of data access patterns in production for a lot of people, myself included. I've used Redis for 10 years, at times for use cases as you mention, for real time feature engineering for ML as well.

The API is just different compared to SQL, which is a downside for many. There's modern advancements in the space with IVM and more databases are supporting probabilistic data structures.

nicoritschel··on Databases in 2024: A Year in Review
With all due respect, the linked video was pretty fair. It didn't imply not to use Redis, just not as a primary datastore.

I don't think folks work with Redis out of fondness for the model, but because it's the least worst datastore for caching, lightweight message broker, and simple realtime things like counters.

nicoritschel··on GitRelate(d): Find related Git repositories
My coworker made this, so thought I would share!

Just replace github.com in any repo’s URL with gitrelate.com or gitrelated.com, and you can see other repositories that people who starred the original repo also liked. Works best with obscure niches with ~100 stargazers.

https://gitrelated.com/duckdb/duckdb

nicoritschel··on Metrics in SQL: querying a semantic layer via DuckDB over the pg protocol
If you're into data in any capacity, you've probably heard about DBT the past few years. SQLMesh is an alternative that with many enhancements like column level lineage.

You may or may not be familiar with the DBT semantic layer. It's out of reach due to cost for many folks— requires expensive monthly fees.

SQLMesh includes a query rewriter if you have defined any metrics, so I simply added it to the existing buenavista query rewriter and added a sample SQLMesh project. Cheers.

nicoritschel··on Piped SQL via DuckDB
Instead of waiting for the output of the admittedly interesting research from Google, start using piped SQL today anywhere you can use DuckDB.

Sidenote: GoogleSQL with pipe syntax is available in alpha already if you use BigQuery (https://cloud.google.com/bigquery/docs/pipe-syntax).

nicoritschel··on Show HN: Sidequery - A SQL editor and exploratory BI tool in your browser
See a demo of how to use it here: https://x.com/nicoritschel/status/1832111432605089792

Protips:

- Connect a folder of .csv or .parquet files and they'll all be registered as tables

- There is very little chart configuration required and it's easy for both SQL enjoyers and non alike to explore data

- Coordinated timeseries hover makes it simple to compare metrics at the same time period

- Any DuckDB aggregation function is supported as a custom expression when adding a metric

nicoritschel··on Preview of Explore Logs, a new way to browse your logs without writing LogQL
While this is a step in the right direction, just let me write something closer to SQL. Influx did this correctly.
nicoritschel··on Show HN: SQL workbench in the browser
Hi Tobi; Hi Archie, we all know each other from Twitter.

Check out what Postico does; it just highlights the current statement under the cursor by default and that's what gets run by default. Can't resist imposing this subtle SQL UX on everyone because it's my favorite (for like 10 years now).

nicoritschel··on SQL: One of the most valuable skills
And more recently, we see SQL abstractions overlaid on top of things like Kafka streams with messages encoded in Avro thanks to technologies like Spark structured streaming.

SQL is not only relevant to traditional databases. I never got into C#, but LINQ looks really interesting.

nicoritschel··on Show HN: Spongedown
Probably a great candidate for some FAAS (AWS Lamda, Google Cloud Functions)
nicoritschel··on Ask HN: Dual monitors, or single 4k?
I prefer a single monitor. Maybe that's a result of my mild ADD
nicoritschel··on Ask HN: Dual monitors, or single 4k?
I have a question for those that require multiple monitors.

Is your workflow severely impaired when on a laptop alone? I.e. in a coffee shop?

nicoritschel··on Ask HN: Dual monitors, or single 4k?
Agreed 100%. Just got a new Mac setup (MBP w/ Touchbar and 27" LG Ultrafine 5k). Single cable that carries video, power, data is epic.

You can scale the UI, but the monitor just so pleasant at 1/4 effective res. Embrace cmd + tab. And tmux.

nicoritschel··on Google HTML/CSS Style Guide – Omit Optional Tags
My best guess would be that any work done by a Googler will be served up from a domain included in the HSTS Preload List (forces SSL in most browsers)
nicoritschel··on Show HN: MackerNews – Beautiful Readable HN Articles
Ooh that's nice
nicoritschel··on Twitter Is Tracking Users’ Installed Apps for Ad Targeting
Facebook has been doing this for ages...
nicoritschel··on Beyond Flat
Am I the only one who has used front and backward swipe in iOS7 to navigate between screens?
nicoritschel··on US intelligence mining data from 9 US Internet companies in broad secret program
https://github.com/owncloud/core
nicoritschel··on I’m Sick of Tiny, Tiny Type
I thought it was just me that likes my font to look like Safari's reader at all times. Good thing I know I'm not alone. I designed my blog the same way.
nicoritschel··on Show HN: Cover letter for applying to SendGrid
That's super creative! I like :) Good luck
nicoritschel··on Stripe Checkout
Checkout simply creates a token, that you can use to set up a one-time payment, recurring payment, or even to just create a new customer object in Stripe.
nicoritschel··on Stripe Checkout
Collecting addresses is as simple as adding a parameter: https://stripe.com/docs/checkout
nicoritschel··on Mosh: the mobile shell
http://www.zinger-soft.com/iSSH_features.html

iSSH includes the mosh protocol as a 99c in-app purchase. Use mosh on your mobile device, just where it should be!

← PreviousPage 2 of 2