HNHacker News
TopNewBestAskShowJobs

jpcapdevila

84 karma · joined April 27, 2015

Passionate software engineer, I love all things code, specially all the flavors of javascript.

Interested in early stage, fast moving startups.

Born in Mexico City. Currently living in Salt lake city.

submissionscomments
jpcapdevila··on Gemma 2: Improving Open Language Models at a Practical Size [pdf]
Awesome, I love this .cpp trend! Thanks for your work!!
jpcapdevila··on Gemma 2: Improving Open Language Models at a Practical Size [pdf]
Will gemma2 be available through gemma.cpp? https://github.com/google/gemma.cpp
jpcapdevila··on Lago, Open-Source Stripe Alternative, banks $22M in funding
From the readme this may be interesting:

Event-based: if you can track it, you can charge for it;

I see this being useful for usage based pricing.

jpcapdevila··on Every database will become a vector database sooner or later
Here is a SQLite extension that uses Faiss under the hood.

https://github.com/asg017/sqlite-vss

Not associated with the project, just love SQLite and find it very useful.

jpcapdevila··on Ask HN: Who is hiring? (October 2023)
I think it is ok for you to post as long as you are straight forward about the equity only compensation and follow the post format ofc.

Not a moderator, but as a reader I would not mind.

Edit: typo

jpcapdevila··on It's okay to make something nobody wants
I think what you have experienced is very real. Code (and most forms of expression) are a way to externalize your state of mind.

I've seen it with my own emotional states but also with coworkers when they are going trough a rough time.

This is also why it is difficult to understand others ppl code. And it gets easier as you build a relation/get to know them better. The better you know someone, the easier and faster you can understand their code.

I feel like that is why coding standards, code reviews etc make a codebase more maintainable. You strip the code emotions away or at least reset it to a common level across the team.

jpcapdevila··on It's okay to make something nobody wants
This really resonates with me, I like the idea if product as container for emotions.

But I think the author misses one point here:

> I believe the real skill in making products isn’t some “making products” skill, but rather a skill in feeling your own subtle emotions.

I believe there are high emotional, highly empathetic people that can talk to other people, understand their emotions and create something for them.

This for me would be "making products skill". This is how you create products for things that you can't experience yourself directly.

jpcapdevila··on Vector database built for scalable similarity search
That is great! I'll keep an eye.

I've been playing with this extension: https://github.com/asg017/sqlite-vss

jpcapdevila··on Cloudflare D1 open alpha release
Here's a bet, in 5 years every major cloud provider will offer SQLite.

Specially the edge providers (official SQLite for wasm in the works.

Because the operational simplicity most developers will choose it for new apps.

jpcapdevila··on Spf13 is leaving Google
Wow, thanks for all those great contributions.

Looks like you have a good eye for picking good tech & teams to join and work with.

Any insights or things you saw in common?

jpcapdevila··on Ask HN: Should I learn Rust or Go?
I write JS 99.9% of the time.

I would definitely pick Rust as it is more different than JS.

Yes, there is a higher learning curve. But it will broaden your perception on programming languages.

As an added bonus, rust is very popular to create WASM stuff. So you can apply it to the JS world.

Happy 4th

jpcapdevila··on Ask HN: Cheapest and simplest solution for a daily email alert to myself?
There are cloud providers, I have personal experience using sendgrid.

For small scale / personal stuff you can use gmail's SMTP.

https://support.google.com/a/answer/176600?product_name=UnuF...

jpcapdevila··on Ask HN: Cheapest and simplest solution for a daily email alert to myself?
Firebase free tier, you can create an scheduled function that runs your python code and sends the email.

Super easy to deploy and it is set and forget.

I'm sure you can fit your use cade in the free tier.

jpcapdevila··on Ask HN: What's “The Edge”?
It means having serving your users from the edge of the network, close to them.

Not necessarily tied to v8 isolates, for example fly.io and others let's you run any container on "The Edge".

I think CDNs were the original concept but the name evolved away from "content" to indicate that you can run your business logic too

jpcapdevila··on Cycling: Why Tunnels are Better than Bridges (2014)
> "Tunnels offer protection from wind and rain."

Not sure about this one. Back home in Guadalajara Mexico a lot of tunnels get flooded during rain season. I'm talking about 6ft of water.

To be fair, even streets turn into rivers / pools.

jpcapdevila··on Show HN: Open-source Firebase Alternative? It's here
I'm developing an alternative using SQLite, focused on JavaScript developers productivity.

https://javascriptdb.com

jpcapdevila··on JSON and Virtual Columns in SQLite
You can rename it now, unless I'm missing something

https://www.sqlite.org/lang_altertable.html

jpcapdevila··on JSON and Virtual Columns in SQLite
Fair, but for objects like in the OP sample? Is there any advantage that justifies the extra steps?
jpcapdevila··on JSON and Virtual Columns in SQLite
What's the difference/advantage between defining the virtual column or creating the index directly like this:

CREATE INDEX test_idx ON events(JSON_EXTRACT(data, '$.someKey'));

jpcapdevila··on D1: Our SQL database
Any feedback on what do you find interesting would be awesome :) thanks!!
jpcapdevila··on D1: Our SQL database
If SQLite gets you excited, I'm building a firebase alternative based on sqlite. I'm betting hard on sqlite so this get's me super excited!!

https://javascriptdb.com

CF people around, I would love to chat, if anyone is interested please reach out at: jp@javascriptdb.com

I'll be applying to this beta for sure!

jpcapdevila··on D1: Our SQL database
Hey Josh,

I'm building a serverless firebase alternative that uses SQLite. If CF gives me access I will totally support D1 & workers.

Check it out: javascriptdb.com

jpcapdevila··on D1: Our SQL database
I'm building an open source firebase alternative using sqlite. I'll be reaching out, I was thinking to build the distribution & durability part myself, but I would rather use D1!

I guess it would count as a client focused ORM :)

I'll be reaching out from jp@javascriptdb.com

Great addition, congrats!

jpcapdevila··on D1: Our SQL database
I think the most successful attempt would be Realm.

https://realm.io/

jpcapdevila··on D1: Our SQL database
Are you guys using litestream or a similar approach? E.g storing WAL frames in a durable object.
jpcapdevila··on I'm all-in on server-side SQLite
Could you elaborate on the features that would make MySQL a safer choice?
jpcapdevila··on I'm all-in on server-side SQLite
It only PUTs if there's writes.
jpcapdevila··on I'm all-in on server-side SQLite
I love Datagrip by jetbrains.
jpcapdevila··on Ask HN: Beyond AWS/Azure/GCP, what cloud providers should I know more about?
https://fly.io It let's you run containers on the edge (close to your users)
jpcapdevila··on Ask HN: Fastest Crawl of HN Articles
The best way to do it is from Google BigQuery.

There's a dataset containing everything: bigquery-public-data.hacker_news.full

You can write SQL and is super fast. Sample:

SELECT * FROM bigquery-public-data.hacker_news.full LIMIT 1

Page 1 of 2Next →