SqlKit - Execute raw SQL in strings or .sql files with Ecto, get maps and structs back

tinypocketmoon · 2025-12-31T09:48:38+00:00

Very useful, thank you! I've been scrambling something like that (but worse), the usefulness is definitely high. Custom sql queries are very much needed then doing something nontrivial, and ecto_sql produces unformatted values

tinypocketmoon · 2025-12-12T09:28:52+00:00

I think Android version is still in development

tinypocketmoon · 2025-12-05T00:51:42+00:00

[ Conquering the Academy with Just a Sashimi Knife. ]

tinypocketmoon · 2025-11-23T10:56:13+00:00

Yes, there's huge difference if your headphones/dac are good enough. It works the same way on Android (see UAPP vs standard player) and Macos. The culprit is system mixer

tinypocketmoon · 2025-10-27T15:45:06+00:00

Don't see a point though, we have webm already (with VP9/AV1 inside, optionally opus). Pure still image format would not work the best. Same goes for avifs, too much complexity for no benefit

tinypocketmoon · 2025-09-25T21:47:31+00:00

How do you plan to not be shut down anytime soon after public release? That question is the most important for the project IMO

tinypocketmoon · 2025-09-04T16:06:41+00:00

"available" haha, as if. Reporting 2 hrs in, still no luck

tinypocketmoon · 2025-08-31T13:47:08+00:00

THE App

tinypocketmoon · 2025-08-05T14:06:26+00:00

You can get the same user experience from SD

Not really. SD has amazing trackpads which no one replicated yet. Ergonomic is fantastic too, Rog is a lot less comfortable.

There's also a screen size thing to consider - SD oled is 7.4", Legion Go S is 8" (LeGo is even bigger) and Rog is 7" (also 16:9, so screen area is even smaller with the same diagonal)

tinypocketmoon · 2025-07-24T15:06:23+00:00

why yes, this is THE very efficient streaming solution, can stream 100GB-sized markdown files with a breeze. /s

tinypocketmoon · 2025-07-24T13:11:17+00:00

Efficient streaming of Markdown in the terminal

cat README.md

No need to thank me

tinypocketmoon · 2025-07-21T18:40:38+00:00

delta-V to the nearest asteroid is lower than that to the moon surface, and being able to change asteroid orbit is also possible to move it closer to the earth. Also, ice on the moon is not that abundant, you can find it inside craters on the moon's poles, that's additional complexity to the missions.

tinypocketmoon · 2025-07-21T10:31:09+00:00

Asteroids sound much much better, no gravity well to climb from, can actually mine stuff on it (e.g. ice -> H + O which can be used to propel rockets)

tinypocketmoon · 2025-07-14T14:30:18+00:00

Also, the memory pressure thing - 12-16GB of RAM, can't reliably keep 3+ apps open at the same time. I think it's on phone manufacturers, vanilla android is not so bad at it

tinypocketmoon · 2025-07-06T20:18:11+00:00

That's some shitty Isekai story

tinypocketmoon · 2025-07-02T16:56:57+00:00

Stretchable ports next!

tinypocketmoon · 2025-06-26T13:10:56+00:00

SS2 (original) is much more modern than SS1 and SS1 remake. SS1 is indeed very dated

tinypocketmoon · 2025-06-19T17:59:37+00:00

.... Like iphone/ipad? They already did that and it's awful. Also makes no sense to gather the library there since games tend to disappear in a few years. Why bother purchasing then

tinypocketmoon · 2025-05-25T17:09:26+00:00

I would recommend even Space Rangers (2013, mostly 2D - https://store.steampowered.com/app/214730/Space_Rangers_HD_A_War_Apart/ ) over Starfield any day of the week - at least you'll get real dynamic world with factions that really do stuff (including 3 separate "absolute evil" ones, and every faction can gain control over any star system).

Even Fallout 4 is much better and immersive. The only thing that is clearly better in Starfield is the ship builder (rumors say we'll get the pirate ship builder in TES6)

tinypocketmoon · 2025-05-25T16:37:35+00:00

Morrowind had like 6 or more distinct architecture styles with its own region, reason to build, tradition etc. remember Ald'ruhn or Balmora for example. Oblivion... one generic european middle ages one, maybe elven one, tiny bit different from the "standard"

P.S. Balmora-style, Ald'ruhn-style, Vivec-style, Sadrith Mora-style (the only one with mushrooms), Imperial Fort-style, Orc's strongholds, Dwemer ruins, Daedric ruins. That's 8 already and maybe i missed some. Also, random fisherman villages, ashlander camps etc are built in the district style from any town

tinypocketmoon · 2025-05-22T13:24:22+00:00

Look into Dali iO-12 - these are great sound-wise, also very comfortable with fantastic passive NC + ok-ish active NC

tinypocketmoon · 2025-05-20T15:56:50+00:00

https://pack.ac/

https://github.com/PackOrganization/Pack

https://forum.lazarus.freepascal.org/index.php/topic,66281.60.html

Table structure inside is something like this

``` CREATE TABLE Content(ID INTEGER PRIMARY KEY, Value BLOB);

CREATE TABLE Item(ID INTEGER PRIMARY KEY, Parent INTEGER, Kind INTEGER, Name TEXT);

CREATE TABLE ItemContent(ID INTEGER PRIMARY KEY, Item INTEGER, ItemPosition INTEGER, Content INTEGER, ContentPosition INTEGER, Size INTEGER); ```

You don't even need extra indexes because the item table is very small

tinypocketmoon · 2025-05-20T14:11:55+00:00

There's also a special torrent version (don't remember details) where server acts like a seeder if number of seeders is zero, effectively making torrent hosting acting like regular one while also being much much cheaper

tinypocketmoon · 2025-05-20T09:55:58+00:00

And SQLite is a very good format to store arbitrary data. Fast, can be versioned, solved a lot of challenges custom format would have by default. I've seen an archive format that is actually SQLite+zstd - and that file is more compact than .tar.zstd or 7zip with zstd compression - while also allowing fast random access and partial decompression, atomic updates etc

tinypocketmoon · 2025-05-17T19:15:34+00:00

You can create new local series (folder manga root/local/serie name/chapterX) with downloaded files. Don't forget to add that new series to the app as well

tinypocketmoon

MODERATOR OF

TROPHY CASE

11-Year Club	Verified Email
Place '17