Inviz

It’s sad that timescale aggregates don’t work on top of other aggregates. Abstractions is leaking. The ticket is left unaddressed for a while

I wish it was still the consensus among JS devs. People are putting css into JS files, on top of html

Can you share how are these two things related?

How about a library to enable operational transformation for this format? I wrote one once, but got really burned out with some of the stretch goals (log compression for 3+ participants).

3D movie maker was one my first computer experiences ever. The maskot and the intros, the movies and the scenes, some creepy looking uncanny cg backgrounds and music. Peak 90s stuff. Amazing product!

Bought my mom an Android TV and installed an apk that combines a movie catalog with torrent search. Can stream or download. Pretty neat stuff, although it's targeted for russian audience (searching russian trackers).

I'm on the lookup for TB4 dock myself. Caldigit stuff is out of stock. Stumbled upon this promising cheap alternative https://www.aliexpress.com/item/1005001486390431.html?spm=a2... that is a little north of 100$ and has m2 slot. Not sure if drives dual 5k displays, but it seems it should.

well that leaves blanks, right?

How about NChan? https://github.com/slact/nchan

It is an nginx extension, that has supports all types of clients, channels, multiplexing, introspection, tens of thosuands connects, etc.

I used this tool very successfully to auto-generate migrations. 1) I maintain "schema.sql" file that contains the schema I want to have 2) That file then is ran in a temporary empty database 3) Migra would run to compare old version of dev database against temporary database 4) Output of migra is wrapped into a conditional that has a guard check to see if database is already migrated to that version (as determined by timestamp in table description) and put into a file with timestamp as a name 5) Each time app restarts it scans all migrations in the directory and runs ones that it thinks it needs to run

Either way i had zero issues with this setup. And I used a lot of postgres things including triggers, complex indecies, extensions, etc. All migrations were source-controlled and could be verified before commits, so it was pretty safe. When I needed to migrate a data, i'd just add code into the same migration file as the schema change. Brilliant project! thanks @djrobstep

Even STM32F4 which is sub-10$ can run SQLite decently. 4kb ram for stack is quite enough, and then whatever amount of working memory you can afford on it will make life easier. Using sram extension makes it trivial even.

Yes, it only needs like 4 or 5 VFS hooks to be defined. No syscall malarkey

Yeah, littlefs wear leveling can be turned off for this case. Protection against corruption, and posix like api at small size is still useful.

Just integrated littlefs into my stm32 framework. Author has a helper library for coroutines, which can be used to plug in asynchronous hooks, making the fs non-blocking. My next step is to run SQLite on it.

I bought one from their site.

STM32s from China increased 3 to 5 times in price in last 6 months, biggest jump happened in last 6 weeks. STM32L family is especially hard to buy.

Yeah, indeed there's that limitation of a single distinct column. But it works for 80% cases, and it does not require any changes, so it's good. Looks like the earliest time proper implementation could hit mainline is 1.5years away.

Timescaledb adds a custom scan for speeding up distinct on out of the box. Just install extension, no extra work is needed.

https://blog.timescale.com/blog/how-we-made-distinct-queries...

I tried it and it really is that fast.

Wait for steam version

Always surprised by lack of mention of preact in these threads. Preact is to react is what petite-vue, but with no compromises.

All opinionated-ness seems to be very arbitary. It's a nice way to say "magical api"

# Full-stack javascript engineer [REMOTE, FULL-TIME]

Remote position for an early full-stack engineer at a seed-stage startup, working on investment literacy. Role provides high level of autonomy and ownership building end-to-end features in a wrapped mobile javascript app (Preact, Node.js, PostgreSQL). Candidate should be able to identify 80% of impact that requires 20% work, and stay focused on the current needs and scope of the application.

At least 3-4 years of full stack development experience at a technology company (preferably consumer) is required. It would be important to understand how to build apps that work on multiple devices that have very little edge cases and weird states. Experience with react is strongly recommended.

Typically work happens during 7:00-15:00 EST timezone, at least 3-4h overlap is desirable.

Contact simon@getmedes.com

Archimedes is an early stage startup out to create a trusted platform for people to learn investing and make it a bigger part of their lives. Our users will learn in a fun and accessible manner through engaging content. We believe that the journey to become a more informed investor shouldn’t start on social media or google.

Read more: https://rb.gy/qxn8xr

Yes, currently it's a wrapped ios/android app. But the web app is in the making. Technically there are no limiting factors. It just helps us to concentrate on the mobile experience first. The reasoning goes that the lessons are bite sized, and really easy to consume on the go.

Hello HN! My name is Yaroslaff Fedin, and I’m a cofounder at Archimedes Finance, where we’ve been building the new kind of learning experience that helps people improve their investment and financial literacy.

The mobile app hosts a number of bite lessons, organized into courses. The big feature is the turn based game leading the player through different financial situations and opportunities. The game presents a simulation of stock market with different financial vessels, taxes, 401k, and a tiny bit of property market. It is aimed to cultivate informed investing, following and understanding market trends, and thinking long term. One of the interesting aspects of the game, is that it’s asynchronously competitive (leaderboards are normalized to game turns). The game story is about an EvilCorp corrupting the town, that can only be stopped with the help of friends and wise financial decisions. The player needs to stay alert to prevent tragedy from happening, and their local community dissolving.

Archimedes is a wrapped web-app, built on preact. We’ve built quite a cool pipeline for 3d assets, and a small engine based on three.js that plays animated scenes. I think it’s remarkable how many different aspects of learning we’ve managed to pack into a small package. We’ve tried to make the learning free, playful and accessible, without making compromise on the content.

I have had exactly same issue, though with third party service. They replaced the screen, and when I came home it froze one time, and started beeping 3 times indicating ram problems. Because it was iMac, i had a chance to rearrange RAMs to boot up but it still was freezing up at times. I ran memcheck, found errors, and then figured out which ram planks was faulty.

The thing is that the issue started long before that, my Blender app would crash in tens of times a day, and same with Solidworks on windows.

So yeah, i recommend running memtest and replacing ram if necessary.

It is really unclear, why doesn't this use Skeleton system built into three.js, that supports playing animations, etc.

Yes, didn't miss it. I also deleted twitter, which was far more useful, but still I think it was good idea.

select region, count(*) from projects, unnest(region_ids) as region GROUP BY 1;

How about consultancy work? That's what I did in US with B-1, and specificially I talked to border officer about this being legal.

It is possible to overload operators in JS through a horrible hack of valueOf():

http://webcache.googleusercontent.com/search?q=cache:DKKZb1P...

Discussion: https://news.ycombinator.com/item?id=8677721