Databases on the Amiga
Вставка
- Опубліковано 21 жов 2024
- Looking at Database software on the Commodore Amiga.
Interbase and Superbase.
We create a fresh database to record our games collection.
---
Support the channel by donating via Ko-fi:
ko-fi.com/mike...
Love this series.
Glad you are enjoying them. :-)
I like the series very much, too. I love to use my Amiga for a productive task from time to time. Like writing a letter on it and printing it on my Brother laser printer from 2019. I'm having a blast each time I'm doing this. 😀
Excellent series. I love looking at serious software for the Amiga. Thanks
Glad you are enjoying them :-)
Interbase still lives today. It went through DEC, Borland, and now owned by Embarcadero.
Ah the old Games database. The first ever program I wrote for my C64 (I.e. one I created, not type in) was a Games Database. I catalogued all my Game cassettes and what counter the cassette should be set to load a game etc. I then put the ID number on the spine of each tape to make it easy to find. I mean it wasn’t like I had soo many games that I didn’t know where they were or that the inlay didn’t contain the counter offset. But still, it was fun. I then did something similar on the Amiga but as a personal contacts thing in Amiga Basic.
around 1997 I used Superbase to manage contacts and dues payments for a club. The relational feature and forms was really impressive to me at the time. To me, those are the key features (in those days) to move up from a simple spreadsheet. Really, without them, Interbase is just a clunky, HARDER to use spreadsheet.
There's a manual available for Superbase, but at 333 pages, it's not exactly bedtime reading. It seems extremely powerful though, and as an experiment using UAE, I was able to import an 18,000+ row database via CSV. Be aware though, it doesn't like the " symbol. I've not read the manual, but I believe the syntax it uses is similar to dbase3, as that was the leading package at the time, on the PC anyway. Superbase is, however, definitely showing its age these days, and I've occasionally had corrupted data. Maybe that's just the quirks of running it under an emulator. It also saves the data in 'blocks', which a lot of database managers for the Amiga didn't do. the benefit of this, is that if you update 1 record, it doesn't write the entire file, just a... say, 64-byte secton if it. Especially useful if you used it with floppies.
Nice, I might skip on the manual but it's good to know it's still out there for people to gain this knowledge. Cool to know that you've sucessfully imported some data in via csv.
Regards the corrupted data under emulation, I'm presuming this would of been emulating hard drive. I'm curious, if it was hard drive file or just pointing to a windows directory. If it's the later the corruption could be windows not liking what's written and you might have better luck with hdf.
Twist2 is the best database for the Amiga I have used. Superbase/SBase4 is good, did some programming in back in the day but, Twist2 is very quick and easy and powerful enough for most uses.
Use to work with InfoFile, this was a nice program that also looked good.
Superbase 2 was delivered with a hardware dongle. Sadly I lost mine somewhere and it never came up. Maybe another dimension. There was also a Database from Maxon which looked pretty cool.
I really like ProData but I am having problems finding the manual
Fantastic series.
Hi all, does anyone know where I can find the superbase rom for amiga? thanks
If you ever have a program like Interbase that can't seem to handle long path names, you can create an assign (eg. ASSIGN DB: Work:Data/MyStuff/Databases) and use that instead.
Game name: Escape from the Planet of the Robot Monsters
44 characters :D
Good tip. Thank you :-)
Escape from the planet of the robot monsters (44)
😀
promo sm 💔