PERL,INGRES,PROGRAMMING

  database.build lets you run Postgres inside your browser local-first and ask questions on your data in natural language. If it wasn't already great enough to have a Postgres instance running inside your browser, then add to it spawning any number of instances and use LLMs to query your data. https://www.i-programmer.info/news/84-database/17737-databasebuild-in-browser-postgres-sandbox-with-ai-assistance.html

  We recap the main events that happened throughout 2024 in the Perl world as explored by IProgrammer. And let's begin with the announcement of v5.40.0 out on June 9th https://www.i-programmer.info/news/222-perl/17739-the-iprogrammer-perl-2024-review.html

  Introducing a web collection of programming idioms in a variety of languages. How useful is that? Programming Idioms collects useful code snippets for day to day usage at work. The same snippet is presented in more than 20 languages so that you can make useful comparisons when working in multiple languages or want to learn a new one by observing how the constructs are mapped between the languages. https://www.i-programmer.info/news/98-languages/17730-explore-programming-idioms.html

  Run DuckDB inside your browser thanks to Webassembly. When is that useful? Running a database instance inside a browser is nothing new. I've already explored the idea in  Running PostgreSQL Inside Your Browser With PGLite   where I explained: PGlite is a WASM Postgres build packaged into a TypeScript client library that enableyou to run Postgres in the browser with no need to install any other dependencies. https://www.i-programmer.info/news/84-database/17726-duckdb-webassembly-whattheduck.html

  By fusing PostgreSQL native row-level security  with external to the database authentication providers, Neon Authorize offers a new, efficient and transparent way for securing access for database-driven applications. https://www.i-programmer.info/news/84-database/17720-simplify-postgresql-database-access-with-neon-authorize.html

  aka Dan Kornas who runs a very successful X account about everything related to engineering ML applications. And what is he using in his tutorials? Python, of course. https://www.i-programmer.info/news/216-python/17705-learn-python-with-dan-the-machine-learning-engineer.html

  Cloudberry is the open source equivalent of Greenplum. Now it is fostered by the Apache Foundation as it acquires incubating status. It all began about six months ago. Greenplum's Github repositories was archived and went dark. This meant no more free new releases or security and bug fixes for its users. Why? Because in May 2024, Tanzu made the decision to close-source the project. https://www.i-programmer.info/news/84-database/17694-greenplums-cloudberry-fork-enters-apache-incubator-.html

  It's Advent - the time of year when we countdown the days to Christmas - and if your are a programmer complete daily coding challenges with the Advent of Code, the Advent of Perl, the Advent of Java, Javascriptmas, etc. Now we have the Advent of SQL too with 24 SQL challenges to complete before Christmas! https://www.i-programmer.info/news/204-challenges/17678-the-advent-of-sql-2024-has-commenced.html

  A veritable treasure trove of assorted how-to recipes for PostgreSQL, stored as a Github repository, has been inauguarated by Nikolay Samokhvalov, a well known figure in the PostgreSQL world, While PostgreSQL docs are awesome, they often lack practical pieces of advice, a situation that these how-tos try to remedy. https://www.i-programmer.info/news/84-database/17685-the-postgresql-howtos-trove.html

  The "RAG from Scratch" tutorial by Langchain coupled with the "RAG playground" are two great educational resources that will help you kickstart your journey with RAG. https://www.i-programmer.info/news/105-artificial-intelligence/17676-rag-from-scratch.html