Skip to main content

Posts

Real World Schema Exploring With Azimutt

 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
Recent posts

Knock Yourself Out With 91 Python Videos

 The talks and tutorials presented at the 4th annual Python Web Conference are now available for free. Topics ranged from Code and Tech to Social and Career advice. Six Feet Up's Python Web Conference 2022 (#PWC2022), was a virtual event that took place between March 21 and 25, targeted at Python Web Developers. It featured 90 international experts presenting on 85 topics such as Django, CI/CD, Containers, Serverless, REST APIs, web security and microservices, split into 6 tracks.The tickets were priced $99 for students and $199 for pros, and the attendees were 376 devs coming from 36 countries. The presentations and post-event recordings have been shared as huge playlist on YouTube. The talks on development included topics such as :  full article on i-programmer: https://www.i-programmer.info/news/216-python/15635-knock-yourself-out-with-91-python-videos.html

Securing Your Software Supply Chain With This Free Course

 A new course  from the Linux Foundation on the edX platform  aims to educate the industry on how to digitally sign software artifacts. Targeted at both software developers and DevOps and security engineers, it focuses on using the Sigstore toolkit to secure the software supply chain.  Sigstore is really upping its game. Supporting new tools, like GitSign which I recently covered, it produces announcements, consortiums and educational material. It really is taking supply chain security seriously. For those still not aware of the concept, the desired outcome is to protect the software supply chain. How can this be achieved? full article on i-programmer: https://www.i-programmer.info/news/150-training-a-education/15617-securing-your-software-supply-chain-with-this-free-course.html

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

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