HNHacker News
TopNewBestAskShowJobs

marek_leisk2

16 karma · joined July 24, 2022

submissionscomments
marek_leisk2··on Ask HN: How many posts/replies are being posted to HN every minute?
https://news.ycombinator.com/newcomments shows 5 comments in the last 60 seconds.
marek_leisk2··on Run SQL on CSV, Parquet, JSON, Arrow, Unix Pipes and Google Sheet
Trino can do this.
marek_leisk2··on Ask HN: Is there a Stack Overflow clone that pays money for answers?
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.
marek_leisk2··on Ask HN: How do you configure Postgres for parallel queries?
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.
marek_leisk2··on Ask HN: Is academia the opposite of self-employment since you have many bosses?
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.
marek_leisk2··on Ask HN: What do you use to make CLIs?
https://typer.tiangolo.com/
marek_leisk2··on Ask HN: How would you react if someone in real life asked if you've heard of HN?
Most clients I work with read HN. It's completely normal in my circles.
marek_leisk2··on Ask HN: What do you do when the Internet goes down?
Play PS4 or some music in Bitwig.
marek_leisk2··on Does anyone use Google Earth Engine?
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

marek_leisk2··on Ask HN: Hobbies/Skills which can be picked in 30s and compete at world level?
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.
marek_leisk2··on Every single time I open your software, I'm asked to download an update
Filezilla is the worst for this.
marek_leisk2··on Google CEO tells employees productivity and focus must improve
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?
marek_leisk2··on Ask HN: Why there are so few good company blogs?
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.
marek_leisk2··on Ask HN: Setting up a custom map server do's and don'ts
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.

marek_leisk2··on Ask HN: Setting up a custom map server do's and don'ts
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.
marek_leisk2··on Ask HN: What are your favorite subreddits and why?
/r/gis is full of friendly professionals. I've had replies there that must have taken an afternoon to write up.
marek_leisk2··on Ask HN: What do you wish you did as a juvenile to generate more success today?
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.
marek_leisk2··on Ask HN: What blocks you from switching your small-to-medium business to Linux?
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.

marek_leisk2··on Remote workers, how do you stop thinking about work?
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.
marek_leisk2··on Ask HN: Linux based music creation workflow for 10 year old
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.
marek_leisk2··on Ask HN: Linux based music creation workflow for 10 year old
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.
marek_leisk2··on Ask HN: Where can I find small companies to work for part-time?
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.
marek_leisk2··on Ask HN: Indie devs, what is your development process?
Terminal + Sublime.
marek_leisk2··on Ask HN: Is Twitter unbearable for anyone now?
Use Tweetdeck. That way you will have at least one lane that is your feed in cronological format.
marek_leisk2··on Ask HN: What is a sustainable methodology for taking notes of your learning?
Putting together a short-form blog post. Also, turning it into a presentation helps solidify any learnings.
marek_leisk2··on Ask HN: How is time tracking done at your work?
Given there are 100s of agencies in any major market I'd suggest to find one that values impact over micromanagement.