HNHacker News
TopNewBestAskShowJobs

gerardnico

84 karma · joined October 15, 2021

Builder, lover of party, father of 2, lover of 1, lost in translation in the Netherlands.

https://datacadamia.com

submissionscomments
gerardnico··on Ask HN: How did you get people to visit your personal blog?
For me, it has started during the crisis of 2008. Because I had time on my hand, I would go on the oracle forums trying to learn and to answer questions at the same time.

Because I was tired to answer always the same questions by copy and paste, I started to post them online.

As of today, the blog has more than 10000 articles and has between 50k and 10k users a week depending on Google algo.

https://datacadamia.com

Found the audience that you want to be part of be useful, add post where they are.

gerardnico··on Oh-Auth – Abusing OAuth to take over millions of accounts
It should not happen if you have a proper state that is local, unknown from the attacker and temporarily valid.

https://datacadamia.com/iam/oauth/state

gerardnico··on Autocomplete – A JavaScript library for building autocomplete experiences
Nice library.

I also like very much to use the floating ui headless component

Example for an autocomplete/combo box https://codesandbox.io/s/fragrant-water-bsuirj?file=/src/App...

gerardnico··on JSX Mail: Ending All Your Problems When Creating Email Templates
I’m using pure html with the css of bootstrap email and I in-line it.

The problem with library is that they don’t go well across language, you need to call an api. (I use Java)

As of today, most email client understand the basic css.

gerardnico··on Ask HN: How to master verbal communication?
As a lost in translation person myself, I would say that you are just fucked.

The automatism of your natural language are always going to kick-in.

The best way is to speak slowly and to plan each word that you are going to say. For every speech, I give, I wrote it and works every word before hand.

Success

gerardnico··on Advice needed for backing up and hosting large amount of files
If you want to store a lot of data, the solution is known as an object storage file system.

Check this list: https://datacadamia.com/file/edge_storage

There is a lot of other pricing implied if you want or not retrieve your data but this is mostly one write, several read solution.

gerardnico··on Prediction market: We're unhappy with Firestore. What will we switch to?
https://fly.io/docs/reference/postgres/
gerardnico··on What is developer productivity and how to measure it?
For every productivity metrics don't forget to balance it with a quality one.

The reality is always in the middle.

Example: If you solve a problem quickly that leads to support ticket being open that's not good.

gerardnico··on Ask HN: Data Vault Modeling?
Wait for dv 3.0 ;)

This is just a framework around ETL processing that highlight the usage of table via name in the data warehouse layer.

When you implement it the big problem is that everybody may have a different definition of what the names mean (Ask WhatsApp a satellite is to 10 people and you will get 10 different answer).

Also as it adds a layer of abstraction, you will spend a lot of time searching where the data comes from.

Technically, you should be able to delete all the data as it's processed but practically you always ends up with a persistent layer.

I will never understand why they don't just replicate the source model.

https://datacadamia.com/data/warehouse/data_vault/data_vault

gerardnico··on Ask HN: What's the best way to split SaaS code between commercial and free?
If private package present, run otherwise do nothing.
gerardnico··on Ask HN: How common is a 4-day work week in our industry?
in the Netherlands, the 4 day work week is the standard when you begin to get kids. The day is continue and you work 9h. It makes a 36h week.
gerardnico··on Ask HN: Why does Nextjs offer an API folder when APIs can live on the back end?
Nextjs is a backend application and runs its own http server.

You can connect to any database via a tunnel (cloudflare, ...) Or directly with certificate/credentials ( your DB server should allow only connection from the network where you host nextjs)

gerardnico··on Ask HN: Can someone suggest a REST API widget?
If you have it in openapi format, just use the generator of your tool.

https://datacadamia.com/web/service/openapi

gerardnico··on Ask HN: Ethical ads providers to monetize personal blog
Seeing the content on your website, don't bother nobody will care about your website if you don't have at minimum 1M page view.
gerardnico··on Ask HN: How long did it take to learn your first programming language?
There is a rule for that

https://en.m.wikipedia.org/wiki/Ten_Year_Rule

gerardnico··on Ask HN: I'm a builder. How do I learn to sell?
If your software is a real tool that can help people, Marketing is just an application of influencial psychology that aims to sell.

Know your basic: https://youtu.be/uKbcmlKb81c

Copywriting just uses this principles.

gerardnico··on Ask HN: How do you manage direct updates to databases in a production system
Database migration is just code. You create your own database migration tool with a incremental version number and you apply it during deployment.

You can also use a specialized tool. https://datacadamia.com/data/database/migration#tool

Make a branch, test your code and deploy it.

gerardnico··on Ask HN: What are your favourite/essential privacy tools for the browser?
Tor
gerardnico··on Ask HN: What is a good open-source marketing automation tool
Not really open source but a small one time fee. https://sendy.co/
gerardnico··on Ask HN: Learning how to convert Markdown to HTML
markdown is not a language that can be expressed with a grammar file. I would take a look at the specification, they have created an implementation and explained it in details. https://spec.commonmark.org/0.30/#appendix-a-parsing-strateg...
gerardnico··on Ask HN: Integrate Software Solution with Competitor's?
Thanks for the tip. I read now the basis. ie human psychology :)
gerardnico··on Ask HN: What is the best way to implement a WYSIWYG editor?
I wrote an article on this topic. https://datacadamia.com/web/html/editor

Basically, you work on a textarea, you work against a dom (html Dom directly or a virtual Dom) that acts as the AST.

Google docs is hard because it adds pagination which means you need to calculate all positions and dimension.

For basic text editing, this is not hard but if you want to add structural component, you have much more work.

React has already a text editing framework. Take a look.

gerardnico··on Ask HN: Integrate Software Solution with Competitor's?
Check change management. This is a complete field that goes way over just software integration.

The principal is that every human being is active and has a voice in the future architecture (based on spec).

Architecture is easy. Getting everyone on board is not. Luckily, it seems that human being are smarter together.

If you miss that, intern conflicts, architecture rejections will bring you integration project to a big failure.

Team / product competition is way easier to manage and is may be also the way to keep a bigger market share.

gerardnico··on Ask HN: Practices for protecting business login credentials
For the house that burns or if you are in incapacity. I have a cloud shared keepass and I have printed a emergency sheet.

https://keepass.info/help/kb/faq.html

For your death, you need to have your legal papers in order.

gerardnico··on Ask HN: What database do you use for personal web projects?
sqlite (one file for a lot of a read, a few write) and another for the write only (log, ...)
gerardnico··on Ask HN: Can I use ML to extract individual images from a webpage screenshot?
Yes. It's called edge detection in computer vision.
gerardnico··on Ask HN: What important truth do few people agree with you on?
People often put to much emphasis on goals while they are just the natural result of a trajectory.

Taking pleasure in learning is 10 times much more important than grades.

And the funny part is that if you succeed, you will get good grades.

gerardnico··on Ask HN: No Code GUI Tools?
A rest API has by definition no data structure. You can't query data without structure.
gerardnico··on Ask HN: No Code GUI Tools?
Not at all. Just forgot it out of my mind.
gerardnico··on Ask HN: Getting started with my technical blog. What to write? How to start?
I get no notification / email from hn. Sorry for the delay.

https://datacadamia.com

← PreviousPage 2 of 4Next →