stoutfellow: Joker (Joker)
[personal profile] stoutfellow
Note: in the following, I am in no way boasting of my programming abilities. In the past, I've done a little programming using variants of C++, but not since IBM gave up on OS/2. (I liked that OS!) What I'm doing now involves MS Access and Access Basic - Tinker Toys, no more.

Anyway: after entering a few hundred books into my library database, I grew dissatisfied; I've begun a full revamp. (This is version 5.) Right now, I'm just plotting - working out the tables and forms I'm going to need. In some ways, this is the most fun part of the process - deciding just what I want to be able to do and how to do it most efficiently. (The limitations of Access Basic chafe occasionally, I'll admit.) Automate this process, make that information easily available on the fly, consolidate the other stuff so I won't have to enter it more than once - this is a fun challenge, and of a different kind than my workaday research.

I'm probably going to revamp my finances database too, but that can wait. I need to keep the old one around for the next while anyway, for tax and other purposes.

Date: 2017-10-22 03:53 pm (UTC)
graydon: (Default)
From: [personal profile] graydon
In some senses the only question to be asked about a database is how well can I back it up?

I'd be checking this very carefully, because MS Access did not have a good reputation for this in former days. (In part because it's not supposed to be what you use for anything important; that's meant to be MSSQL.)

Caveat: I have XML biases about databases, preferring hierarchical to relational. (Graph theory to set theory, by mathematical underpinnings.) This may be informing my reflexive response. :)

Date: 2017-10-22 04:48 pm (UTC)
graydon: (Default)
From: [personal profile] graydon
Not against amusement!

Just been around when someone's long-established personal accounts system died the death and there was no prospect of recovery. (The platform was unavailable on two levels and the single backup of the content was corrupt and the backup of the program wasn't the lastest version....) It becomes a twitch.

Profile

stoutfellow: Joker (Default)
stoutfellow

April 2020

S M T W T F S
    1 2 34
5 6 789 1011
12 13 14 1516 17 18
19202122232425
2627282930  

Most Popular Tags

Page Summary

Style Credit

Expand Cut Tags

No cut tags
Page generated Jul. 17th, 2025 10:55 pm
Powered by Dreamwidth Studios