#garfield Logs
Nov 17 2022
#garfield Calendar
10:01 AM aandrew: it seems like this kind of problem has been solved a hundred different ways... does it make sense to try to create 101?
01:24 PM rue_mohr: anyone know where those solutions are?>
01:25 PM rue_mohr: somehow I dont think DK would hand their system over...
01:25 PM Tom_L: don't ask them
01:27 PM Tom_L: https://blue-squirrel-webwhacker.software.informer.com/
01:28 PM rue_mohr: database engine tho
01:28 PM Tom_L: must be java or sql
01:28 PM rue_mohr: the front end is almost nothing becasue its dynamically generated
01:28 PM rue_mohr: yep, java<->php<->database
01:44 PM aandrew: rue_mohr: partkeepr, snipe-it, openboxes, bomist (might not be a good fit), tryton, mypartsbin, binner.io, inventario, binstack...
01:45 PM aandrew: most of those have self-hosted options and are OSS
01:45 PM rue_mohr: do they allow me to do parametric searches?
01:47 PM rue_mohr: looks like partkeepr does do parametric searches...
01:48 PM rue_mohr: its got the data tho...
01:50 PM rue_mohr: yea its for inventory managment, I want an engineering search
01:51 PM rue_mohr: snipe-it...
01:52 PM rue_mohr: cloud..
01:52 PM rue_mohr: openboxes...
01:53 PM rue_mohr: interesting... these all look like they miss
01:55 PM rue_mohr: huh, same difference
01:57 PM rue_mohr: you see, I dont want to have a system where I know how many of somehting I have or what shelf its on, BECAUSE its a complete waste of my time to enter all that and keep it up to date
01:59 PM rue_mohr: binner.io rejects my browser...
02:01 PM rue_mohr: I cant find inventario
02:02 PM rue_mohr: again, asset tracking
02:02 PM rue_mohr: not a search system...
03:15 PM aandrew: I'm not sure I understand
03:15 PM aandrew: you need to have a database if you want to search
03:15 PM aandrew: which means data entry and organization
03:15 PM aandrew: then you can execute queries to your heart's content
03:16 PM rue_mohr: indeed
03:16 PM rue_mohr: I could go thru how they built each database
03:16 PM aandrew: select qty,mpn,location from transistors where voltage > 20 and gain > 50 and package not like '%sot%' order by qty desc;
03:16 PM rue_mohr: have you ever lifted the hood on an audino library?
03:16 PM aandrew: on a what library?
03:17 PM aandrew: arduino?
03:17 PM rue_mohr: arduino
03:17 PM rue_mohr: and you scream and decide to write your own?
03:17 PM aandrew: I try to never look under the hood of arduino. it's a weird mishmash
03:17 PM rue_mohr: yea
03:18 PM rue_mohr: a great example is wav player libraries
03:18 PM rue_mohr: oh 45000Hz is close enough to 44100 right?
03:18 PM aandrew: I was looking at... I think partsbox because it looked extensible
03:18 PM aandrew: I don't want to have to write or manage a db schema or gui anything, but let me write my own plugin or queries
03:19 PM rue_mohr: oh the last buffer isn't a full one, we can just drop that then
03:19 PM rue_mohr: oh look, its got a header, lets play that as audio, cause, whatever
03:19 PM aandrew: yeah some (most?) of the arduino stuff is good for proof of concept and then useful as a hopping-off point for making something more robust
03:19 PM rue_mohr: :]
03:19 PM rue_mohr: I can write this stuff pretty quick
03:19 PM rue_mohr: I use php and pear templates
03:20 PM rue_mohr: a bit of time to work out what I want the database operations to be from the user
03:21 PM rue_mohr: I know there are some engines that use their own intermediate languages, markup... to combine the serverside and generated html stuff
03:22 PM rue_mohr: damnit I have to burry outa here
03:22 PM rue_mohr: I cant get to sleep at the right time
03:24 PM rue_mohr: sdjkhasdjklhklasdjhasdklasdjklfg
03:24 PM rue_mohr: keyboard never deos what I tell it to
03:25 PM rue_mohr: so
03:25 PM rue_mohr: would you want an inventory system or a parts search system
03:29 PM aandrew: partsbox though is missing a self-hosted option as far as I can tell, and I will not use cloud anything
03:30 PM aandrew: I don't see the difference between an inventory system and a parts search system. the latter is perhaps a superset of the former
03:30 PM aandrew: and I'm sure as fuck not paying USD$600/yr for one
03:33 PM aandrew: https://github.com/berkutta/parts_manager might be nice
03:33 PM aandrew: snipe-it seems to get a lot of attention on this too
03:33 PM rue_shop3: no I'm not going to use a cloud service for anything but disposable data
03:34 PM rue_shop3: like twitter
03:34 PM rue_shop3: I think the parts search by paramiter has to be added to all of them
03:34 PM rue_shop3: it looks like you can pull up parts by their name, but not VCE
03:35 PM rue_shop3: Vce
03:35 PM rue_shop3: Id
03:35 PM rue_shop3: :)
03:50 PM aandrew: that seems... wrong
03:50 PM aandrew: gonna check a few
03:51 PM aandrew: well just tried the live demo for snipe-it and tried an advanced search on asssets > $1000 and it came up empty so that doesn't bode well
03:51 PM aandrew: but that was only a very quick test
03:53 PM aandrew: not very advanced for a search
06:16 PM Tom_L is now known as tom_l
06:16 PM rue_mohr: .
06:17 PM Tom_L: o
08:33 PM rue_mohr: aandrew, have postgres installed?
08:33 PM rue_mohr: I dont use mysql
09:09 PM aandrew: rue_mohr: I do
09:09 PM aandrew: and mysql apparently
09:09 PM aandrew: and sqlite3
09:09 PM aandrew: and god knows what else
09:10 PM rue_mohr: hah, maybe twitter will collapse!...
09:10 PM rue_mohr: https://comicbook.com/gaming/news/twitter-in-danger-of-shutting-down-employees-walk-out-elon-musk/
09:10 PM aandrew: man a diamond hole saw cuts through PCBs like buttah
09:10 PM rue_mohr: this all seams completely plausable
09:10 PM aandrew: of course to get to that point I had to fix my drill press power cord first
09:16 PM Tom_L: ok bot 'works' but doesn't update the irc channel
09:16 PM Tom_L: buildbot
09:26 PM rue_mohr: aandrew, wait, its not fixed yet!?
09:26 PM rue_mohr: aandrew, tell me this,
09:26 PM rue_mohr: how many cables are in your "computer power cords" box
09:26 PM rue_mohr: 15? 20? 25? 35?
09:28 PM aandrew: rue_mohr: what's not fixed yet?
09:29 PM aandrew: I fixed the drill press power cord
09:29 PM rue_mohr: oh good!
09:29 PM aandrew: I probably have 50 power cables
09:29 PM rue_mohr: yea
09:29 PM rue_mohr: I'm to the point where they are for all intents and purposes, disposable cord ends
09:29 PM rue_mohr: tho I go to the bucket or cord ends first
09:30 PM rue_mohr: so, I wonder if twitter will live
09:30 PM rue_mohr: I dont see how it could
09:30 PM rue_mohr: he elon just get taken by the twitter investors for 44M?
09:32 PM rue_mohr: a court said he had to buy it?
09:48 PM aandrew: well he said he'd buy it, they agreed, he started waffling because he didn't really want to buy it, SEC said fuck you, pay up
09:49 PM aandrew: dude brought all this shit on himself because he believes his own press
09:49 PM rue_mohr: yea
09:49 PM rue_mohr: I see it
09:49 PM rue_mohr: you know he wanted to do this type of staff re-arrangement in tesla and they stopped him?
09:51 PM aandrew: nah I didn't pay that much attention
09:51 PM aandrew: as a contractor I'd happily take a contract at twitter under Musk, but you'd be sure the terms would be prepayment
09:51 PM Tom_L: bitcoin?
09:51 PM rue_mohr: well, I'm sure twitter is almost as much of a technical mess as it is a administrative one
09:52 PM rue_mohr: I suspect almost all social media sites are