Zach "earboxer" DeCook @zachdecook@librem.one

Migrating a #laravel site to #postgresql from mysql/mariadb

1. Run migrations to create db structure
2. Remove single quotes from the database (and newlines/control characters, because why not). This allows mysqldump files to be imported into postgresql.
3. mysqldump --compatible=postgres --no-create-info --skip-add-locks $DB | psql $DB
4. Fix increments `ALTER sequence song_id_seq RESTART 12345;` (current versions of laravel use old-fashioned postgres increments)

I thought a fun thing to do would be to switch my main VPS to #alpinelinux for more frequent updates (compared to ubuntu). (I run #nextcloud, a custom #laravel site, and some other simpler stuff) So far, I've started using #linode, and also have been learning that migrating from mysql/mariadb to #postgresql may have been too ambitious an idea.

@craftyguy
limtak: linux is more than a kernel

Because when we say #mobileLinux, we don't mean android or another locked-down platform.

LiMTAK: Linux Mobile atTAK

this isn't just the 'year of ...', it's the start of a war

LIMTAK: Linux In my Mobile: Tool Against Kludgery

A kludge is a makeshift solution to a computer problem. Time-based obsolescence (by outdated cas, un-upgradable emoji fonts) was a mistake baked into many software platforms. This tool frees us from it.

Hey fediverse! I'm called Zach, and yes, I love technology. Started coding as a kid writing #nds games using #PAlib, got into programming #microcontrollers. Spent several years doing #fullstack web development and some #devOps, looking to expand my skills and gain new experience.

Technology should (at least) do one thing well, and (necessarily) be there when you need it.

#introduction

anyone have an idea how #phosh could be modified to fade out the currently running app, so we could see our wallpaper?

#postmarketostweaks background setting gave performance issues, so I'm thinking this approach will be better.
So far, I have

*{background-color:unset}

in gtk.css

@agx Did you know that in #squeekboard, you can slide your finger across the keyboard to type adjacent letters? (This is actually my favorite unique feature of the phosh experience).

@tbernard What do you mean by 'the editor that won'? Who defines winning?

I needed to `sudo modprobe uinput`. This is really promising, I bet someone running #sxmo would be able to get it running faster because that supports splitscreen and #phosh doesn't.

I tried out #node-virtual-gamepads (https://github.com/jehervy/node-virtual-gamepads
).

#ioctl syscall crashes with #ENOTTY after I select 'gamepad'.

but we'll call this 'promising'. probably will be easier to add #gamepad support to #uxnemu than to try to wade through the levels of complexity to get #squeekboard to behave nicer under #SDL (it tells me unknown keyboard layout sometimes at compile)

@neauoire as a wayland application in phosh

In general, SDL projects work pretty good here.

With the recent talk about #gamepad support for some big #uxn apps, I wonder if there are any soft-gamepads that could work with #varvara #uxnemu on a #mobileLinux device.

Any leads?

apparently it's also important to delete the old records... and also that the new records are correct.

Installed a new home router, and I guess it decided to get us a new IP address, so my gemini capsule is down while the new A record propagates.

@zudn From a usability perspective, it's pretty bad too:
* starts with you deaf/mute (to try to scare people into using their phones to connect instead)
* browser version only allows you to see one person at a time (to get people to download the app so they can have more control)
* when screen sharing, it's hard to see all faces, takes over fullscreen on desktop
* phone app only shows 4 videos at once

today I added a script to my #gemini capsule to allow me to add to my /bookmarks.gmi file *using gemini*.

Seems like some of the browser experience could be done out in geminispace itself... less requirement for client authors, though that means more things "in the cloud".

@calebccff @postmarketOS
or...
* edit text/write code with #micro
* change my #squeekboard layout
* browse gemini:// with #fossil
* listen to podcasts with #kasts
* try to use the fediverse through #tootle
* ssh into servers... really, I like the squeekboard+kgx experience better than florisboard+termux/android

@calebccff @postmarketOS