marek_leisk2

https://news.ycombinator.com/newcomments shows 5 comments in the last 60 seconds.

Trino can do this.

Micro-consulting sounds like hell. Sales are a huge drag on any expert trying to capitalise. By the very nature of their business they need fewer but larger deals.

Since the data won't change frequently it might be worth trying to load it into ClickHouse. I've had needle-in-haystack searches on multi-million row tables speed up by 2 orders of magnitude over PG.

If one of the ten bosses fires you, no big deal. This is the essence of self employment, not having a single source of failure in your income stream.

https://typer.tiangolo.com/

Most clients I work with read HN. It's completely normal in my circles.

Play PS4 or some music in Bitwig.

There is a 300+ example repo for using GEE with QGIS. It's a trasure trove of inspiration.

https://github.com/giswqs/qgis-earthengine-examples

Video and music production, game development, stock trading, book writing. You've got every prerequisit by the time you hit 30, you can do anything at a global level.

Filezilla is the worst for this.

Google are meant to be working in the interests of shareholders. If you bought their stock today, would you be happy if it never went up in value?

Exactly, a blog should read as though it comes from one voice. People can subconciously tell if more than one author is involved in a piece of written work.

Ah okay, makes sense. I'm looking forward to seeing what suggestions land here.

Also, Paul Ramsey's pg_tileserv isn't on your radar, is it?

Also, LeafletJS supports GeoJSON overlays.

Have you looked at QGIS? You can drag OSM files onto it and add layers from loads of different data sources. It's a GUI app that runs on Windows, MacOS and Linux.

/r/gis is full of friendly professionals. I've had replies there that must have taken an afternoon to write up.

Around 2001 I thought C++ was the only real programming language and that LAMP was just going to be a hobby. Also, learning to cold call local businesses doesn't require a high school diploma, sooner you can get into it, the better.

As a small biz you often hire contractors and its important that they focus on delivering value, not adhere to pre-established tool mandates.

As for perm staff, computers are cheap since they can last for years. Windows, and Macs aren't that expensive in the grand scheme of things.

I do have a handful of Raapberry Pis in a food wearhouse but I'm not doing to demand any analyst to stop using Tableau on their mac when they digging through my order book looking for oppurtunities.

At some point you need to realise you only need to go to work to make money and further your career. Then, self employment becomes a natural path to turn to. When you eventually find clients, at some point you'll realise selling tech, rather than coding it, is much more important. It's at that point that the day-to-day of your current client's businesses isn't important and finding more clients is all that matters.

Scaler will go a long way to teaching music theory. The VST has an optional six hour video course which is easy to follow along with.

If Aruria's V Collection ever goes on sale it's a killer combo with Bitwig. Easily one of the most straight forward ways to write music with 1000s of presets. Plus Bitwig has a discounted 8-track version so this doesn't need to be a huge investment.

Sell yourself as a consultant via your LinkedIn profile. Ask for a retainer that'll be used over x months. Say, 160 hours over the next 4 months.

Terminal + Sublime.

Use Tweetdeck. That way you will have at least one lane that is your feed in cronological format.

Putting together a short-form blog post. Also, turning it into a presentation helps solidify any learnings.

Given there are 100s of agencies in any major market I'd suggest to find one that values impact over micromanagement.