06:34 <aw-> abu[m]: here?

06:35 <abu[m]> Hi aw-! Yes :)

06:36 <aw-> hi

06:36 <aw-> i'm having an issue with reading a UART (/dev/ttyAMA0)

06:36 <aw-> from picolisp,

06:37 <aw-> i have something like (out "/dev/ttyAMA0" (prin "command")) and then (in "/dev/ttyAMA0" (line T))

06:38 <aw-> the problem is it seems the data returned in (line T) gets sent back out to /dev/ttyAMA0

06:39 <abu[m]> Looks like an echo

06:39 <aw-> agh

06:39 <aw-> yes i just figured it out

06:39 <aw-> echo

06:40 <aw-> stty -echo ...

06:40 <aw-> that solved it

06:40 <aw-> ok thanks! sorry

06:40 <abu[m]> ☺

07:02 <Hunar> Hello, I apologize, I became busy and instead of saying that I'm busy, I waited for a time to work on it then reply, and it never came :(

07:02 <abu[m]> No problem at all!

07:03 <abu[m]> Perhaps even good, because meanwhile I released PilBox for another reason

07:03 <abu[m]> (there were problems with Android 12)

07:04 <Hunar> Great, I'll try it as soon as possible :)

07:05 <abu[m]> I believe it is better now. Now the multiple updates of the canvas you observed should be gone.

07:07 <Hunar> Yay, it's great now in PilBox .. I'll later check out the multiple update issue on PC

07:14 <beneroth> hey Hunar :)

07:14 <beneroth> abu[m], how many walks did you need?

07:15 <abu[m]> haha, well, in this case I had to do it statically (no walking) due to intensive interactions

07:15 <abu[m]> beer always helps indeed

07:16 <beneroth> hehe, I see. other factors making it harder.

07:16 <beneroth> maybe you should use beer license on some stuff for a while, so you get more beer :)

07:17 <beneroth> (it's kinda MIT + please buy the dev a beer when you meet them)

07:17 <abu[m]> good idea

07:18 <beneroth> https://en.wikipedia.org/wiki/Beerware

07:19 <abu[m]> Nice ☺

07:21 <Hunar> Hello beneroth :D

07:30 <aw-> hey beneroth ;)

07:35 <beneroth> hey aw- :)

08:15 <tankf33der> abu[m]: cool enum tweets.

08:16 <abu[m]> Thanks!

09:58 <Hunar> The update is perfect :D any event causes a single call to drawCanvas and never repeated again, each frame I only get one update :D

09:59 <abu[m]> Glad to hear that. Thanks for pointing out the problem and for testing!

10:01 <Hunar> No problem :) I'l happy thay I helped improving PIL

10:01 <Hunar> that*

10:01 <abu[m]> As T is passed for plain refresh events, you can now also ignore them completely. I tested with this: http://ix.io/49Wc

10:03 <Hunar> Great :D

10:09 <Hunar> Small unrelated question

10:09 <Hunar> I have a database that is created by another program .. its extention is .accdb microsoft access database i think.. I used pypyobdc to interact with in in python. while using racket language there was a function (obdc-driver-connect ...) function .. I searched for obdc libraries in C and didn't get good results, are you familiar with other methods that I can use to interact with it in PIL?

10:11 <abu[m]> Not really. Is access in some way compatible with the old DBase format? I still have a lib for that iirc.

10:12 <Hunar> I'm not experienced with any database :) I don't know

10:13 <abu[m]> Me neither

10:13 <abu[m]> The old lib/dbase.l was: http://ix.io/49Wj (just in case)

10:15 <abu[m]> We used it to import customer data

10:15 <Hunar> I found a tool that says converts accdb to dbf

10:15 <abu[m]> Sounds good

10:29 <Hunar> : (dbase "a.dbf")

10:29 <Hunar> /home/hunar/pil21/bin/utf2: Can't exec

10:29 <Hunar> Missing EOF

10:30 <Hunar> what, the parameter is File, I thought its filename

10:30 <abu[m]> Yeah, utf2 is not needed any more. Nowadays we have iconv or recode

10:30 <Hunar> I encoded the dbf file as utf-8

10:31 <abu[m]> Good, so no conversion needed

10:31 <abu[m]> Otherwise something like (in (list "/usr/bin/iconv" "-f" "ISO-8859-15" "-t" "UTF-8" File)

10:31 <abu[m]> Just for the records ;)

10:36 <Hunar> I changed the function and wrote that code .. now it only says

10:36 <Hunar> Missing EOF

10:36 <Hunar> where is it refering to?

10:43 <abu[m]> It seems to expect a Ctrl-Z at the end of the file

10:43 <abu[m]> Ctrl-Z was EOF on MS-DOS

10:43 <abu[m]> I think you can omit the check

10:44 <abu[m]> or do (unless (eof) as a sanity check

10:44 <abu[m]> or better (when (char)

10:45 <abu[m]> cause (char) gives NIL on EOF

10:45 <abu[m]> Then we know that 'Cnt' was correct

10:58 <Hunar> I used it like this

10:58 <Hunar> :pil dbase.l +

10:59 <Hunar> I'll remove the check

11:00 <Hunar> It returned a large nested list :) done

11:02 <abu[m]> Perfect! :)

11:02 <abu[m]> I thought I'd never need dbase.l again

11:19 <Hunar> No that that's solved, I'll come back to the project I had in mind which required live feed from camera .. I stripped down a javascript example from internet and (I think) I only kept the important code... (full message at https://libera.ems.host/_matrix/media/r0/download/libera.chat/30c13ece6596c8460fe8470578eb7c49d0d6b426)

11:20 <Hunar> My goal is to have this in PilBox somehow :)

11:21 <abu[m]> I see, that is good news

11:50 <beneroth> Hunar, accdb should be "Microsoft Access"

11:50 <beneroth> it's the database software in the MS Office bundle.

11:52 <beneroth> I think you should be able to open such files with LibreOffice, though possibly they're full of customized vba programming. Access is the tool of choice once excel gets too big.. so small businesses sometimes have some stuff running in excel/access and the guy who did it is retired for 20 years or so...

11:53 <beneroth> nice you found a solution via dbase xD

12:00 <Hunar> Thanks for the info :) the solution wasn't good, first I have to decrypt the file using the password, then pass it to the converter which turns each table into a seperate .dbf file .. but using OBDC I could open the .accdb file directly by providing a password, when i was using python

13:18 <beneroth> i would have tried to open it in LibreOffice and export the data as CSV (or maybe even dbase, dunno what LibreOffice supports)

13:18 <beneroth> you could also use your existing python code to output (into a pipe or console) and call that from pil

13:19 <beneroth> (probably easier than using odbc in pil. I'm not aware of anyone having done that yet, it's certainly possible but will need some initial effort to wrap/program a client)

13:20 <beneroth> multiple people used pil as client for mysql/mariadb, I have made a wrapper to connect to MSSQL (but not published yet)