#garfield Logs

Sep 13 2023

12:45 AM rue_mohr: looking at the core of the serial 16 bit processor project
12:56 AM rue_mohr: https://www.jiristepanovsky.cz/project.php?p=23cpu
01:44 AM polprog: rue_mohr: sure thing
01:44 AM polprog: what are you making it with?
04:00 AM Tom_L: hi
04:02 AM polprog: hey Tom_L
06:12 AM rue_mohr: php/postgres
06:12 AM rue_mohr: we could probably slip in a layer if you prefer the other database
06:17 AM polprog: iever did anything in postgres but thats not a problem
06:19 AM polprog: i never*
07:13 AM rue_mohr: so I have the following tables: uid (number generator for UIDs), schematics (schematicUID, title, child-of{schematicUID}), keywords (keywordUID, string), keywordlist (keywordUID, schematicUID)
07:14 AM rue_mohr: ... huh
07:14 AM rue_mohr: there should be a network filename for the image in there
07:14 AM rue_mohr: I'm not storing the images in the database
07:14 AM rue_mohr: just a link
07:16 AM rue_mohr: oh, wrong database hahah
07:17 AM rue_mohr: oh I had to
07:18 AM rue_mohr: oh
07:18 AM rue_mohr: *sigh*
07:18 AM rue_mohr: ok, so I stepped back and made it a bigger project
07:19 AM rue_mohr: so, like digikey, where you can do parametric searches, this has a table for each type of thing to search for
07:19 AM rue_mohr: you know how digikey gives you the 'device class' selection? each is a specialized table
07:20 AM rue_mohr: I currently have 2 main tables, one for transistors, and one for schematics
07:21 AM rue_mohr: its drilled down more, its specifically oscillator schematics
07:21 AM Tom_L: wow everybody's awake this morning
07:22 AM rue_mohr: the columns for them are UID, vmin, vmax, fmin, fmax, waveforms, partcount, osctype, and the image link
07:22 AM rue_mohr: morning Tom_L
07:22 AM rue_mohr: I'm off to work an hour early today
07:22 AM Tom_L: same time here but driving an hour
07:22 AM rue_mohr: there was a slip of communication and I dont know if I should be or not, so I am
07:23 AM rue_mohr: I'm confused about the schematics database, it looks like I was going two different directions
07:23 AM rue_mohr: ah BUT
07:23 AM rue_mohr: ok
07:23 AM rue_mohr: I numbered all the images and it links up with that first databse
07:24 AM rue_mohr: so yea, there are two systems, one to just file the images, and another to organize them
07:25 AM rue_mohr: I have 82 schematics in the system
07:25 AM rue_mohr: zippo:/files/programming/python/postgres/cardfile/schematics# ls
07:25 AM rue_mohr: S0000000019.png S0000000026.png S0000000033.png S0000000040.png S0000000047.png S0000000054.png S0000000061.png S0000000068.png S0000000075.png S0000000082.png S0000000089.png S0000000096.png
07:25 AM rue_mohr: S0000000020.png S0000000027.png S0000000034.png S0000000041.png S0000000048.png S0000000055.png S0000000062.png S0000000069.png S0000000076.png S0000000083.png S0000000090.png S0000000097.png
07:25 AM rue_mohr: ...
07:26 AM rue_mohr: there is a small python program to register the images with the database
07:26 AM rue_mohr: S is for schematic
07:27 AM rue_mohr: the goal was to make a system to do parametric searches
07:28 AM rue_mohr: a subgoal was to enter scan and register all my schematics
07:29 AM rue_mohr: the metadata was pushed off till later becasue it needs to be hand entered
07:29 AM rue_mohr: thats why the first database
07:32 AM rue_mohr: the scanning is a lot of work, getting the scanner brightness/contrast right, then doing cropping and cleanup
07:34 AM Tom_L: ok i'm off
07:34 AM rue_mohr: yep me soon too