PERL,INGRES,PROGRAMMING

  The first is in relation to Github Copilot and the second  to PostgreSQL. They enable seamless integration with any tool that supports the protocol. https://www.i-programmer.info/news/90-tools/18008-two-new-instances-of-the-language-server-protocol-.html

  MotherDuck, DuckDB's makers, having listened to its users, has released a local GUI for easier interaction with the database. https://www.i-programmer.info/news/84-database/17935-interact-with-duckdb-using-local-ui.html

  This free, video-based, course from DeepLearning.AI is about coding assistants and in particular Windsurf. It shows how we can leverage such tools to become much more productive. https://www.i-programmer.info/news/105-artificial-intelligence/17925-build-apps-with-windsurfs-ai-coding-agents-the-course.html

  Here we take a look at Gitingest and Repomix, two tools that render a codebase suitable for LLM ingestion. Why is that useful? https://www.i-programmer.info/news/105-artificial-intelligence/17920-tools-to-share-your-codebase-with-llms.html

  Potpie allows you to chat with your codebase or any public codebase for that matter, to explain it, debug it, or do engineering tasks on it like generating test plans. https://www.i-programmer.info/news/105-artificial-intelligence/17917-potpie-agentic-ai-on-your-codebase.html

  Meet Yizy, a brand new browser based,free, open-source tool  that makes designing APIs a breeze; code generation and AI included. https://www.i-programmer.info/news/90-tools/17899-yizydev-schema-first-api-design-.html

  Steampipe renders SQL as the main query language for more than purely databases, Cloud infrastructure included. Let's find out how. https://www.i-programmer.info/news/84-database/17864-streampipe-sql-for-everything.html

  ChartDB is an open-source database diagrams editor that can be self-hosted or used in the Cloud, for free. At IProgrammer we're very fond of utilities that make the developer's life just that little bit easier, especially on the database front. In the past we had covered a few such cool tools like Prisma Markdown which can automatically generate ERDs, ERDLab, an intuitive SQL Visualization tool which helps in capturing your database design thoughts and Azimutt, a database schema explorer with many great features. https://www.i-programmer.info/news/90-tools/17852-database-diagramming-with-chartdb.html

  Prisma Markdown is a new tool that takes the pain out of drawing entity relationship diagrams. An essential help if your design is database driven rather than code driven. https://www.i-programmer.info/news/84-database/17561-effortless-erd-design-with-prisma-markdown.html

  Our profession as software engineers is governed by terminology which includes a whole bunch of acronyms that make life even more difficult than it is already. Here's an open-source, easy-to-use online resource that helps make sense of complicated tech terms. https://www.i-programmer.info/news/80-java/17467-dev-encyclopedia-shares-the-knowledge.html#google_vignette

  Claude Engineer is a CLI tool that draws on Anthropic's Sonnet 3.5 model to add super power capabilities to your coding workflow. https://www.i-programmer.info/news/105-artificial-intelligence/17447-claude-engineer-amplifies-your-code.html

  Leporello.js is an interactive functional programming IDE for JavaScript with debugging superpowers. Let's look at what makes it different from traditional IDEs. https://www.i-programmer.info/news/90-tools/16754-leporellojs-the-next-gen-javascript-ide.html

  Power up your API testing inside your CI workflow with Step CI, a free open-source tool that has also introduced a paid Support Plan. Step CI is another tool to have in your developer's toolbelt.We had a look at a few others recently. These were OpenAPI Diff, AWS Smithy and Redocly CLI, each one having its own purpose: OpenAPI Diff, or Oasdiff for short, is an open source utility that takes comparing OpenAPI specs to identify breaking changes to a whole new level. https://www.i-programmer.info/news/80-java/16743-step-ci-the-api-quality-assurance-framework.html

  Smithy is an open source project by AWS with which you can model your APIs, generate code and documentation for clients and servers, as well as other artifacts, in many programming languages. https://www.i-programmer.info/news/90-tools/16651-model-your-apis-with-aws-smithy.html

  Redocly is an open source tool written in Typescript that assists in managing your APIs effectively. What can it do? https://www.i-programmer.info/news/90-tools/16628-redocly-cli-the-super-tool-for-api-management.html

  LiveCodes is a groundbreaking code playground with unique features. And it is free too. Currently in Beta. Let's look into it. What? Yet another playground? I thought we had a lot already. But LiveCodes deviates from the standard shape of the usual playgrounds. What are its unique features? https://www.i-programmer.info/news/182-frameworks/16618-introducing-the-livecodes-code-playground.html

The Open Source Security Foundation has recently launched three brand new and free courses on Secure Software Development, which are hosted on edX. Nowadays every company is a software house regardless of the business it is in be it finance, manufacturing or healthcare. To provide value, businesses have to communicate through software applications built in-house or by a third party. The problem is that cyberattackers will attack those applications, probing them to uncover vulnerabilities to exploit and get access to your internal networks, steal company and customer data or just create havoc. full article on i-programmer

DeepCode, a SAST tool bug finder based on machine learning, can now be used seamlessly from within IntelliJ, PyCharm, and WebStorm. There's a lot of interest lately on Static Application Security Testing (SAST) Tools, and that has to do with the fact that the software written today is very complex and very large - a simple code review by humans won't cut it anymore. Thus the introduction of SAST tools into the CI/CD pipeline and more specifically at the Commit-time and Test-time check phases.We've recently covered a new hybrid kind of tool of the genre, in " Semgrep - More Than Just a Glorified Grep" , which occupies a space somewhere in between grep and a SAST tool - more expressive than grep, but not as hard to tweak and learn as a SAST. on i-programmer

uni is an open source tool with just four commands that lets you query the Unicode database from the command line. It will make you wonder how you went through life dealing with character encodings without it.  With this tool you get to interrogate the Unicode database (full support for Unicode 12.1) from the CLI. For example,working with HTML and want to find the html escape of the € euro sign? Tell uni to identify it: full article on i-programmer

There will no longer be a fee for Komodo, the multi-language IDE for Python, PHP, JavaScript, HTML5, CSS, Node.js, Golang, Ruby, Perl, and a variety of other languages and frameworks.  Last time we reported on Komodo, back in 2017, see  Komodo 11 With Revamped Code Intelligence , its lightweight counterpart Komodo EDIT was the only free offering, and of course had limitations: Komodo Edit provides the basic functionality you need for programming without debugging, unit testing, collaboration, or integration with build systems unit testing Now, with the release of Komodo 12, you get all that for free, plus the embedded ActiveState Platform with which you can automatically build runtime environments by just choosing your packages letting the Platform to resolve the necessary dependencies, as well as the State Tool, with which you can instantly and locally deploy your runtime environment. full article on i-programmer