Chapi Dev Talks @chapidevtalks Channel on Telegram

Chapi Dev Talks

@chapidevtalks

My name is Chapi and am a developer.

I talk post my thoughts about tech here.

Message to our assistant to give us Feedback: @sophiservebot

Join https://t.me/chapidevtalks_group

For Urgent Contact Me: @chapimenge (don't say hi or ask a meta question)

Chapi Dev Talks (English)

Are you passionate about technology and development? Look no further than 'Chapi Dev Talks'! This Telegram channel, managed by the developer Chapi, is a hub for all things tech-related. Chapi shares his thoughts, insights, and experiences in the world of technology, providing valuable content for fellow developers, tech enthusiasts, and anyone interested in the field. Whether you're looking for the latest trends, coding tips, or just want to engage in stimulating tech discussions, 'Chapi Dev Talks' is the place to be

Chapi, with his expertise and passion for technology, offers a unique perspective that sets this channel apart. From software development to emerging technologies, Chapi covers a wide range of topics, making his content informative, engaging, and relevant. Whether you're a seasoned developer or just starting out, you'll find something valuable in 'Chapi Dev Talks'

To join the conversation and connect with like-minded individuals, simply click the link provided in the channel description or visit https://t.me/chapidevtalks_group. Additionally, for any urgent inquiries or direct contact with Chapi, you can reach out to him directly at @chapimenge. Remember, for feedback or assistance, you can always message the channel's assistant, @sophiservebot

Don't miss out on the opportunity to expand your knowledge, engage with the tech community, and stay up-to-date with the latest developments in the world of technology. Join 'Chapi Dev Talks' today and be part of a vibrant and dynamic tech community!

Chapi Dev Talks

20 Nov, 04:03

Show HN: Embed an SQLite database in your PostgreSQL table (Score: 150+ in 11 hours)

Link: https://readhacker.news/s/6icWC
Comments: https://readhacker.news/c/6icWC

pglite-fusion is a PostgreSQL extension that allows you to embed SQLite databases into your PostgreSQL tables by enabling the creation of columns with the `SQLITE` type. This means every row in the table can have an embedded SQLite database.
In addition to the PostgreSQL `SQLITE` type, pglite-fusion provides the `query_sqlite`` function for querying SQLite databases and the `execute_sqlite` function for updating them. Additional functions are listed in the project’s README.
The pglite-fusion extension is written in Rust using the pgrx framework [1].
----
Implementation Details
The PostgreSQL `SQLITE` type is stored as a CBOR-encoded `Vec<u8>`. When a query is made, this `Vec<u8>` is written to a random file in the `/tmp` directory. SQLite then loads the file, performs the query, and returns the result as a table containing a single row with an array of JSON-encoded values.
The `execute_sqlite` function follows a similar process. However, instead of returning query results, it returns the contents of the SQLite file (stored in `/tmp`) as a new `SQLITE` instance.
[1] https://github.com/pgcentralfoundation/pgrx
416
Chapi Dev Talks

19 Nov, 12:11

Based on @frectonz recommendation to change it to sqlite it might get me a huge performance on processing part of the big csv, since file size doesn't matter for us but the speed is a huge gain for us.

plus there were a lot of duplication in the csv rows and we didn't notice that until today.

after a bit of experiment even tho the sqlite file size increased i think the query time is much faster than the normal looping so i think i am changing the approach a bit.

So the idea is to merge and process 4 csv file so i am going to change 3 csv to sqlite and looping through one csv and getting the file from other 3 might be the best approach i have at the moment.

just like 

for i in big_csv:
    result_1 = cursor.execute(f"SELECT * FROM table WHERE id = {i}")
    result_2 = cursor.execute(f"SELECT * FROM table WHERE id = {i}")
    result_3 = cursor.execute(f"SELECT * FROM table WHERE id = {i}")
    # do something with the result


tho this doesn't help much for file downloading part but i think it's a good start for processing part.

anyways thanks @frectonz for the recommendation it super cool to have such community.
790
Chapi Dev Talks

18 Nov, 21:54

To Shade some light how big the csv files are.

🤯
904
Chapi Dev Talks

18 Nov, 21:33

This is insane 🤯
902
Chapi Dev Talks

18 Nov, 21:32

🙃 This is the biggest update in the history of Mini Apps: full-screen mode, home screen shortcuts, geolocation, motion tracking, media sharing, document creation, gift sending, subscription tiers, emoji statuses — and much more 😎

🕺 To explore some of these new features, update Telegram and check out these early examples:

Tiny Verse opens in full-screen, which looks great on desktops and tablets. Make sure to swipe and zoom to admire the 3D effects 😊

Playdeck's task section now features an "Add to Home Screen" option — and a flying Yeti that moves based on your device’s orientation 😙

Major has added a custom loading screen and the new Major Maze mini-game, where you can guide a rolling ball by tilting your phone 😎

😏 This is just the beginning — all discovered within the first day of Mini Apps 2.0's launch! 😮
650
Chapi Dev Talks

18 Nov, 13:28

Story of My Recent Days

I was working with a very large csv data, and i want to merge 4 very large csv files based on one col and pandas wasn't able to handle it so i decided to change my approach and process the files separately.

The thing is there is 2 tasks that have to be done on it

1. Process it and add to DB based on all the files [CPU Bound]
2. Download file and upload it to S3 and update the column with the S3 link [IO Bound]

So the first task is really fast since it all depends on the CPU i kinda get a good speed optimization already but the second task is taking more than one day to finish. Here is the bummer the task have to run every day 😂 and it is taking more than a day to complete the task.

But i come up with the solution to use multiple machine and separate out the task to handle the IO bound tasks like downloading and uploading file.

When i say downloading file i am talking about millions of files don't ask me why the bottom line is i have to download it and upload it to S3.

Anyways I just separate out processing of the files to multiple files and i am using asyncio to its peak and not to get blocked by the websites too.

Now it is gonna cut down to half the time to process the files and i am happy with it.

Moral of the story is if you are dealing with IO Bound Task may be try multiple machine to handle it.

I have got couple of more stories to share but too lazy to write it down 😂.
1,201
Chapi Dev Talks

17 Nov, 19:42

You can only know what makes your program slow after first getting the program to give correct results, then running it to see if the correct program is slow. When found to be slow, profiling can show what parts of the program are consuming most of the time. A comprehensive but quick-to-run test suite can then ensure that future optimizations don't change the correctness of your program. In short:

1. Get it right.
2. Test it's right.
3. Profile if slow.
4. Optimise.
5. Repeat from 2.

Source
1,333
Chapi Dev Talks

15 Nov, 16:19

Boing cuts it's 10% of workforce globally which is around 17,000 employees started to get their notice.

It's so sad the economy is still down globally 😞.

Stay strong champs.
1,736
Chapi Dev Talks

13 Nov, 18:37

All the things I said here respect my thoughts only.

Nobody else will be responsible for anything I said.

I will take all the responsibility if there is any.
2,144
Chapi Dev Talks

13 Nov, 18:03

You guessed right, it's Chapi 🥳

Temkin Mengistu aka Chapi — Remote Work, Backend Dev, Working in the Middle East, Communities and Much More
• https://www.youtube.com/watch?v=057hXT9gZuE

You can enjoy and listen to the show across all your favorite podcasting platforms. 💚

#MyYouTube #MyPodcasts
@Dagmawi_Babi
707
Chapi Dev Talks

13 Nov, 15:38

YOU CANT LEARN HOW TO BE SUCCESSFULL AT UPWORK.

you can learn what is the best way to write a proposal but after that its all your skill and your review that will take you to success.

SO guys please prove that you are worthy in your skill not attending every single workshop or asking every single freelancer you met.

So many desperate people but put the effort you are putting on these conference to upwork or any freelance platform.

Am not saying the workshop doesn't help but attending every single workshop is not the way.

hustle your way up by working bruh.
1,106
Chapi Dev Talks

13 Nov, 08:43

Any company that provide a service through application and doesn't really give the best user experience ምናችሁን ነው የሚያማቹ?

Just a simple example of a good tech experience
- push notification
- email options for multiple functionality
- flexibility of the application.


Just wondering do you really think that this is a really good business strategy. For now it will work since there might not be a good option but when they do I believe it's like a snap in the finger
1,381
Chapi Dev Talks

11 Nov, 08:13

guess who's name is one of the biggest frontend framework 😂😂😂 the irony

https://github.com/shadcn-ui/ui

https://github.com/shadcn-ui/ui/pull/5790

FYI: i call myself backend dev
1,974
Chapi Dev Talks

11 Nov, 08:04

Who else touch grasses?

I do sometimes 🤣
1,788
Chapi Dev Talks

10 Nov, 21:22

idk if it really from my side or just an issue but at the moment whenever we copy a component from the block section it doesn't copy the block name.

https://ui.shadcn.com/blocks

can somebody confirm too
1,642
Chapi Dev Talks

10 Nov, 10:16

A true patriot and tech enthusiast project Mano

https://x.com/projectmano/status/1855520620953420274?s=19


I still wish the government give it a try for this kind of project.

They don't even say let us do it they just said please do this and you will be profitable.


For more details read the above tweet.
2,142
Chapi Dev Talks

09 Nov, 18:46

Coding with Dagi latest podcast

i recommend you go watch it for yourself too

https://youtu.be/Gfly3j5qWpM?si=gidvIsOEE_Olconr
2,849
Chapi Dev Talks

08 Nov, 07:45

Jumu'ah Mubarak 🔥
1,812
Chapi Dev Talks

08 Nov, 06:43

172.232.10.125
2,256
Chapi Dev Talks

08 Nov, 06:35

The most funniest video of all time from prime


https://youtu.be/ycTOEWqjeHI
2,310
Chapi Dev Talks

07 Nov, 19:21

What a session we had with Chapi Dev—it was super cool! Kicking off Season 3.
Thanks @chapidevtalks

@Techinethio
1,676
Chapi Dev Talks

07 Nov, 18:00

Let's hit it devs to the https://t.me/TechInEthio

see you all there!
2,936
Chapi Dev Talks

07 Nov, 11:04

Ethiopia among targeted countries in growing global threat from Grandoreiro Banking Trojan

Ethiopia is among the countries now targeted by the Grandoreiro banking trojan, a significant cyber threat that has expanded its reach into Africa and Asia. According to a recent report by Kaspersky, the Grandoreiro malware has been active since 2016 and is responsible for approximately five percent of global banking trojan attacks in 2024.

Kaspersky’s Global Research and Analysis Team (GReAT) revealed that the trojan is currently targeting over 1,700 financial institutions and 276 cryptocurrency wallets across 45 countries.

Read More

Source: capitalethiopia
@Ethiopianbusinessdaily
1,491
Chapi Dev Talks

07 Nov, 09:51

it has been a while since we had a voice session.

well now is the time i think
1,511
Chapi Dev Talks

07 Nov, 09:50

Meet Temkin Mengistu (Chapi), Tomorrow’s Techኢት Podcast Guest

⭐️Chapi was super active at ASTU’s Computer Science and Engineering Club (CSEC), where he made a big impact in the community.

⭐️He’s one of the few Ethiopian developers to have joined Toptal—a highly competitive and selective platform known for its rigorous standards.

⭐️Chapi is passionate about sharing knowledge. He started teaching various topics while at ASTU, continues with a YouTube channel, and runs regular sessions on his Telegram channel, helping many stay updated and learn new skills.

⭐️He’s also known for bringing people together in Ethiopia’s dev community. He helped organize two CodNight meetups and recently held a workshop on freelancing and backend engineering.

⭐️Known as one of Ethiopia’s top-paid developers, Chapi is a role model, proving that Ethiopian developers can achieve success on a global scale.

#chapi #techetpodcast

@techinethio
1,446

2024 All Right Reserved

Disclaimer: The content displayed on this website is solely provided by the respective Telegram channels. We hold no ownership or responsibility for the content shared by these channels.