Thread with 33 posts
jump to expanded post
emulator developer folks: is there an off-the-shelf software package suitable for an app compatibility database. I don't want to use a wiki and I don't want to use an issue tracker.
FYI: i'm probably gonna write my own software for running an app compatibility database for an emulator. it won't be very complex initially, but it will be open-source and somewhat customisable, so who knows, maybe it'll be useful to someone else down the line
I started writing my own to use for touchHLE. it's going to be very lightweight, because the existing solutions weren't practical for me, but customisable, because I want this one to be practical for others. still very unfinished
GitHub's own tutorial for how you use OAuth with their API and get basic user info is out of date, but you know what's not out of date? that's right, my code to do that: https://github.com/hikari-no-yume/app-compatibility-db/commit/7d56a1d485739e87897c5a5cfececaddf42e5736
I think I figured out how to do sessions in PHP in the spirit of the GDPR and e-Cookie law (but maybe not the letter, I didn't check)
okay so the big thing i have left to do is screenshot uploads. this is annoying because of file handling, image processing, privacy, disk space… luckily i have thought of an absolutely horrible solution that solves all of these. oh boy
as usual I forgot to git add the new template file lmao 
as you may have seen, I got it complete enough to be happy to go live with it: https://social.noyu.me/@hikari/statuses/01HCDN752A0SGDNY4DJWK30RZ0
I've given it a license now, too, so you can use this web app for your own project if you want.
@hikari that's a very funny implementation lmao
semi relatedly still contemplating how i want to implement a big-print program in js, ideally supporting vectors and pdfs, but doing so would turn it from a weekend to do it with canvas and images to at least a week
@leftpaddotpy use SVG and then throw it at a PDF generator?
@hikari the challenge is that i want to accept pdfs as input also. i think the approach that would work is to create a large virtual pdf document of the entire virtual page, then use a pdf library to chop it into smaller pages with an alignment grid added and export those to a new pdf.
@hikari libaa? ;)
@0x2ba22e11 hahahaha now that would be funny
@hikari fuck yeah PHP (unironically)
@leftpaddotpy there's no better tool for a lightweight minimal-dependencies webapp!
@hikari Google Sheets
@0xabad1dea @hikari Today (that is 2023-08-30) I finally got rid of a Windows XP machine at a client that was running some EDI software written in a mishmash of batch files, Visual FoxPro, Delphi (and as I found out) Access. (the software is sadly still running, except it's now on a Windows 10 machine)
@jernej__s @0xabad1dea they used THREE different “easily build a GUI around your database” packages?!
@hikari @0xabad1dea Yup.
@hikari @0xabad1dea Oh, and the software's still in use, only now it's running on a Win10 machine.
@hikari @0xabad1dea Also, the most widely used business banking software's probably worse – it's got components written in Visual C 6, Visual C 2010, VB6, QT 3, and uses either Access or IBM DB2…
,
@beeoproblem@mastodon.gamedev.place
@0xabad1dea @hikari username checks out 😝
@hikari honestly? postgresql. yeah it sucks not to have a GUI for data entry, but :/
@leftpaddotpy @hikari we will say this about Airtable, it does have a very shiny data entry GUI
@leftpaddotpy @hikari pgadmin is .... fine if you're a database person and understand the schema and are okay with editing only one table at a time. not so great for any "interesting" data entry, it's more focused on schema maintenance tasks. same goes for dbeaver.
@hikari personally we'd be trying to make it someone else's problem.
but that's just how we are sometimes.
@hikari Not sure how off-the-shelf it is, but the Wine project has an app compatibility DB that is FLOSS: https://gitlab.winehq.org/winehq/appdb
@hikari If you find one I'd love to know what it is.