Planet Ingres

 The developers at Modal have created the GPU Glossary to help themselves and others get to grips with terminology related to NVIDIA GPU hardware and software. They have managed to collect, clean, normalize and present the dispersed information on the subject.

https://www.i-programmer.info/news/91-hardware/17763-demystifying-gpu-terminology.html

 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