PERL,INGRES,PROGRAMMING

  Until now getting hold of a free Oracle database was a struggle - requiring account registration, negotiating pages full of legalese and safeguarded downloading bays. Does this "Free For Developers" product change that, or is it a rebranding of Oracle XE to make its use case clearer. https://www.i-programmer.info/news/84-database/16375-oracle-database-23c-free-for-developers-how-free.html

 Azimutt is a free and open source database schema explorer with many great features. I put it to test when designing a Spring Boot application. Here's what I discovered. Azimutt's main functionality allows exploring your schema by searching for relevant tables, following the relations and even finding paths between tables you want to connect. It is web based and as such runs within the browser therefore there's no separate binaries to download and install, something that makes it portable. My discovery of Azimutt came at a crucial moment when developing a Spring Boot application. To set the scene, the application interacts with a SOAP web service and uses Hibernate to store the data that it consumes. On top of that the UI is written in Vaadin. However, the XML schema provided by the SOAP endpoint was very complex, containing many entities and relations between them.To get more insight of the XML schema, a first attempt was made to visualize it trying out a number of tools ...

 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

 There is now an English version of a guide that goes through the considerations you have to make in order to migrate to Postgres from another Database Management System. Initially released in 2013 association with the French administration, the guide was previously only available in French. Its English version came out in November 2021 with the aim to address a much wider audience. It's a light read that, without going too deep into technical details, enumerates the advantages of using PostgreSQL by describing its integration, security and robustness mechanisms. As to why you would replace your current DBMS with Postgres, there's plenty of reasons. In PostgreSQL 14 Is Here - A Look At Its Past And Future I give two of them: full article on i-programmer: https://www.i-programmer.info/news/84-database/15150-the-postgressql-transition-guide-helps-you-make-the-switch.html

  Babelfish and MangoDB are two solutions that move your application workloads from SQL Server and MonoDB respectively to PostgreSQL. We have repeatedly outlined why PostgreSQL rules the DBMS world. Some examples are  PostgreSQL 14 Is Here - A Look At Its Past And Future  and  PostgreSQL Is DB-Engines DBMS of the Year For 2020 . While there are existing methods for moving from DBMS "A" to Postgres, as  The Complete Oracle to PostgreSQL Migration Guide  by EDB demonstrates, migrating application code is a whole different concept.To meet this need Babelfish and MangoDB let PostgreSQL understand queries from applications written for Microsoft SQL Server and MongoDB respectively. full article on i-programmer: https://www.i-programmer.info/news/84-database/15018-move-over-to-postgresql-with-babelfish-and-mangodb.html .  

EdgelessDB is 100% compatible with MySQL enhanced with confidential computing capabilities based on secure enclaves on Intel SGX chips. These properties make it one of the safest database management systems on the market. There's a lot to assimilate here - Confidential computing, Intel SGX, Enclaves. So first of all let's tackle SGX: full article on i-programmer: https://www.i-programmer.info/news/84-database/14982-edgelessdb-taking-database-security-to-the-next-level.html

DataStax, mostly known for AstraDB the multi-cloud database based on Apache Cassandra, has announced the addition of new capabilities to its Stargate Gateway product. Stargate is a data gateway deployed between client applications and databases. Its novelty lies in that it exposes the database layer as a multitude of APIs, that way offering flexibility to the way you expose your data. Needless to say, that's a big boon for developers. full article on  i-programmer.info :  https://www.i-programmer.info/news/84-database/14935-datastax-extends-stargate.html

  The latest release of PostgreSQL has new and exciting features. We look the most worthwhile of them identified by Umair Shahid, Head of PostgreSQL at Percona while referring to the past ideas that shaped their foundation. Who would have thought back then in the 80's that the humble  Ingres  fork would,  according to the  Genealogy of Relational Databases , become one of the most, if not the most, successful DBMS of all time? There are two reasons behind its success;   full article on i-programmer.info

  If you are at all confused about which of PostgreSQL index to choose for a specific use case, there's a  free course from Percona University designed to help you. This free Percona University short course about the different kinds of indexes PostgreSQL supports. is available as a collection of videos on YouTube as well as on Google Classroom. It goes over the different types of indexes, when to use each and how to usethem  optimally in order to squeeze performance out. The premise is that not all indexes are appropriate for all circumstances and using a ‘wrong’ index can have the opposite effect to that you intended.   full article on i-programmer.info

  OtterTune is a tool powered by self-driving DBMS technology out of R&D at Carnegie Mellon University that aims to alleviate the fundamental difficulties of tuning a DBMS. full article on i-programmer.info

SQL Server had for a long time been integrated with the Common Language Runtime under which it could interface with the general programming languages of the .NET framework, allowing for writing stored procedures, triggers, user-defined types, user-defined functions, user-defined aggregates, and streaming table-valued functions using the likes of Visual Basic .NET or C#. But that's deep integration. For the rest of the languages, not part of the .NET framework, SQL Server can still interact with them at a minimal level through the so-called Language Extensions SDK, for the time being just programs written in Java. on i-programmer

Open Source vs. Commercial, Public Cloud vs. On-Premise vs. Hybrid Cloud? Which one? Last month ScaleGrid attended Percona's Live event, got the insight on the most used "databases" by Percona's clients in 2019 and made a report out of it. I'll ignore the fact that the report mistakenly uses the term "database" in place of (R)DBMS, so that I can just focus on the juicy stuff. The popularity categories are broken down into: Top Databases Used: Open Source vs. Commercial Cloud Infrastructure Analysis: Public Cloud vs. On-Premise vs. Hybrid Cloud Polyglot Persistence Trends: Number of Databases Used & Top Combinations So first of all, the lowdown on the top Open Source "Databases". full article on i-programmer

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

An attempt to work around the Limitations of Database Procedures when used with Global Temporary Tables Successfully tested on  Ingres II 9.2.0 (int.lnx/118)NPTL On Ingres II 10.0.1 (a64.lnx/100)NPTL returns error: E_SC0206 An internal error prevents further processing of this query.     Associated error messages which provide more detailed information about     the problem can be found in the error log, II_CONFIG:errlog.log Code on GitgHub

Splice Machine is a novel attempt to merge the best parts of the traditional relational database management systems and their NoSQL counterparts with distributed and in-memory computing based on Hadoop and Spark. Traditional RDBMS find it tough when faced with massive amounts of data, which they typically handle by scaling up, albeit expensively. Another side effect of the sheer volume of data accumulating from the likes of social media and mobile devices, is that OLTP and OLAP queries carry high performance hits that subsequently have detrimental effects on real time analysis and instant decision making. full article on i-programmer

Version 11 of Actian's Ingres open source RDBMS, is going to be a major release as indicated by the jump in the version number. The sequence goes 10.0.0, 10.1.0, 10.2 and from there to 11. This heralds quite a few changes and welcome additions. The technical preview available at the moment provides only the bare minimum of information, so we dug deeper and can now reveal the most important new features, as far as developers are concerned, broken down by category. full article on i-programmer

With the new PostgreSQL version 9.5 about to be released, we take a look at the most anticipated upgrades it will bring, beginning with its new Upsert feature. PostgreSQL is the open source database system that was originally created at the University of California, Berkeley. It is now over a year since its last decimal point upgrade, see  PostgreSQL 9.4 Released , and there are some notable enhancements. full review on i-programmer

news on i-programmer

An interview with Roy Hann