PERL,INGRES,PROGRAMMING

  Alibaba has introduced Zvec, an open-source vector database designed to function as a lightweight library for on-device Retrieval-Augmented Generation (RAG). https://www.i-programmer.info/news/84-database/18742-zvec-lightweight-vector-database.html

  LiteCLI, a very handy SQLite client for the CLI diehards, is upgraded by getting a LLM feature that helps you write SQL. We first encountered LiteCLI back in early 2019, where we found that despite as an app lacking a GUI frontend, was agile and feature rich with functionality like: https://www.i-programmer.info/news/84-database/18048-litecli-sqlite-client-is-now-powered-by-llm.html

  SQLite lives in the browser thanks to WebAssembly. With Sqlime you can run your workload online with no need of setting up anything. On top of that ask questions on your data with AI enabled CLI utilities.  https://www.i-programmer.info/news/84-database/17786-sqlime-n-online-sqlite-playground.html

  This is thanks to sqlite-vec, a new vector search extension for SQLite written entirely in C and with no dependencies. Vendors are eager to add vector search to their dbms products. One prominent example is Postgres with pg_vector which we covered in "Turn PostgreSQL Into A Vector Store" and more recently Mariadb as examined in "MariaDB Introduces Vector Search". This begs the question of what's the rush for adding vetor support? https://www.i-programmer.info/news/84-database/17458-sqlite-gets-into-vector-search.html

  There's a self-paced. YouTube-based course by Mycelial on the ins and outs of SQLite. It's short, succinct and free and a must watch for anybody wanting to get started with  SQLite. https://www.i-programmer.info/news/84-database/17251-the-mycelial-sqlite-for-beginners-course-.html#google_vignette

  Stanchion is an open-source extension that adds columnar storage capabilities to SQLite, rendering it efficient for analytical reporting. Postgres is often praised for its extensibility, but we tend to forget that others, such as SQLlite, are extensible too. https://www.i-programmer.info/news/84-database/16976-stanchion-turns-sqlite-into-a-column-store.html

  ..with the 'sqld' daemon and access it over the network using  the PostgreSQL wire protocol. The use cases do not stop there. It seems that the Postgresql wire protocol, which enables you to migrate application code written for another dbms to Postgres, has set a trend. We've already checked BabelFish and MangoDB (now FerretDB) in action using it: https://www.i-programmer.info/news/84-database/16493-turn-your-sqlite-database-into-a-server.html

  pgsqlite is a pure python module and command line tool that makes it simple to import a SQLite database into Postgres, saving a ton of time and hassle in the process. SQLite is amazing. In "In Praise Of SQLite" I describe why that is so. One of those reasons was extensibility: in a sense extensibility is SQLite's biggest power; it adds unforeseen utility and value for its users, and we can witness many imaginative uses for it, provided by the community. I then gave a list of such extensions. But there's the other way too; not extending SQLite itself but extending third party products by means of SQLite. One such plugin is pgsqlite by Adam Fletcher of bit.io which allows for importing SQLite databases into Postgres seamlessly. full article on i-programmer: https://www.i-programmer.info/news/84-database/15799-pgsqlite-load-sqlite-databases-into-postgressql.html #python #community #database #sqlite #postgresql #postgres

 Meet sqlite-zstd, a Rust library that compresses your database many fold, leading to great savings in size while conserving its search capabilities intact. As pointed out in "In Praise Of SQLite", SQLite is not a toy database: 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, there are few built-in functions compared to PostgreSQL or Oracle.  SQLite doesn’t have any compression features. This has changed with the Rust-based library, sqlite-zstd which promises to: provide transparent dictionary-based row-level compression that allows compressing a sqlite database's entries almost as well as if you were compressing the whole DB file, while at the same time retaining random access. Suffice it to say that we are all aware of the benefits of compressing data, be it that of a PDF document, a humble ZIP file ...

 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

LiteCLI is a new open source command line client with many good features. Built in Python it is hosted on GitHub. There are quite a few SQLite GUI clients, such as DB Browser and Sqliteman, but not that many command line/terminal ones. Despite being command line, the new offering, LiteCLI, is feature rich, including: full article here