10:09:05 <sugi> hi shrini
10:09:45 <sugi> i am going to my son's school, so can't come online today
13:13:54 <shrini> i will come here after cooking
13:14:00 <shrini> need some 20-25 min
13:32:45 <sethu_payilagam> ok Shrini.
14:04:05 <shrini> hello all
14:04:07 <shrini> I am back
14:04:14 <shrini> thanks for your patience
14:04:51 <shrini> sethu_payilagam: please share your updates
14:06:23 <sethu_payilagam> I have completed the billing application using the items and price from csv. Yesterday I have completed the same without csv option, Shrini
14:06:34 <shrini> ok
14:06:40 <sethu_payilagam> https://reachmesethu.wordpress.com/2024/10/21/my-python-learning/
14:07:05 <shrini> please
14:07:15 <shrini> provide the new updates on new posts
14:07:32 <shrini> so that individual tasks can be as seperate posts
14:07:48 <shrini> are you writing the code yourself or do you use chatgpt ?
14:07:54 <sethu_payilagam> ok Shrini. I will create a separate post for each task
14:08:24 <sethu_payilagam> No Shrini. I am not using chatgpt. You can trust me :)
14:08:29 <shrini> :-)
14:08:34 <shrini> okey
14:09:35 <sethu_payilagam> Should I change the tasks into individual post now or can i change it later?
14:09:49 <shrini> you can change later today
14:09:58 <shrini> may be after this meet
14:10:21 <sethu_payilagam> Sure
14:10:22 <shrini> hope you know about the postgreSQL and know about tables
14:11:00 <sethu_payilagam> Yes Shrini. I was working as a SQL server DBA in the past for about 10+ years
14:11:12 <shrini> oh super then
14:11:34 <shrini> then make the same application with DB backend
14:12:05 <shrini> then export the bill as PDF
14:12:12 <shrini> have some header/footer
14:12:27 <shrini> show the total amount in number and text
14:12:44 <shrini> 3495 = three thousand four hundred and ninty five
14:12:59 <sethu_payilagam> Got it Shrini. I will try do that
14:14:06 <shrini> can you take any classes on the intro to database, using postgresql?
14:14:13 <shrini> in tamil or english?
14:14:18 <shrini> many people are asking for classes
14:14:45 <shrini> at kaniyam, we have done free online classes for devops, linux, python, git, ML etc
14:14:56 <sethu_payilagam> I have never did any sessions but I can give it a try Shrini. But need your guidance for sure
14:14:58 <shrini> people are asking for db classes
14:15:02 <shrini> sure
14:15:22 <shrini> may be start with giving talks at weekly kanchilug meet
14:15:41 <shrini> which happens every sunday evening 5-8
14:15:46 <sethu_payilagam> i am fine with either options Shrini. English or Tamil is fine. You can let me know
14:16:45 <shrini> tamil is fine
14:16:56 <shrini> are you there in kanchilug mailing list?
14:17:03 <sethu_payilagam> I will try to join this week meeting Shrini
14:17:11 <shrini> https://www.freelists.org/list/kanchilug
14:17:23 <shrini> https://www.freelists.org/list/ilugc
14:17:29 <sethu_payilagam> No I am not in the mailing list. I will enroll now
14:17:30 <shrini> join both the mailing lists
14:17:43 <shrini> once subscribed, you will get an email confirmation
14:17:47 <shrini> click the link there
14:17:53 <shrini> to confirm the subscription
14:18:07 <shrini> then, you can send email to kanchilug⊙fo
14:18:13 <shrini> which will send to all the members
14:18:28 <shrini> you can share your willingness to give talk about postgresql
14:20:10 <shrini> are you there in TamilLinuxCommunity telegram channel ?
14:21:35 <shrini> hariharan: amotbeli is there any update from you?
14:23:13 <amotbeli> shrini: i did the web scrapping project we talked about in the morning
14:23:32 <shrini> great
14:23:36 <shrini> share any link here
14:24:11 <amotbeli> https://github.com/amotbeli/tamilvu_data
14:26:27 <shrini> wonderful
14:26:47 <amotbeli> thanks shrini :)
14:27:05 <shrini> adding the download links will complete this
14:27:21 <amotbeli> will do
14:27:35 <shrini> I am imagining a big project out of this code
14:27:58 <amotbeli> i have been meaning to ask you this. what are you planning with all these data?
14:28:20 <amotbeli> oh this code?
14:28:28 <shrini> These Tamil Univ books are public domain
14:28:45 <shrini> we should download these PDF and upload to wikimedia commons
14:29:03 <shrini> so that wikisource contributors can do OCR, proofread at wikisource
14:29:47 <amotbeli> great
14:30:07 <shrini> https://www.tamildigitallibrary.in/ has more than 30k books
14:30:20 <shrini> we have to download all upload to archive.org too
14:30:46 <shrini> we have few thousands books synced to archive.org few years back manually
14:31:08 <shrini> but with this automation, we can keep both the sites in sync easily
14:31:28 <amotbeli> oh okay
14:33:00 <shrini> huge dream
14:33:02 <shrini> :-)
14:33:28 <shrini> but if done, will be a great service for the tamil book's global visiblity
14:34:25 <sethu_payilagam> Done with subscribing to the mailing list and sent the mail to the KanchiLUG, Shrini
14:34:27 <amotbeli> yeah it will be great
14:34:44 <kaartic> +1
14:35:26 <shrini> thanks for the mail sethu_payilagam
14:35:29 <kaartic> it's good to hear about projects that help increase the amount of tamil resources available in commons and internet archive :-)
14:36:18 <sethu_payilagam> np Shrini. Please let me know how to connect with you to get some idea about the content to be presented so that I will work on that
14:36:41 <sethu_payilagam> whenever you get time.
14:37:01 <amotbeli> wishing you all the success, shrini
14:37:39 <amotbeli> is the archive.org back?
14:38:50 <shrini> yes 
14:38:56 <shrini> for now in readonly mode
14:38:57 <shrini> https://blog.archive.org/2024/10/21/internet-archive-services-update-2024-10-21/
14:39:16 <shrini> https://twitter.com/textfiles/status/1849281904258043990
14:39:19 <shrini> see the servers her
14:39:21 <shrini> ee
14:39:34 <amotbeli> oh okay! glad to have it back.
14:41:41 <shrini> for freeTamilebooks.com, we store all the ebooks at archive.org only
14:42:06 <shrini> as per good sysadmin practise, we should keep 3 backups always
14:42:18 <shrini> with 1 offline backup
14:42:28 <shrini> currently, we have all the books in archive.org only
14:42:56 <shrini> will download them all and host in my selfhosted desktop too
14:43:19 <shrini> sethu_payilagam: you can start the training with simple intro to postgresql
14:43:47 <shrini> history, diff between mariadb/oracle/sql server etc
14:44:06 <amotbeli> yeah i went to freetamilbooks.com sometime back and a red banner announced the archive.org outage
14:44:19 <sethu_payilagam> Ok Shrini. 
14:45:37 <shrini> then installing postgresql
14:45:43 <shrini> then, intro to SQL
14:45:53 <shrini> users/databases/tables/columns/rows
14:46:16 <kaartic> is there a reason the free tamil ebooks are not available via Wikimedia commons, Shrini? is there a licensing constraint of sorts?
14:46:17 <sethu_payilagam> ok Shrini
14:48:28 <shrini> these are enough for first class
14:48:59 <shrini> then on second class, explore about joins, pg conf files, backup/restore/stored proc etc
14:49:29 <shrini> kaartic: yes, many ebooks are with non-commercial tag
14:49:36 <shrini> so, we can not push them all to commons
14:49:38 <sethu_payilagam> Ok Shrini. I am more into SQL Server but i will try to quickly go through pg and will prepare for the session
14:49:53 <shrini> should be simple
14:50:20 <shrini> https://www.w3schools.com/postgresql/postgresql_intro.php
14:50:31 <shrini> explore this link 
14:51:04 <sethu_payilagam> ok sure
14:52:37 <shrini> https://www.slideshare.net
14:52:43 <shrini> search here for the postgresql
14:52:51 <shrini> you will get tons of slides
14:53:02 <shrini> you can use them as base or as it is 
14:53:26 <shrini> tell about indexing/vaccum also
14:53:48 <shrini> you can split the sessions as multiple 
14:54:15 <shrini> 20 min session + 10 min QA is enough for each week talk
14:54:27 <shrini> you can span across 4-6 weeks
14:54:49 <shrini> so that you will have time to prepare
14:55:01 <shrini> amotbeli: can you give some talk on web scrapping?
14:55:07 <shrini> in kanchilug meet?
14:55:17 <shrini> or chennaipy meet? if you are in chennai
14:55:38 <amotbeli> i'm a remote village in tiruppur district :)
14:56:06 <shrini> ok. good to know that
14:56:19 <amotbeli> i'll try to give an online talk if it will be useful
14:56:22 <shrini> then try to join kanchilug meets and give talk
14:56:56 <shrini> just an intro about webscrapping and its libraries like bs, lxml, requests etc
14:57:04 <amotbeli> sure, i'll have more time on my hands from next week
14:57:20 <shrini> thanks
14:57:30 <shrini> hope you are there in kanchilug mailing list
14:58:42 <amotbeli> i'm not there yet, but i'll join
14:59:08 <shrini> https://www.freelists.org/list/ilugc
14:59:15 <shrini> https://www.freelists.org/list/kanchilug
14:59:23 <shrini> join both the mailing lists
15:00:28 <amotbeli> thanks shrini, will do
15:06:14 <shrini> https://plaintextproject.online
15:06:21 <shrini> explore the articles here
15:06:27 <shrini> on your free time
15:07:10 <shrini> thanks for the nice discussions
15:08:01 <shrini> sethu_payilagam: ask all your other friends/teammates who learn python with you to join these IRC meetings
15:08:20 <shrini> it will be good to have more people and discuss about their projects
15:11:19 <amotbeli> just joined the mailing lists, thanks shrini
15:13:26 <shrini> thanks
15:13:42 <shrini> I am going for a meeting
15:13:49 <shrini> see you all tomorrow