HNHacker News
TopNewBestAskShowJobs

markandrewj

240 karma · joined July 12, 2018

submissionscomments
markandrewj··on Use one big server
Just FYI, you can have one big database, without running it on one big server. As an example, databases like Cassandra are designed to be scaled horizontally (i.e. scale out, instead of scale up).

https://cassandra.apache.org/_/cassandra-basics.html

markandrewj··on Deno raises $21M
It's all JavaScript, so language is probably not the right word to use. Runtime is correct, but both technically sit on top of V8. Although Node leverages C++ on the backend, and Deno leverages Rust.
markandrewj··on Deno raises $21M
I imagine you are already aware, but the creator of Node, Ryan Dahl, is also the creator for Deno. He is trying to create a new language which integrates what he learned from building Node.
markandrewj··on How we upgraded our 4TB Postgres database
Scaling databases vertically, like Oracle DB, in the past was the norm. It is possible to serve a large number of users, and data, from a single instance. There are some things worth considering though. First of all, no matter how reliable your database is, you will have to take it down eventually to do things like upgrades.

The other consideration that isn't initially obvious, is how you may hit an upper bound for resources in most modern environments. If your database is sitting on top of a virtual or containerized environment, your single instance database will be limited in resources (CPU/memory/network) to a single node of the cluster. You could also eventually hit the same problem on bare metal.

That said there are some very high density systems available. You may also not need the ability to scale as large as I am talking, or choose to shard and scale your database horizontally at later time.

If your project gets big enough you might also start wanting to replicate your data to localize it closer to the user. Another strategy might be to cache the data locally to the user.

There are positive and negatives with a single node or cluster. If retools database was clustered they would have been able to do a rolling upgrade though.

markandrewj··on You don't ever own an electric vehicle
*electric
markandrewj··on You don't ever own an electric vehicle
It is possible for a lot of vehicles, but at the same time there are companies have been trying to make self maintenance and repair difficult.

I am particularly thinking about John Deere. Although not specific to Electric vehicles.

https://youtu.be/EPYy_g8NzmI

markandrewj··on Zen and the Art of Talking to Conspiracy Theorists
I think it is worth mentioning this article isn't labeling everyone as a conspiracy theorist.

"When we talk about grand conspiracy theories, we mean the claim that there exists a secret plot between a large number of powerful people or organizations, usually an entire industry or many large governments, to consistently deceive us in order to reach an often evil goal."

In specific the article references QAnon and the ideas disiminated by the group.

markandrewj··on Zen and the Art of Talking to Conspiracy Theorists
They didn't deny it. Alex Jones was banned from these platforms for spreading conspiracy rhetoric.

https://www.reuters.com/article/us-apple-infowars-idUSKCN1LO...

https://www.vox.com/2018/8/6/17655658/alex-jones-facebook-yo...

markandrewj··on Zen and the Art of Talking to Conspiracy Theorists
I should have said 'trivial for most people'. I am not referring to people who can't wear masks in public spaces for legitimate reasons.
markandrewj··on Zen and the Art of Talking to Conspiracy Theorists
Part of me has difficulties understanding why wearing a mask has had so much backlash. It is a trivial thing to do, and something people in many countries were already doing pre pandemic.

My experience has been that many people who are not in favour of masks think that they are being enforced for reasons other than public safety.

markandrewj··on Show HN: Long Range E-Bike
For anyone interested in e-bikes, that has a do it yourself attitude, I recommend looking at Grin Technologies in Vancouver. I met someone who built their own e-bike this summer while out riding, and he suggested them to me. The founder has a bunch of videos online about e-bike technology that I learned quite a bit from.

https://www.youtube.com/watch?v=xnhuoUrwhIw

markandrewj··on Tools to Explore BGP
I notice most people don't seem know that there is both EBGP and IBGP. It's common to use BGP for internal as well as external networking now days.

https://www.ipspace.net/Data_Center_BGP/

markandrewj··on Mozilla HTTP Observatory
Expecting the user to have a browser that supports a recent version of TLS is not unreasonable. My point was that even browsers older then most people imagine support HTTPS, but like you said something newer then Netscape would be required. If the argument being made though is we shouldn't require HTTPS to support users that use clients which don't support HTTPS, my question is still the same, what users and what clients?
markandrewj··on Mozilla HTTP Observatory
What old clients exactly? HTTPS is a long supported standard. HTTPS was introduced by Netscape in 1994.
markandrewj··on My £4 a month server can handle 4.2M requests a day
Normally benchmarks for things like this are measured in how many concurrent requests can be handled, i.e the C10K problem, not by how many requests you are able to serve in a day. It's also well known that you can serve a large amount of requests on limited hardware.

