Alex Buznik Logbook
Inspired by some things that my direct manager is doing with ChatGPT I tried to do another experiment.
This time I asked it to develop a sea ships game, with a network connection where multiple players can take turns.
Overall for this version I spent about two hours and several iterations to create front-end and backend.
Obviously, this is just a prototype, but overall it’s a start!
Hi.
Thought I should share this.
I’ve done some development on a pet project using prisma and MySQL.
I added a new model with a relation and was getting an error prisma foreign key error constraint failed on applicationId P2003 when trying to create this new model even though the code and schema looked ok.
The fix was to rename the reference field to a lower case, so it’s different from the actual model name. Probably trivial for someone, but I haven’t any explicit notes against it in the docs.
model Invoices {
id Int @id @default(autoincrement())
...
// works:
application Application @relation(fields: [applicationId], references: [id], onDelete: NoAction, onUpdate: Cascade)
// does not wrk:
Application Application @relation(fields: [applicationId], references: [id], onDelete: NoAction, onUpdate: Cascade)
applicationId Int
}
Hey.
It’s been a while since the last time I’ve posted anything here.
Full-scale war was launched by russia in Ukraine. The life was kind of quirky these months.
Anyway, the company I work for, managed to continue the business, almost without changes. Some part of the team has moved out of Ukraine, but otherwise our work rhythm is back to what it was before.
Found some interesting things I wanted to share:
Simple JSON to TypeScript Converter
We are in the process of migrating to TypeScript, so this is quite handy.
You put in a bunch of JSON of your data, and get a typed interface(s) as a result: http://json2ts.com/
Simple notification system / bot for github/gitlab
(and some other services) – https://danger.systems/
I made a small demo for my team https://gitlab.com/beshur/danger/-/merge_requests/5
Help Ukraine win this war by donating to charity https://www.comebackalive.in.ua/donate
One of my most fun interviews was with DI.FM in 2018.
On the coding lab I was asked to make a tic-tac-toe game in one hour.
I was later given some time to refine it afterwards, but the core thing was done in time and it was interesting.
Play with someone.
Uploaded source to github.
Here is my new small project – TableStatus/StenGazeta (Daybook.buznik.family as of November 2020).
I have been thinking about creating some kind of a status screen for my home and family for a long time.
Our friends have recently donated an old iPad 2 to us. It runs iOS 9.3.5, so I can barely install a handful of apps from Appstore. That’s where this idea started.
I could never gather all the details until this Christmas, when I got some time and slapped together a preact web app.
It’s a web page that displays widgets:
Nothing particularly interesting about those – mostly leveraging a couple of APIs.
I used openweathermap.org for weather, and Google APIs to retrieve the calendar and photos.
The notes are just a text area that stores value in localStorage, not synced across sessions.
You can just visit Daybook page on your iPad and it will work.
In order for Calendars and Photos to work, you need to login with your Google account.
Right now, I’m happy with the result, though I’m adding some ideas as enchancements on Github.
It has a readme which has some notes on the API keys that you need to get and some other vars to set up.
The project is build with webpack and can be hosted on any kind of hosting. I use Netlify for it.
You can set up one for youself, too.
Anyway, let me know if you’d like to use it, but it lacks something via this form.
The project is definitely not to show off my React skills, rather the opposite – I wanted to slap some stuff together in a very limited timeframe and also to try preact.
Also if you are a beginner and want to learn by its code – it’s not the best specimen.
I wanted to go really minimal and was lured by preact’s promise of 3kb gzipped size.
However I ended using the preact CLI to create the project boilerplate together will the webpack and compilers and other stuff, and 260Mb node_modules.
Also tried to start with React Native, but its toolchain is still not clear to me. Ran into a couple of issues with the suggested solutions as “reinstall all your node_modules and cocoa pods”, not cool.
This is a desktop player for DI.FM that I made for the 20-year anniversary.
I gathered a lof of experience during this proejct:
Desktop player based on Raspberry Pi, that can play DI.FM channels (IceCast streams to be exact).
It is controlled with photoslides frames that have NFC-stickers on them, the stickers point to certain channels.
The player can also play other sources like Spotify, Google Play Music, Soma.fm thanks to MusicBox software.
It has a physical Play/Pause button, volume knob and a small screen that displays current track. Sound output is through audiojack or HDMI (Raspberry Pi standard).
(more…)