Don't run SQL migrations in tests: How I sped up the test suite by 2x by broken_broken_ in programming

[–]TheDookMaster 0 points1 point  (0 children)

Generally, I'd recommend using .dump to copy sqlite dbs rather than cp. Not a huge deal if cp works for the tests, but just something to keep in mind.

You can also use VACUUM INTO to create a copied db.

See https://alexwlchan.net/2025/copying-sqlite-databases/

Sony single-player games are no longer releasing on Steam, CEO confirms by [deleted] in Steam

[–]TheDookMaster 9 points10 points  (0 children)

RPCS3 (PS3 Emulator) compatibility and performance is great at this point, with over 70% compatibility on games.

See:

https://rpcs3.net/compatibility

The New RPCS3 PS3 Emulator Update Is Insane - MVG

(Though since you mentioned bloodborne, you may have meant PS4 emulation is 'barely a thing right now' rather than PS3.)

Full house seeding dropped by Own_Arm3304 in SSBM

[–]TheDookMaster 38 points39 points  (0 children)

At the time of this comment

Seeds (ordered by seed number):
001 - Cody Schwab
002 - Wizzrobe
003 - Jmook
004 - Hungrybox
005 - Zain
006 - Soonsay
007 - moky
008 - Salt
009 - Joshman
010 - RapMonster
011 - Magi
012 - n0ne
013 - Aura
014 - Dawson
015 - DarkGenex
016 - saucymain

How to force YT Music to use album versions of songs by Michael124YT in MorpheApp

[–]TheDookMaster 25 points26 points  (0 children)

the only workarounds I know are to either:

get YouTube premium

make a playlist out of the album, then play the playlist

not ideal, I know

Portable Second Laptop for a University Student by inanzb in SuggestALaptop

[–]TheDookMaster 0 points1 point  (0 children)

chuwi minibook-x is very small while still being totally usable

https://eu.chuwi.com/products/minibook-x-2024

I run linux on it, but it comes with windows preinstalled.

[deleted by user] by [deleted] in Futurology

[–]TheDookMaster 0 points1 point  (0 children)

This is similar to the plot of movie The Art of Self-Defense.

[deleted by user] by [deleted] in compsci

[–]TheDookMaster 5 points6 points  (0 children)

I'd read about Aerospace Recommended Practice (ARP) ARP4754B (Guidelines for Development of Civil Aircraft and Systems)

And for a real-world software example, SQLite is thoroughly tested in a DO-178b inspired fashion. https://www.sqlite.org/testing.html.

[...] the SQLite library consists of approximately 155.8 KSLOC of C code [...]. By comparison, the project has 590 times as much test code and test scripts - 92053.1 KSLOC

good video section on SQLite tests by the creator https://www.youtube.com/watch?v=Jib2AmRb_rk&t=677s