PostgreSQL is one of the most powerful, stable, and open-source relational database systems trusted by global giants like Apple, Instagram, and Spotify. Whether youโre building a web application, managing enterprise data, or diving into analytics, understanding PostgreSQL is a skill that sets you apart.
But what if you could master it in just 10 days, in Tamil, with hands-on learning and a guaranteed 5โ rating on HackerRank as your goal?
Sounds exciting? Letโs dive in.
Why This Bootcamp?
This 10-day PostgreSQL Bootcamp in Tamil is designed to take you from absolute beginner to confident practitioner, with a curriculum built around real-world use cases, performance optimization, and daily challenge-driven learning.
Whether youโre a
Student trying to get into backend development
Developer wanting to upskill and crack interviews
Data analyst exploring SQL performance
Tech enthusiast curious about databases
โฆthis bootcamp gives you the structured path you need.
What Youโll Learn
Over 10 days, weโll cover
PostgreSQL installation & setup
PostgreSQL architecture and internals
Writing efficient SQL queries with proper formatting
Joins, CTEs, subqueries, and advanced querying
Indexing, query plans, and performance tuning
Transactions, isolation levels, and locking mechanisms
Schema design for real-world applications
Debugging techniques, tips, and best practices
Daily HackerRank challenges to track your progress
Imagine youโve been using a powerful tool for years to help you build apps faster. Yeah its Redis, a super fast database that helps apps remember things temporarily, like logins or shopping cart items. It was free, open, and loved by developers.
But one day, the team behind Redis changed the rules. They said
โYou can still use Redis, but if youโre a big cloud company (like Amazon or Google) offering it to others as a service, you need to play by our special rules or pay us.โ
This change upset many in the tech world. Why?
Because open-source means freedom you can use it, improve it, and even share it with others. Redisโs new license in 2024 took away some of that freedom. It wasnโt completely closed, but it wasnโt truly open either. It hurts AWS, Microsoft more.
What Happened Next?
Developers and tech companies didnโt like the new rules. So they said,
โFine, weโll make our own open version of Redis.โ
Thatโs how a new project called Valkey was born, a fork (copy) of Redis that stayed truly open-source.
Fast forward to May 2025 โ Redis listened. They said
โWeโre bringing back the open-source spirit. Redis version 8.0 will be under a proper open-source license again: AGPLv3.โ
Whatโs AGPLv3?
Itโs a type of license that says:
You can use, change, and share Redis freely.
If you run a modified Redis on a website or cloud service, you must also share your changes with the world. (still hurts AWS and Azure)
This keeps things fair: no more companies secretly benefiting from Redis without giving back.
What Did Redis Say?
Rowan Trollope, Redisโs CEO, explained why they had changed the license in the first place:
โBig cloud companies were making money off Redis but not helping us or the open-source community.โ
But now, by switching to AGPLv3, Redis is balancing two things:
Protecting their work from being misused
And staying truly open-source
Why This Is Good News
Developers can continue using Redis freely.
The community can contribute and improve Redis.
Fair rules apply to everyone, even giant tech companies.
Redis has come full circle. After a detour into more restricted territory, itโs back where it belongs in the hands of everyone. This shows the power of the developer community, and why open-source isnโt just about code, itโs about collaboration, fairness, and freedom.
Are you tired of slow, clunky GUI-based file managers? Do you want lightning-fast navigation and total control over your filesโright from your terminal? Meet Superfile, the ultimate tool for power users who love efficiency and speed.
In this blog, weโll take you on a deep dive into Superfileโs features, commands, and shortcuts, transforming you into a file management ninja!
Why Choose Superfile?
Superfile isnโt just another file manager itโs a game-changer.
Hereโs why
Blazing Fast โ No unnecessary UI lag, just pure efficiency.
Keyboard-Driven โ Forget the mouse, master navigation with powerful keybindings.
Multi-Panel Support โ Work with multiple directories simultaneously.
Smart Search & Sorting โ Instantly locate and organize files.
Built-in File Preview & Metadata Display โ See what you need without opening files.
Highly Customizable โ Tailor it to fit your workflow perfectly.
Installation
Getting started is easy! Install Superfile using
# For Linux (Debian-based)
wget -qO- https://superfile.netlify.app/install.sh | bash
# For macOS (via Homebrew)
brew install superfile
# For Windows (via Scoop)
scoop install superfile
Once installed, launch it with
spf
Boom! Youโre ready to roll.
Essential Commands & Shortcuts
General Operations
Launch Superfile: spf
Exit: Press q or Esc
Help Menu: ?
Toggle Footer Panel: F
File & Folder Navigation
New File Panel: n
Close File Panel: w
Toggle File Preview: f
Next Panel: Tab or Shift + l
Sidebar Panel: s
File & Folder Management
Create File/Folder: Ctrl + n
Rename: Ctrl + r
Copy: Ctrl + c
Cut: Ctrl + x
Paste: Ctrl + v
Delete: Ctrl + d
Copy Path: Ctrl + p
Search & Selection
Search: /
Select Files: v
Select All: Shift + a
Compression & Extraction
Extract Zip: Ctrl + e
Compress to Zip: Ctrl + a
Advanced Power Moves
Open Terminal Here: Shift + t
Open in Editor: e
Toggle Hidden Files: .
Pro Tip: Use Shift + p to pin frequently accessed folders for even quicker access!
Customizing Superfile
Want to make Superfile truly yours? Customize it easily by editing the config file
Superfile is the Swiss Army knife of terminal-based file managers. Whether youโre a developer, system admin, or just someone who loves a fast, efficient workflow, Superfile will revolutionize the way you manage files.
Ready to supercharge your productivity? Install Superfile today and take control like never before!
Hey everyone! Today, we had an exciting Linux installation session at our college. We expected many to do a full Linux installation, but instead, we set up dual boot on 10+ machines!
Topics Covered: Syed Jafer โ FOSS, GLUGs, and open-source communities Salman โ Why FOSS matters & Linux Commands Dhanasekar โ Linux and DevOps Guhan โ GNU and free software
Challenges We Faced
BitLocker Encryption โ Had to disable BitLocker on some laptops BIOS/UEFI Problems โ Secure Boot, boot order changes needed GRUB Issues โ Windows not showing up, required boot-repair
Performance testing is a crucial part of ensuring the stability and scalability of web applications. k6 is a modern, open-source load testing tool that allows developers and testers to script and execute performance tests efficiently. In this blog, weโll explore the basics of k6 and write a simple test script to get started.
What is k6?
k6 is a load testing tool designed for developers. It is written in Go but uses JavaScript for scripting tests. Key features include,
High performance with minimal resource consumption
JavaScript-based scripting
CLI-based execution with detailed reporting
Integration with monitoring tools like Grafana and Prometheus
A k6 test is written in JavaScript. Hereโs a simple script to test an API endpoint,
import http from 'k6/http';
import { check, sleep } from 'k6';
export let options = {
vus: 10, // Number of virtual users
duration: '10s', // Test duration
};
export default function () {
let res = http.get('https://api.restful-api.dev/objects');
check(res, {
'is status 200': (r) => r.status === 200,
});
sleep(1); // Simulate user wait time
}
Running the Test
Save the script as script.js and execute the test using the following command,
k6 run script.js
Understanding the Output
After running the test, k6 will provide a summary including
1. HTTP requests: Total number of requests made during the test.
2. Response time metrics:
min: The shortest response time recorded.
max: The longest response time recorded.
avg: The average response time of all requests.
p(90), p(95), p(99): Percentile values indicating response time distribution.
3. Checks: Number of checks passed or failed, such as status code validation.
4. Virtual users (VUs):
vus_max: The maximum number of virtual users active at any time.
vus: The current number of active virtual users.
5. Request Rate (RPS โ Requests Per Second): The number of requests handled per second.
6. Failures: Number of errors or failed requests due to timeouts or HTTP status codes other than expected.
Next Steps
Once youโve successfully run your first k6 test, you can explore,
Load testing different APIs and endpoints
Running distributed tests
Exporting results to Grafana
Integrating k6 with CI/CD pipelines
k6 is a powerful tool that helps developers and QA engineers ensure their applications perform under load. Stay tuned for more in-depth tutorials on advanced k6 features!
Ensuring your applications perform well under high traffic is crucial. Join us for an interactive K6 Bootcamp, where weโll explore performance testing, load testing strategies, and real-world use cases to help you build scalable and resilient systems.
What is K6 and Why Should You Learn It?
Modern applications must handle thousands (or millions!) of users without breaking. K6 is an open-source, developer-friendly performance testing tool that helps you
Simulate real-world traffic and identify performance bottlenecks. Write tests in JavaScript โ no need for complex tools! Run efficient load tests on APIs, microservices, and web applications. Integrate with CI/CD pipelines to automate performance testing. Gain deep insights with real-time performance metrics.
By mastering K6, youโll gain the skills to predict failures before they happen, optimize performance, and build systems that scale with confidence!
Bootcamp Details
Date: Feb 23 2024 โ Sunday Time: 10:30 AM Mode: Online (Link Will be shared in Email after RSVP) Language:เฎคเฎฎเฎฟเฎดเฏ
Who Should Attend?
Developers โ Ensure APIs and services perform well under load.
QA Engineers โ Validate system reliability before production.
SREs / DevOps Engineers โ Continuously test performance in CI/CD pipelines.
RSVP Now
Donโt miss this opportunity to master load testing with K6 and take your performance engineering skills to the next level!
Got questions? Drop them in the comments or reach out to me. See you at the bootcamp!
1. Ansh Arora, Gave a tour on FOSS United, How its formed, Motto, FOSS Hack, FOSS Clubs.
2. Karthikeyan A K, Gave a talk on his open source product injee (The no configuration instant database for frontend developers.). Itโs a great tool. He gave a personal demo for me. Itโs a great tool with lot of potentials. Would like to contribute !.
What is plaintext in my point of view: Its simply text without any makeup or add-on, it is just an organic content. For example,
A handwritten grocery list what our mother used to give to our father
A To-Do List
An essay/composition writing in our school days
Why plaintext is important? โ The quality of the content only going to get score here: there is no marketing by giving some beautification or formats. โ Less storage โ Ideal for long term data storage because Cross-Platform Compatibility โ Universal Accessibility. Many s/w using plain text for configuration files (.ini, .conf, .json) โ Data interchange (.csv โ interchange data into databases or spreadsheet application) โ Command line environments, even in cryptography. โ Batch Processing: Many batch processes use plain text files to define lists of actions or tasks that need to be executed in a batch mode, such as renaming files, converting data formats, or running programs.
So plain text is simple, powerful and something special we have no doubt about it.
What is IRC? IRC โ Internet Relay Chat is a plain text based real time communication System over the internet for one-on-one chat, group chat, online community โ making it ideal for discussion.
Itโs a popular network for free and open-source software (FOSS) projects and developers in olden days. Ex. many large projects (like Debian, Arch Linux, GNOME, and Python) discussion used. Nowadays also IRC is using by many communities.
Usage : Mainly a discussion chat forum for open-source software developers, technology, and hobbyist communities.
Why IRC? Already we have so many chat platforms which are very advanced and I could use multimedia also there: but this is very basic, right? So Why should I go for this?
Yes it is very basic, but the infrastructure of this IRC is not like other chat platforms. In my point of view the important differences are Privacy and No Ads.
Advantages over other Chat Platforms:
No Ads Or Popups: We are not distracted from other ads or popups because my information is not shared with any companies for tracking or targeted marketing.
Privacy: Many IRC networks do not require your email, mobile number or even registration. You can simply type your name or nick name, select a server and start chatting instantly. Chat Logs also be stored if required.
Open Source and Free: Server, Client โ the entire networking model is free and open source. Anybody can install the IRC servers/clients and connect with the network.
Decentralized : As servers are decentralized, it could able to work even one server has some issues and it is down. Users can connect to different servers within the same network which is improving reliability and performance.
Low Latency: Its a free real time communication system with low latency which is very important for technical communities and time sensitive conversations.
Customization and Extensibility: Custom scripts can be written to enhance functionality and IRC supports automation through bots which can record chats, sending notification or moderating channels, etc.
Channel Control: Channel Operators (Group Admin) have fine control over the users like who can join, who can be kicked off.
Light Weight Tool: As its light weight no high end hardware required. IRC can be accessed from even older computers or even low powered devices like Rasberry Pi.
History and Logging: Some IRC Servers allow logging of chats through bots or in local storage.
Inventor IRC is developed by Jarkko Oikarinen (Finland) in 1988.
Some IRC networks/Servers: Libera.Chat(#ubuntu, #debian, #python, #opensource) EFNet-Eris Free Network (#linux, #python, #hackers) IRCnet(#linux, #chat, #help) Undernet(#help, #anime, #music) QuakeNet (#quake, #gamers, #techsupport) DALnet- for both casual users and larger communities (#tech, #gaming, #music)
Directly on the Website โ Libera WebClient โ https://web.libera.chat/gamja/ You can click Join, then type the channel name (Group) (Ex. #kaniyam)
How to get Connected with IRC: After installed the IRC client, open. Add a new network (e.g., โLibera.Chatโ). Set the server to irc.libera.chat (or any of the alternate servers above). Optionally, you can specify a port (default is 6667 for non-SSL, 6697 for SSL). Join a channel like #ubuntu, #python, or #freenode-migrants once youโre connected.
Popular channels to join on libera chat: #ubuntu, #debian, #python, #opensource, #kaniyam
Local Logs: Logs are typically saved in plain text and can be stored locally, allowing you to review past conversations. How to get local logsfrom our System (IRC libera.chat Server) folders โ /home//.local/share/weechat/logs/ From Web-IRCBot History: https://ircbot.comm-central.org:8080
Login
Why This Bootcamp?