In this article, we're going to learn how to increase the efficiency of a common file merging workflow with the help of a web API solution. Specifically, we are going to learn how to merge Excel XLSX files - one of the most common document types we can expect to work within a file-processing automation environment.
Context for Programmatic XLSX File Merging
If we're writing code to solve problems related to file processing efficiency and automation, there's a good chance we're creating and/or expanding applications that deal with large volumes of Excel files. We may, for example, find that there's no automated workflow currently in place (or, perhaps, an inefficient one) to combine the various unique Excel reports created by each individual department in our organization.
WildFly CLI (Command Line Interface) allows you to manage and configure WildFly application server instances. One of its powerful features is expansion expressions, which enable you to work with multiple resources efficiently. In this tutorial we will learn how to perform multiple operation commands using the expansion operator (*) when possible and by iterating over ... The post appeared first on .
We released Quarkus 3.14.4, a maintenance release for our 3.14 release train. It contains several important bugfixes so we recommend the upgrade for anyone already using 3.14. It is especially important if you are using the combination of Gradle and Kotlin as we reverted an enhancement that caused an important regression. UPDATE To update to Quarkus 3.14, we recommend updating to the latest version of the Quarkus CLI and run: quarkus update Note that quarkus update can update your applications from any version of Quarkus (including 2.x) to Quarkus 3.14. For more information about the adjustments you need to make to your applications, please refer to the . FULL CHANGELOG You can get the full changelog of on GitHub. COME JOIN US We value your feedback a lot so please report bugs, ask for improvements… Let's build something great together! If you are a Quarkus user or just curious, don't be shy and join our welcoming community: * provide feedback on ; * craft some code and ; * discuss with us on and on the ; * ask your questions on .
There are 9 types of java.lang.OutOfMemoryErrors, each signaling a unique memory-related issue within Java applications. Among these, java.lang.OutOfMemoryError: Metaspace is a challenging error to diagnose. In this post, we'll delve into the root causes behind this error, explore potential solutions, and discuss effective diagnostic methods to troubleshoot this problem. Let's equip ourselves with the knowledge and tools to conquer this common adversary.
JVM Memory Regions
To better understand OutOfMemoryError, we first need to understand different JVM Memory regions. Here is a video clip that gives a good introduction to different JVM memory regions. But in a nutshell, JVM has the following memory regions:
In Java, we have two types of floating-point numbers: float and double. All Java developers know them but can't answer a simple question described in the following meme:
The State of ES5 on the Web - Some of the earlier JavaScript build tools focused on allowing developers to write modern JavaScript code that could still run on the browsers of the time by compiling code down to ES5. Time has moved on, but have the tools or popular libraries? Philip investigates, and shares some recommendations.
Philip Walton
📊The Top 5000 npm Packages by Size, Downloads, and Traffic - An interesting Google Sheets spreadsheet listing the top 5000 npm packages by package size, weekly downloads, and weekly traffic. One package is responsible for 278 terabytes of traffic per week, but the top 5000 add up to several petabytes.
Google Sheets / danhorus
Run GitHub Actions Up to 2x Faster at Half the Cost - Blacksmith runs your GitHub Actions substantially faster by running them on modern gaming CPUs. Integrating Blacksmith is a one-line code change. 100+ companies like Ashby, Superblocks, and Slope use Blacksmith to help developers merge code faster.
Blacksmith sponsor
Announcing TypeScript 5.6 - The latest TypeScript has landed with full support for iterator helpers, support for arbitrary module identifiers, --noUncheckedSideEffectImports to import modules without importing any values, and more - all covered in the always thorough release post.
Daniel Rosenwasser (Microsoft)
Is PHP the New JavaScript? - I'm no real fan of PHP, but there's been a lot of discussion on social media around increased interest in PHP by developers who'd usually steer clear of it, largely thanks to Laravel. This post tells the basic story and explains what Laravel brings to the table.
Building the Same App Using Various Web Frameworks - A scientist at Amazon who usually works in Python with a minimum of JavaScript on the frontend wondered if a more modern web framework would suit him better in 2024. To try this out, he tried Next.js, SvelteKit, and the Python-flavored FastHTML.
Eugene Yan
Brand New Performance Features in Chrome DevTools - A helpful look into Chrome's updated Performance Panel and all the different metrics it shows off to help you improve the performance of your site.
Umar Hansa (DebugBear)
React and FormData - FormData is ironically both the 'newest and yet oldest' standard for accessing form data. Here are some practical ways for using it with TypeScript.
Violentmonkey: A Way to Run Userscripts in the Browser - There have been many extensions to run your own custom JavaScript automatically on certain Web pages over the years, but Violentmonkey seems to currently be one of the better and well maintained open source ones. GitHub repo.
Violentmonkey Team
🔎 Orama 2.1 - Dependency-free, full-text and vector search engine for all JS runtimes, with typo tolerance, filters, facets, stemming, and more.
create-fastify 5.0 - Rapidly generate a Fastify project. It just takes npm init fastify app_name to get started.
file-type 19.5 - Detect the file type of a file, stream, or data. Now with WebVTT support.
TWGL.js 6.1 - Helpers for working with low-level WebGL from JS.
🎨 Chroma.js 3.1 - JavaScript color manipulation library.
"Harnessing Automatic Setup and Integration with Quarkus Dev Services for Efficient Development" by Ivelin Yanev to see the simplicity and power of Quarkus to encourage experimentation, quicker iterations, and ultimately a faster development cycle. Learn how to to make the Quarkus build goal cacheable with minimal modifications to the Maven build configuration, reusing outputs from previous builds to save time in Jérôme Prinet's article "Accelerate your Quarkus Maven builds with Develocity Build Cache". Read "Implementing a Quarkus REST API using PostgreSQL as Database" by Ivan Franchin as a step-by-step guide on how to implement the Movie API, a Quarkus application that uses PostgreSQL as database Explore how to create a dummy REST API in Quarkus and demonstrate various methods to consume it using different clients by reading "How to Consume REST API in Quarkus" by Alexandru Borza. Learn how to get the most out of your serialization performance in "Leveraging Quarkus build-time metaprogramming capabilities to improve Jackson's serialization performance" by Mario Fusco. Learn about the creation of the Quarkus JDiameter extension in Eddie Carpenter's blog post, "Revolutionizing Telecom Microservice - Modernizing JDiameter with Quarkus". You will also see the latest Quarkus Insights episodes, top tweets/discussions and upcoming Quarkus attended events. Check out ! Want to get newsletters in your inbox? using the on page form.
An SSR Performance Showdown - Fastify's Matteo Collina set out to find the current state of server-side rendering performance across today's most popular libraries. The first attempt faced negative feedback due to implementation issues, but the showdown has been improved and re-run.
Matteo Collina
Announcing Vue 3.5 - While v3.5 is a minor release, it's one Vue users will love, with big performance and memory usage improvements in its reactivity system. With no breaking changes, upgrade and watch memory consumption drop.
Evan You
WorkOS: The Modern Identity Platform for B2B SaaS - WorkOS is a modern identity platform for B2B SaaS, offering flexible and easy-to-use APIs to integrate SSO, SCIM, and RBAC in minutes instead of months. It's trusted by hundreds of high-growth startups such as Perplexity, Vercel, Drata, and Webflow.
Inside ECMAScript: JavaScript Standards Get an Extra Stage - After nine years of annual updates, TC39 has tweaked the process to make rolling out new features faster and smoother. The so-called 'Stage 2.7' has been around for a while, but this is a neat primer to what it represents.
Bye NgModules, the future of Angular is standalone! Angular v19 will make standalone: true the default for components, directives, and pipes. This is already the recommended best practice, however.
Node.js v22.8.0 (Current) - Adds a new API for enabling on-disk code caching at runtime, as well as options to set thresholds for code coverage success.
Astro 4.15 - The popular content site framework stabilizes Astro Actions, a solution for fully type-safe backend functions.
Jimp 1.3 - Pure JS image processing library for Node.
▶ Behind the Scenes: The Making of VS Code - A detailed conversation with two of the popular editor's principal engineers on what makes it tick. VS Code is surely one of the world's most widely distributed JavaScript-powered apps.
How to Use React Compiler - The compiler feature in React 19 is generating a lot of buzz - this "complete guide", as described by this author, covers much of what you'll need to get started.
📄 A Complete Guide to Beginning with JavaScript - A rather epic article packed with background knowledge, context, and third party resources for starting a modern JavaScript learning journey. Cody Lindley
Redwood v8.0 Released - A long standing, opinionated React & GraphQL (and/or RSC) full-stack framework that covers all the bases for professional dev teams with best-in-class tool support. v8.0 introduces a background jobs system, Docker support, and easier SSR and RSC setup.
Redwood Team
Tests Are Dead. Meticulous Is Here - Automatically creates & maintains E2E UI tests. Zero flakes. Backed by YC, CTO of GitHub, CPO of Adobe, CEO of Vercel.
Typist 7.0: Tiptap-Based Rich Text Editor Component - Simple and opinionated. You can try several examples in the sidebar. Well suited for basic rich text situations like writing comments or messages and has a single-line mode.
Doist
Belt: A New Tool for Starting React Native Apps - A CLI tool for starting a new React Native app that takes various mundane decisions away from you and uses tooling and conventions established by a productive app development team.
Thoughtbot
Tinybase 5.2 - Powerful reactive data store for local‑first apps. Now with Postgres support (which can even work in-browser!)
Rspack 1.0: The Rust-Powered JavaScript Bundler - Far from being 'yet another bundler' with its own approach and terminology to learn, Rspack prides itself on being webpack API and ecosystem compatible, while offering many times the performance. The team now considers it production ready and encourages you to try your webpack-based projects on it.
Rspack Contributors
💡 Rspack also has a family of ancillary tools worth checking out, such as Rsdoctor, a tool for analyzing and visualizing your build process (for both Rspack and webpack!)
Front-End System Design - Learn to create scalable, efficient user interfaces in this extensive video course by Evgennii Ray. Explore the box model, browser rendering, DOM manipulation, state management, performance and much more.
Frontend Masters sponsor
How to Create an NPM Package in 2024 - Sounds simple, but there are a lot of steps involved if you want to follow best practices, introduce useful tools, and get things just right. Matt Pocock walks through the process here, and there's a 14-minute screencast too, if you'd prefer to watch along.
Matt Pocock
IN BRIEF:
🤖 v0 is an AI-powered tool from Vercel for, originally, generating shadcn/ui-powered React components based upon prompts you supply. Now, however, it has basic Vue.js support too.
📊 IEEE has published its latest annual list of top programming languages. JavaScript takes third place, but TypeScript has leapt up several places to fourth.
RELEASES:
Prisma 5.19 - The popular ORM for Node.js and TypeScript adds 'TypedSQL', a way to write raw SQL queries in a type-safe way.
JavaScript Generators Explained - Jan was frustrated by the quality of documentation and articles explaining generators in JavaScript, and set out to explain things in a way that a more advanced developer could appreciate.
Jan Hesters
Implementing a React-a-Like from Scratch - While it's unlikely you'll actually want to do this, at least thinking about it can prove instructive as to what's going on in React's engine room.
TypeScript 5.6 Release Candidate - As always, Daniel presents an epic roundup of what's new. We'll focus more on it next week though, as the final release is anticipated to land next Tuesday (September 3).
✅ Bye Bye Bugs - Get 80% automated E2E test coverage for mobile and web apps in under 4 months with QA Wolf. With QA cycles complete in minutes (not days), bugs don't stand a chance. Schedule a demo.
Calendar.js: A Calendar Control with Drag and Drop - A responsive calendar with no dependencies, full drag and drop support (even between calendars), and many ways to manage events with recurring events, exporting, holidays, and more.
William Troup
📊 Perspective 3.0 - Data visualization and analytics component. The core is written in C++ and compiled to WebAssembly where it can be used from JavaScript. Their homepage shows it off well with a live example.
json-viewer 3.5 - Display JSON data in a readable, user-friendly way.
Last February, we released the first beta of jQuery 4.0.0. We're now ready to release a second, and we expect a release candidate to come soon™. This release comes with a major rewrite to jQuery's testing infrastructure, which removed all deprecated or under-supported dependencies. But the main change that warranted a second beta was a … Continue reading →
jQuery's influence on the web will always be evident. When it was first introduced in 2006, jQuery became a fundamental tool for web developers almost immediately. It simplified JavaScript programming, making it easier to manipulate HTML documents, handle events, perform animations, and much more. Since then, it has played and continues to play a major … Continue reading →
jQuery 4.0.0 has been in the works for a long time, but it is now ready for a beta release! There's a lot to cover, and the team is excited to see it released. We've got bug fixes, performance improvements, and some breaking changes. We removed support for IE<11 after all! Still, we expect disruption … Continue reading →
DZone Java Zone