https://en.wikipedia.org/wiki/C10k_problem

"By the early 2010s millions of connections on a single commodity 1U rackmount server became possible: over 2 million connections (WhatsApp, 24 cores, using Erlang on FreeBSD),[6][7] 10–12 million connections (MigratoryData, 12 cores, using Java on Linux).[5][8]"

Although I do understand the boxes listed above have more resources then the VPS you are using. I am also not criticizing your write up, or results, bench-marking is in general interesting to do. I just wanted to provide some additional information.

markandrewj··on Facebook Is the AOL of 2021
I find many of the articles on ZDNet, and CNET, are either inaccurate, fluff, or clickbait.
markandrewj··on Starlink review, four months in
I am not sure if this is a helpful comment, or possible, you might want to try attaching the dish to the top of tallest tree if you can though. I have had to do this with satellite dishes in the past while working in remote locations. When I say remote, I am talking surrounded by mountains, deep inside the boreal forests of British Columbia.
markandrewj··on Neovim 0.5 is overpowering
Watching ThePrimeagen and tjdevries has also given me some good insights into neovim. Tjdevries has put a lot of work nvim-treesiter, and it shows. I have stuck with regular vim for a while because I have everything configured the way I want, but I am setting up a new build now, and I will probably move to neovim.
markandrewj··on How M1 Macs feel faster than Intel models: it’s about QoS
Except that Apple considers these devices ’vintage' and will not provide OS updates or repairs.

https://support.apple.com/en-ca/HT201624

markandrewj··on How M1 Macs feel faster than Intel models: it’s about QoS
PCIe 4.0 is the current standard.
markandrewj··on The internet didn’t kill counterculture – you just won’t find it on Instagram
It's sort of ironic that the photographer for this article is on instagram.
markandrewj··on Bring Your Own Client
This isn't to detract from what the author has said, but Google Docs does have a public API now. I wanted to mention this because the public API is fairly new, and people may not know about it. I am not sure if the API is rich enough to achieve what the author is describing though. It's also not built on any kind of standard, like email, or other examples that are described.
markandrewj··on IKEA to discontinue its annual catalog, ending a 70-year run
Pulp production.
markandrewj··on An Atonement of Nano
I have used both Pico and Nano. The selling point of Nano to me is it being small and available. I don't do my day to day work in nano, but even in the most minimal system it is normally there, which makes it useful for configuration changes in a pinch.

Another editor that works similarly to Nano, that most people don't seem to know about, is Micro (GNU) Emacs. Although it's not as small or common.

https://github.com/troglobit/mg

markandrewj··on Retiring Tucows Downloads
This brings up memories for me also. I was under the impression that Tucows was founded in Canada though, because their headquarters is in Toronto. Although most people know them for their download site, they have also always been a pretty big domain registrar. According to wikipedia, they are the second biggest at the moment.
markandrewj··on Sick of spending time on Auth, we built an open source 'Stripe for Auth'
Could you provide some details on where you are storing the tokens on the client side to persist the session? The best practice currently seems to be storing the tokens in http only cookies.

I built something not long ago like this for myself. I haven't made it publicly available though.

markandrewj··on Preview in macOS Big Sur is destroying PDFs
Generally the PDF copy of a book is designed to fit the format of the final printed book. The PDF is even often the deliverable sent to press.

If you are using something like an e-reader, or a smartphone, the PDF layout often doesn't translate well. Typesetting is also normally also done for ePub/Mobi, but the layout is tailored to the format of the device that the document will be read on. Although there are times when publishers just take the PDF and click 'convert to ePub', which isn't ideal.

There are also other advantages to different formats, when talking about things like programming books. As an example, working code snippets for web formats. I am thinking of things like Jupyter notebook when I say this.

As others have mentioned there are also a number of security risks associated with PDF.

I can't deny there are several books I have read in PDF format however.

markandrewj··on Pg-shortkey: YouTube-Like Short IDs as Postgres Primary Keys
A pattern you see often is people combining a human readable slug with an ID tacked on. This gives you a more readable slug and an easy way to reference the entry.

https://wellfire.co/learn/fast-and-beautiful-urls-with-djang...

markandrewj··on Jira on premises end of life starts feb 2021
Some key differences include clustering for higher availability, rolling updates, and Crowd for authentication integration.
markandrewj··on Ask HN: What can replace my iPod for podcast listening?
I found the Nano's size convenient for this reason also. However, I find wireless earbuds,and wireless syncing, to be something I like even more.
← PreviousPage 3 of 7Next →