Skip to main content

Posts

Showing posts from July, 2022

In Praise Of SQLite

 SQLite, the RDBMS that never ceases to amaze, has reached version 3.39.2. While this release contains just bug fixes, it builds on major changes that debuted in 3.39.0. SQLite "never ceases to amaze", or more specifically, the imaginative uses people put it under, since while SQLite is a relational database management system like MySQL or Postgres, it does not fall under the client-server model. Instead it embeds itself inside applications that need query access to a data store. The most prevalent examples are its embedding in Android applications or web browsers such as Firefox. Despite its compact size and absence of the client server model, SQLite is a RDBMS with all the features that make something relational - that is tables, indexes, constraints, triggers, transactions and the like. However full article on i-programmer: https://www.i-programmer.info/news/84-database/15609-in-praise-of-sqlite.html

New NodeJS Database Driver for Oracle Released

 New NodeJS Database Driver for Oracle Released Version 5.4 of node-oracledb, the Node.js and TypeScript module for accessing the Oracle Database, has been released and is available from npm. The node-oracledb add-on for Node.js allows applications to be written in TypeScript, or directly in JavaScript. Version 5.4 connects Node.js 14, or later, to an Oracle Database. Last month in "New Database Drivers for Oracle and PostgreSQL Released" w looked at another recent driver release for the Oracle database, but for another language - Python. That driver had a major name change from cx_Oracle to python-oracledb to signal the change that the new driver is a thin driver and therefore makes no use of the Oracle Client libraries. As such it was aligned with the rest of the language*-oracledb naming schemes as node-oracledb does. full article on i-programmer: https://www.i-programmer.info/news/84-database/15606-new-nodejs-database-driver-for-oracle-released.html

Take The Beginner's Series to Rust

  Microsoft has released a new self-paced and free curriculum for total beginners in Rust, taught by Microsoft's own employees. But first of all why Rust? why go for Rust as a beginner when there's so much choice? Rust was Mozilla's brainchild first announced in 2010 and released in 2015. Its official definition and purpose in life was to be: “a systems programming language focused on three goals: safety, speed, and concurrency.” three concepts that no language could cover 100%. In particular, Rust was going to fill the safety gap by making all the erroneous, dangerous and unsafe operations found in the C-derived languages very hard to repeat, in essence eliminating entire classes of errors. This would result in higher-quality software, but traded for a steeper learning curve.. https://www.i-programmer.info/news/150-training-a-education/15574-take-the-beginners-series-to-rust.html

Protect The Software Supply Chain With GitSign

 Sigstore and the Linux Foundation have taken another step toward securing the software supply chain, this time focusing on the initial stage of the chain. That is, the signing of Git commits. Supply chain security is all the rage right now and the Linux Foundation's answer to it came through Sigstore: full article on i-programmer: https://www.i-programmer.info/news/149-security/15583-protect-the-software-supply-chain-with-gitsign.html

Scratch Can Even Do Linux Kernel

  Is writing a Kernel module in Scratch, the block-based programming language used primarily by kids, possible? Absurd it may be, but yes, it is absolutely possible! Scratch is the original block-based programming language and still the best known and most widely used. It was invented in 2003 at MIT to make kids' introduction to coding a much smoother experience. That said, the educational value of block versus regular text based languages is highly debated with strong arguments on either side. I encountered the case made for using text-based languages opinion when  reviewing CodeGuppy , a platform that teaches kids (and teens and "creative adults") to code by writing Javascript.  full article on i-programmer: https://www.i-programmer.info/news/98-languages/15567-scratch-can-even-do-linux-kernel.html

Citus For PostgreSQL Goes Fully Open Source

 Citus, the PostgreSQL extension that transforms Postgres into a distributed database, has gone completely open source with latest release, version 11. I say completely, because some parts, like the shard rebalancer, had already been open sourced in earlier versions. This version however open sources everything.  But first a few words about Citus. As with other extensions that give PostgreSQL superpowers, Citus enhances Postgres with : full article on i-programmer: https://www.i-programmer.info/news/84-database/15548-citus-for-postgresql-goes-fully-open-source.html