And blazer[0], the closest thing to a perfect BI tool. It has a SQL editor/runner, saved queries, audit history, dashboards, alerts and user access control; all in a rails engine you can mount with minimal configuration.
For tutorials and hardware, check out Adafruit. If you’re okay with less polished documentation, also look into M5Stack (they are really cheap on AliExpress).
I currently work in e-commerce using Ruby on Rails, which I really enjoy. However, I do miss my previous work on the weird side of software and electronics for art installations on galleries and events[0]. If anyone wants to chat about or pair on embedded development, feel free to reach out to me at my username at hey.com.
[0]https://vimeo.com/389519079
Thanks for the suggestion! As I understand, you can only postgres_execute against a running Postgres db. It does work and I’ve used it in my tests, I think I could get around the limitations that I ran into by running a pg instance alongside DuckDB.
For now I think I’ll stick with just pg, as I was looking into DuckDB to replace pg in my local analytic workloads: load data from rest apis, dump into a database and use sql in a custom dbt-like pipeline to build the tables for analysis in bi tools. Unfortunately, many endpoints return xml data and much of the sql I’ve already written deals with json, meaning it would have to be adapted to work with DuckDB.
DuckDB has great ergonomics for moving data between different databases and making copies for local analysis.
The one thing that differed in my experience with it from the author’s is how much of the Postgres sql dialect (and extensions) it supports. Attempting to run my Postgres analytics sql code in duckdb errors out on most json operations - to be fair, the DuckDB json functions have cleaner names than jsonb_path_query - also, DuckDB has no support for handling xml, so all xpath calls fail as well.
Hotwire is the umbrella term for turbo, stimulus and strada. Turbo has client and server side components that enable easy ways to do partial page refreshes and send html templates (turbo streams) to initiate page updates from the server. That’s all without writing any js (using mostly data attributes and custom html tags, like turbo-frame).
Stimulus comes in as a small framework for the cases where you want to write some JavaScript, in a way that you still control the behavior from html, by attaching controllers to elements explicitly.
These two aspects are similar to htmx:
- send html from the server even for partial page updates
- encode desired js behavior into the html
The main difference is that turbo is designed with a convention over configuration attitude, as many of it’s behaviors are automatic (like intercepting all form submissions and handling them using fetch, preventing a full page reload). When custom js is needed Hotwire defers to letting you write actual js code, htmx has this tailwind style shorthand that allows you to basically write js from the html.
I haven’t worked with web apps that need highly interactive frontends, but for our e-commerce stores and internal rails apps turbo and stimulus have really lowered the bar on how much new developers must learn to build a nice to use website.
We have our own servers (mostly consumer pc parts) and run lxd to slice them up into vms/containers. Deploy to those using kamal and expose the web server port through cloudflare tunnels. With simple scripts to periodically compress and upload the storage volumes and database dumps to Google drive, most of our less critical apps cost about $0 to keep running. For the higher criticality apps, we also deploy them to Linux vms using kamal, but use a commercial service (linode).
Thanks! That’s exact what I was looking for: great design and usability.
And also cool that on-running is a Solidus store, which is the framework I’m working with.
If anyone has additional recommendations of exceptionally well designed e-commerce sites, please share them. I’m looking to build a collection focused on the segment.
I am hearing about Ubicloud for the first time and it sounds very good. I don’t have a need for a cheaper GitHub runner now, but I’ve been dreaming about a modern, less complex open stack alternative for some time. Also, having a cloud service combined with the open source product seem like a great fit!
This looks great! Are there any plans to include Ruby as a supported scripting language along with Python, Typescript, Go, Bash, and Sql?
I currently use my own crude workflow runner for processes that are mostly sql, but with some ruby code. I’ve stuck with it because it works and we currently use Ruby for almost everything, so it’s not worth it to add another language to the mix so we could use a better tool.
I got the exact same permanent ban for supposedly violating Facebook’s advertising policies, but I’ve never ran a single ad there.
My account was unused for about five years, when I recently logged in to try the WhatsApp API, I got an email asking for a document to confirm my identity. I sent the email and received a successful response. About a week later I received an e-mail of a permanent ban from fb ads.
Annoyingly, even though I had no plans to advertise there, I can’t generate a system user and get a longer than two months access token for my WhatsApp api. Also, my business (registered within my personal account and I’m the sole member) has full advertising capabilities.
TLDR
- I got permanently banned form ads without ever running an ad
- due to the add ban I can’t create a _system user_ and so my WhatsApp api tokens are limited to the two month extensions allowed on the temporary tokens
- my dev/business within my one account can advertise on fb normally
- obviously there nothing resembling support from fb
3D Touch capable models (6s to x) had actual pressure sensors embedded in the screen assembly, which meant there was another input channel (how hard you pressed) that apple mapped to an extra commands, like a right click. To highlight text with it, you could press slightly harder anywhere on the keyboard and that would start cursor movement mode (like holding on the spacebar on newer models), then, with the cursor on the word you wanted to start highlighting from, you pressed a bit harder and it would highlight from that word on until you released the keyboard.
I mostly don’t miss wsl on Mac because most software I use works well in both Linux and Mac, just not windows. When I want to test something on linux from my Mac, I use and recommend Canonical’s multipass.
Seems that the token is ignored when I type it, you can see some tests of this in the end of my linked chat. The interesting out of context replies only happen when ChatGPT generates the token in a reply.
I love this idea and will try to create apps with it.
I’ve been thinking about creating something similar in ruby/rails for a while. It is currently a proof of concept with dbt like functionality using erb templates for sql. I would love to chat about it with interested rubyists, reach me via email on my username at hey dot com.
The main issue I see older people have with iPhones is unrelated to ui complexity. iOS’ worst parts are services/updates where the user is frequently asked for Apple ID passwords and shown confusing ads for Apple services like iCloud Photo Library that end up making photos more complicated to use as some pictures are now unavailable without internet. More parts of the iOS experience are getting unnecessarily tangled with server side services that require unpredictable prompts to get acceptance to terms and conditions, logins, and traps that make you set up two factor auth or buy an unnecessary subscription.