#garfield Logs

Oct 25 2022

03:24 AM rue_mohr: polprog,
03:34 AM rue_mohr: 8-|
03:34 AM rue_mohr: its 1:30am, comon
04:31 AM Tom_L: morning
09:53 AM rue_mohr: mroning
09:53 AM rue_mohr: mmm
09:54 AM rue_mohr: polprog, you responding?
09:54 AM rue_mohr: Tom_L, you did a parts database didn't you
09:54 AM rue_mohr: for stock
09:54 AM Tom_L: spreadsheet
09:54 AM Tom_L: not ideal
09:54 AM rue_mohr: ok
01:18 PM polprog: hi rue_mohr
01:18 PM polprog: i like that PWM trick with the saturation
01:19 PM polprog: i was thinking of making a parts database
01:19 PM polprog: but for larger parts
01:19 PM polprog: like, yesterday i bought a thinkpad power supply cause I was sure i lost the other one
01:20 PM polprog: and of course when i came home it hit me where the old one was, turns out there was the original one and yet another spare there
01:20 PM polprog: so now I have 4 of them
01:34 PM polprog: writing it is not as bad as filling it with meaningful data
02:42 PM polprog: projects projects projects
02:42 PM polprog: i have so mich that i lost count
02:43 PM polprog: including two that are revolving around disassembly of software
02:44 PM polprog: I i were writing it it would probably use sqlite or mysql and php/python flask
02:44 PM polprog: and be web based
03:14 PM polprog: and i have to make up a similar system for tracking projects
07:06 PM rue_mohr: polprog, yea, I want to make something parametrically searchable like digikey
07:06 PM rue_mohr: but for the parts I have
07:07 PM rue_mohr: every time I have to search for a transistor its a mess
07:07 PM rue_mohr: the excel sheet is longer than a page and doesn't just search well
07:07 PM rue_mohr: web based for sure
07:08 PM rue_mohr: like digikey
07:09 PM Tom_L: might be easier to enter the pn in dk and do a 'similar' search
07:09 PM Tom_L: would take quite some time to enter all that data on your inventory
07:10 PM rue_mohr: no,t hey dont have most of the parts I do
07:11 PM rue_mohr: I can enter it as I search
07:11 PM rue_mohr: I usually do
07:11 PM rue_mohr: I have to get into my shop, I'm freezing
07:17 PM Tom_L: but it's not freezing there...
07:18 PM Tom_L: 8C
07:36 PM rue_mohr: I was helping a buddy who rented an excavator to level his yard
07:36 PM rue_mohr: it decided to pour rain
07:36 PM rue_mohr: we had to stop because everything was turning to soup
07:37 PM Tom_L: sucks for the rental
07:37 PM rue_mohr: yea, it got a tad dirty
07:37 PM Tom_L: did you get done?
07:37 PM rue_mohr: most of it
07:38 PM Tom_L: i have a couple more branches i'd like to trim before winter but got the worst one done
07:38 PM rue_mohr: there was a stump that wasn't big enough becasue the excavator wasn't big enough to pull something out that was tied into a HUGE set of old other roots
07:38 PM rue_mohr: oh I have to do that too, here
07:39 PM Tom_L: mostly what i could reach with the pole saw
07:39 PM Tom_L: powered..
07:39 PM rue_mohr: I'm trying to make a power converter, redo of an old attempt
07:39 PM rue_mohr: see if what I'v learned about magnetics is worth anything
08:13 PM Tom_L: did you ever have a stamp?
08:14 PM Tom_L: what uC were they?
08:14 PM aandrew: rue_mohr> polprog, yea, I want to make something parametrically searchable like digikey
08:14 PM aandrew: that's a LOT of data entry
08:15 PM Tom_L: i remember all the paperbacks i had on logic chips...
08:18 PM rue_mohr: aandrew, not really
08:19 PM rue_mohr: see, I dont have purchased stock
08:19 PM rue_mohr: most of it is scavanged
08:19 PM rue_mohr: if I'm searching for a <transistor> I ahve to look them up anyhow
08:19 PM rue_mohr: and its not a lot more work to jot it down into a "database"
08:20 PM rue_mohr: I'v done it multiple times before
08:20 PM rue_mohr: "multiple times"
08:20 PM rue_mohr: lists
08:20 PM rue_mohr: lots of lists of transistors
08:20 PM rue_mohr: on paper
08:20 PM rue_mohr: that get lost from time to time
08:21 PM Tom_L: https://mementodatabase.com/
08:21 PM Tom_L: i use that on my phone
08:23 PM rue_mohr: huh
08:23 PM Tom_L: but i import all the files from the pc
08:23 PM rue_mohr: can you set up fields and do multi-field parametric searches?
08:24 PM Tom_L: remember that java translation thing you helped me with?
08:24 PM rue_mohr: ah
08:24 PM Tom_L: i think so
08:24 PM Tom_L: you can sort by any field
08:24 PM Tom_L: list in multiple field order
08:24 PM Tom_L: enter a query and it shows the results
08:25 PM Tom_L: it's simple but works for what i need mobile
08:25 PM rue_mohr: yea so like where VCE > 40 and HFE > 20, sort by Ic
08:25 PM Tom_L: i've never done querys other than = but you probably can
08:26 PM Tom_L: i think they have a free version you can look at
08:26 PM rue_mohr: yea I dont need a database for things like capacitors, I know I have all that
08:26 PM Tom_L: you may just be limited on how many files you can create, i dunno
08:26 PM rue_mohr: I dont really mind digging in raw and using postgres and php
08:27 PM rue_mohr: arg, I want to play and I'm tired
08:27 PM Tom_L: you got an android, play with the free version
08:27 PM rue_mohr: I have to see if I can get gimp, from command line to invert the colours of an image
08:32 PM Tom_L: search criteria: contains, not contains, is equal to, is not equal to, is empty, is not empty
08:33 PM Tom_L: i dunno if you can combine them
08:33 PM rue_mohr: yea hmm
08:34 PM Tom_L: there is an 'and' and 'or' for multiple field search
08:34 PM Tom_L: so in your case above it would work
08:34 PM Tom_L: it's more of a filter
08:34 PM Tom_L: only show...
08:34 PM rue_mohr: yes
08:35 PM Tom_L: then there is 'sort' and 'group'
08:35 PM Tom_L: i can group by area for example or zipcode etc
08:36 PM Tom_L: sort by last name, grouped by city, with 776 in the phone
08:37 PM Tom_L: sort by last name, grouped by city, with (776 in the phone .or. 456 in the address)
08:40 PM aandrew: Tom_L> https://mementodatabase.com/
08:40 PM aandrew: I was really interested until it's a cloud service with offline capability
08:41 PM Tom_L: i use mobile purely local
08:41 PM Tom_L: you can turn off cloud or turn it on
08:41 PM aandrew: personal cloud (webdav, point it to some server, etc.) would be worth it
08:42 PM Tom_L: if i'm loading it on another phone, i empty the database keeping the structure then put it on my cloud and copy it down to the other phone then populate it locally
08:42 PM aandrew: $60/yr isn't bad, just want to never lose it if they decide to go away
08:42 PM rue_mohr: aandrew, do you understand gimp scripting?
08:42 PM rue_mohr: polprog, ?
08:42 PM aandrew: rue_mohr: lol no. I barely understand shell scripting :-)
08:42 PM Tom_L: i purchased the 'pro' whatever version so i could edit mine freely, my partner has the free version
08:43 PM Tom_L: which works just like mine but he doesn't do dev on it
08:43 PM Tom_L: it was minimal cost iirc
08:43 PM aandrew: yeah I'm looking at pro for no ads but need to see what I can do with it
08:43 PM aandrew: damn, something else to look at :-)
08:43 PM aandrew: thank you though
08:43 PM Tom_L: heh
08:44 PM Tom_L: i export a cvs from the pc to it
08:44 PM rue_mohr: gimp has no concept of "the current open image"
08:44 PM Tom_L: and actually get things like salestax data already in a spreadsheet from the state
08:44 PM Tom_L: just massage it a little and export it
08:46 PM Tom_L: i don't pay any monthly fees
08:46 PM rue_mohr: oh there we go
08:46 PM rue_mohr: gimp image list
08:47 PM Tom_L: https://apkcombo.com/memento-pro-license-key/com.luckydroid.mementoprokey/
08:47 PM Tom_L: aandrew,
08:48 PM Tom_L: i'm not sure that is still used but it's on my phone
08:49 PM Tom_L: when i open it, it says it's for an older version
08:49 PM Tom_L: wait.. no it doesn't
08:51 PM Tom_L: i maybe got that for unlimited libs, i don't remember
08:52 PM Tom_L: there are quite a few templates available too but i didn't use any of them
09:01 PM Tom_L: <aandrew> ....just want to never lose it if they decide to go away
09:01 PM Tom_L: i've had it for quite a few years now
09:03 PM Tom_L: 2014
09:04 PM Tom_L: and the pro license was $9.99 then