Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Self-contained highly-portable Python distributions

gregoryszorc.com

Post reply on HN
Print view View original

41–45 of 45 posts

Re: Self-contained highly-portable Python distributions

#41

Post by Imustaskforhelp »

zie wrote: post #20
Imustaskforhelp wrote: post #17

Earlier quoted context omitted.

I think that you might be talking about pglite.dev when talking about wasm from my understanding, Wasm has a performance hit though from my understanding and unless one plans to run postgres on web. on the other hand a static cross platform single binary Postgres binary doesn't really have any performance hit. (anecdotally, Personally I would be interested for something like this existing and maybe even integrating i…

Yes, I'm sure the WASM binary for PG has a big perf hit. If you are just using it for testing, it probably doesn't matter? Why does the perf hit matter to you? Are you trying to run WASM binaries of PG in production? That seems like a terrible idea.

No, I am not running WASM binaries of PG in production given its perf hit but I would like to have the simplicity that I have with sqlite.

Re: Self-contained highly-portable Python distributions

#42

Post by zie »

Imustaskforhelp wrote: post #41
zie wrote: post #20

Earlier quoted context omitted.

Yes, I'm sure the WASM binary for PG has a big perf hit. If you are just using it for testing, it probably doesn't matter? Why does the perf hit matter to you? Are you trying to run WASM binaries of PG in production? That seems like a terrible idea.

No, I am not running WASM binaries of PG in production given its perf hit but I would like to have the simplicity that I have with sqlite.

My advice: Just use SQLite. Don't use PG if you don't need it. I mean PG is awesome. I use it all the time, but I also use SQLite all the time too.

SQLite is also a replacement for fopen()[0]. if you need to read/write data files, I recommend using SQLite instead. Replace your CSV's with SQLite, etc.

0: https://sqlite.org/whentouse.html

Re: Self-contained highly-portable Python distributions

#43

Post by zie »

cpill wrote: post #39
zie wrote: post #7

There is also the APE/Cosmopolitan cross platform binaries, which includes a python. Yes, cross platform binaries. The binaries run "natively on Linux + Mac + Windows + FreeBSD + OpenBSD 7.3 + NetBSD + BIOS with the best possible performance and the tiniest footprint imaginable." * Python Source: https://github.com/jart/cosmopolitan/tree/master/third_party... * Python Binary: https://cosmo.zip/pub/cosmos/bin/python w…

so in theory, one could program a game in python and then complete and distribute one binary for everyone?

Yes, though it wouldn't have to be in Python. APE/Cosmopolitan can work with many/most languages, not just Python.

Re: Self-contained highly-portable Python distributions

#44

Post by tonymet »

zahlman wrote: post #40
tonymet wrote: post #18

Are they less than 700mb?

What distributions are anywhere near that large?

it's a sort of inside joke about google cloud cli being > 1gb , because they include a python distribution and a bunch of third party deps . so i'm glad to hear that this app can ship smaller packages

Re: Self-contained highly-portable Python distributions

#45

Post by Imustaskforhelp »

zie wrote: post #42
Imustaskforhelp wrote: post #41

Earlier quoted context omitted.

No, I am not running WASM binaries of PG in production given its perf hit but I would like to have the simplicity that I have with sqlite.

My advice: Just use SQLite. Don't use PG if you don't need it. I mean PG is awesome . I use it all the time, but I also use SQLite all the time too. SQLite is also a replacement for fopen()[0]. if you need to read/write data files, I recommend using SQLite instead. Replace your CSV's with SQLite, etc. 0: https://sqlite.org/whentouse.html

Yup its a really decent advice overall but I feel like there were some few use-cases I think where postgres made more sense but I found the initial setup to be slightly more complex than sqlite and oh I love both sqlite and postgres and was just thinking of merging somewhat all the things that I like about them haha but I get what you mean, both sqlite and postgres are awesome :)
Post reply on HN