News for hackers. Stuff that matters.

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.
Re:Ask HN: How do you configure Postgres for parallel queries? on Thursday September 15, 2022 @02:40PM (#32856545)
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.
Most clients I work with read HN. It's completely normal in my circles.
Re:Ask HN: What do you do when the Internet goes down? on Friday August 12, 2022 @04:04AM (#32435718)
Play PS4 or some music in Bitwig.
Re:Does anyone use Google Earth Engine? on Friday August 12, 2022 @04:03AM (#32435714)
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?
Re:Ask HN: Why there are so few good company blogs? on Friday July 29, 2022 @12:34PM (#32279046)
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.
Re:Ask HN: Setting up a custom map server do's and don'ts on Thursday July 28, 2022 @07:22AM (#32262883)
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.

Re:Ask HN: Setting up a custom map server do's and don'ts on Thursday July 28, 2022 @06:59AM (#32262764)
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.
Re:Ask HN: What are your favorite subreddits and why? on Wednesday July 27, 2022 @09:21AM (#32250076)
/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.

Re:Remote workers, how do you stop thinking about work? on Wednesday July 27, 2022 @02:00AM (#32247319)
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.
Re:Ask HN: Is Twitter unbearable for anyone now? on Sunday July 24, 2022 @02:49PM (#32216421)
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.
Re:Ask HN: How is time tracking done at your work? on Sunday July 24, 2022 @02:45PM (#32216389)
Given there are 100s of agencies in any major market I'd suggest to find one that values impact over micromanagement.