Hacker Newsnew | past | comments | ask | show | jobs | submit | more labarilem's commentslogin

How would you call your role?


I'd say I'm a Postgres Journeyman.

I'm a software engineer primarily. Postgres is another tool I like to use to solve data problems. I've used it as the backbone of applications in production at terabyte scale. I've architected and been responsible for the deployment of it, both on-prem and in "the cloud" (including the operations of PITR and replicated failover). I've written extensions for it, and hacked on the codebase for internal use.


Any resources (books etc) or practices you recommend for learning Postgres’ internals?


I've read a bunch of the official documentation, and then read a lot of the source code to Postgres itself. I'd say source is the #1 place I go if I have questions that are specific, and then if I want philosophy I look for previous presentations by the Postgres team, or from the hackers mailing list.


Cool! Was Postgres a crucial requirement of your job?


Yah, I have had many projects where I could have used something else, but Postgres ended up being the perfect bag of tools to do what I needed. I've been very happy with it.


I can understand. I started to grasp the full potential of Postgres (but probably I'm still missing a lot) when I decided to use it for time series with the Timescale extension.


I agree T-shaped professionals can have more impact than deeply specialized ones in certain contexts.


Did you switch to a different career?


I technically am still a consultant, but I largely shifted to working on my own products (including Cydia, for which I am mostly known).


So would you say there's still enough market for it?


Yeah I guess these days it's easier to setup a DB if you have a cloud env. Also most companies don't need (or want) their DB optimized by an expert. Why did you move to cloud architecture?


> Also most companies don't need (or want) their DB optimized by an expert.

Maybe most. But as someone supporting a company that has few TBs of data for SQL Server database to run Dynamics AX - they really appreciate when DBA makes their business run smoothly and get reports or calculate orders on time.

And I encounter multiple companies where they should need a touch of a DBA - weird database design that bites the business side of things.


> And I encounter multiple companies where they should need a touch of a DBA

Agreed, I've seen several examples of this.


Cool although I'm trying to avoid self hosting for this task.


I get that, however consider to put one of those tiny trackers on a $5 VPS. And have a once and for all solution for all your projects.

Shynet really is super lightweight.


Thanks, missed the thread!


Love the simple design. Is there a way to have private data though?


The data is only viewable by you. As for hiding the counter, there's an option to set the image to display: none. Then just grab the ID of the counter and navigate to the bottom of the page, where you can click on "count" and get your tracking data right there if the counter isn't visible on your website.



SEEKING WORK | Europe | Remote

Location: Italy, EU Remote: Yes Willing to relocate: No

Technologies: TypeScript | Node.js | Express | SQL | Postgres | PostGIS | TimescaleDB | MongoDB | RabbitMQ | S3 | Kinesis | SQS | SES | EC2 | Lambda | RDS | DMS | ELK stack | Grafana | AWS | Cloudformation | Azure | Docker | Git | Linux | Cloud | Self-hosted | Serverless | Monitoring | Monolithic | Microservices

Résumé/CV: https://marcolabarile.me/assets/cv.pdf

Email: username on HN at gmail.com

About me:

Passionate and pragmatic Software Engineer with 6-years experience in the industry. Worked in different roles: Startup Founder, Architecture, R&D, Project Management, Product Management, Teaching. I can quickly learn and pick up new techs and have also worked with different stacks than the one listed here.


Location: Italy, EU Remote: Yes

Willing to relocate: No

Technologies: TypeScript | Node.js | Express | SQL | Postgres | PostGIS | TimescaleDB | MongoDB | RabbitMQ | S3 | Kinesis | SQS | SES | EC2 | Lambda | RDS | DMS | ELK stack | Grafana | AWS | Cloudformation | Azure | Docker | Git | Linux | Cloud | Self-hosted | Serverless | Monitoring | Monolithic | Microservices

Résumé/CV: https://marcolabarile.me/assets/cv.pdf

Email: username on HN at gmail.com

About me:

Passionate and pragmatic Software Engineer with 6-years experience in the industry. Worked in different roles: Startup Founder, Architecture, R&D, Project Management, Product Management, Teaching. I can quickly learn and pick up new techs and have also worked with different stacks than the one listed here.


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: