#44 — Group Rows And Combine Non-Null Values in Each of The Non-Grouping Columns

About the utility: A long time ago, I wrote 4 projects in parallel and got tired of transferring code between projects and created an organization with shared code in Github (https://github.com/rucken ), where he took out everything in common from different projects, but in addition to the code there were also various devops scripts. I…

Marketplace app Marketplace app using NestJS, Next.js 14, Tailwind CSS, Prisma, and NextAuth. Features include user sign-up, sign-in, browsing ads, adding and deleting ads, and filtering options. Open to all contributions during development. Getting Started Clone the repository: git clone https://github.com/saidMounaim/marketplace.git Install dependencies: For the frontend: cd frontend npm install For the backend: cd backend…

Managing global state in Vue applications has traditionally been a complex task with Vuex. However, with the advent of Pinia and the Composition API, you can streamline your state management, making your codebase simpler and more intuitive. In this post, we’ll demonstrate how Pinia integrates seamlessly with the Composition API to create a powerful and…

With the rise of the Composition API in Vue 3, Pinia has emerged as a lighter, simpler, and more modern state management library compared to Vuex. Pinia integrates seamlessly with the Composition API, offering a more intuitive way to manage global state. In this post, we’ll build a simple counter app using Pinia and Vue.js…

Hey friends✨ I hope you all are doing well on your journey➡️. Learning #DevOps♾️ concepts and understanding its principles is the best way to become a #DevOps♾️engineer💻. I have learned a lot of things in my #DevOps♾️ journey, but the important thing is that if you have good knowledge of these important things, then you…

Managing global state in a Vue.js application is critical, especially when different components need to share data or react to changes. Vuex is the official state management library for Vue.js, offering a structured way to manage state globally. Combined with Vue.js Lifecycle Hooks, you can manage global state in a precise and predictable manner. In…

Background At Spellr, a digital tutor for kids learning reading and writing, we needed a tool to streamline communication between our designers and developers when using Rive’s animation platform, especially for state machines. Rive is fantastic, but also difficult to learn for one core reason: the state machine. Rive describes it’s state machine as “a…

Merge Sort was introduced by John von Neumann in 1945, primarily to improve the efficiency of sorting large datasets. Von Neumann’s algorithm aimed to provide a consistent and predictable sorting process using the divide and conquer method. This strategy allows Merge Sort to handle both small and large datasets effectively, guaranteeing a stable sort with…

As social media continues to grow, the need for robust tools to track, analyze, and interact with public data has become essential for developers, businesses, and researchers. Over the past few months, I’ve been working on two APIs—one for Twitter and another for Telegram—designed to help developers easily access and analyze data from these platforms….

Introduction In the realm of database performance optimization, SQL queries involving window functions present unique challenges. This article explores how PawSQL, an advanced SQL optimization tool, significantly enhances the performance of such queries through intelligent index recommendations. We’ll examine a specific case study to illustrate the process and benefits of this approach. Case Study: Analyzing…

Today, I’m excited to introduce SafeLine, a free and open-source Web Application Firewall (WAF)! GitHub: https://github.com/chaitin/safeline SafeLine is an open-source WAF designed for simplicity and ease of use. It’s available as a community edition and can be installed quickly with minimal effort. SafeLine helps protect your web services by filtering incoming traffic from the internet,…

What Do NextJs, Search Engine Optimisation And Cycling Have In Common? In 2003, the British Cycling Organization hired Dave Brailsford as its performance director. In the next decade, British cycling teams under his care dominated the sport, turning 110 years of losses into a victory streak. This was achieved thanks to hard work, determination, and…

Docker is an open-source application container engine built with Go and follows the Apache 2.0 protocol. It enables developers to package their applications and dependencies into lightweight, portable containers. These containers can be deployed on any popular Linux machine, offering a form of lightweight virtualization. Each container operates in complete isolation (similar to iPhone apps),…

Continuing from the previous article: Source Code Analysis of Apache SeaTunnel Zeta Engine (Part 1): Server Initialization Task Submission on the Client Side In this section, we will explain the task submission process in Apache SeaTunnel using the command-line interface (CLI). To submit a task using the CLI, the command is: ./bin/seatunnel.sh -c <config_path> When…

Recently, I wanted to understand deeply how to create React apps today, which technologies to chose between Redux, RTK Query, React Query, Zustand, NextJS. I also wanted to understand perfectly the old and new Hooks available in React. And how to connect a store-based app to an external API. So I decided to create this…

Hello, I have an android app created using react. The app contains a wordpress web site and enable push notification on mobile device. A push notification is generated on device when an article is published. The app works but, starting from a specific moment (maybe after a wordpress core upgrade), the push notifications doesn’t work…

My journey in programming began over two decades ago, a time when JavaScript was a far cry from its current state, and developers were primarily focused on Microsoft Internet Explorer. One of my proudest achievements back then was writing a few lines of code that allowed users to add and remove table rows entirely on…

Hi, I have a vite/vue project and I need to use ssr for the public part, for indexing. Except that I can’t configure it correctly with vike, should I do something else? here is the error when launching the front: npm run dev reseau@1.0.0 dev vite 09:40:31 [vike][config][Wrong Usage] /src/pages/+config.js sets an unknown config vue…

In the realm of cloud computing, high availability and reliability are crucial for maintaining the performance and stability of applications. Amazon Web Services (AWS) offers a robust solution for achieving these objectives through Cross-Zone Load Balancing. In this article, we’ll explore what Cross-Zone Load Balancing is, how it works, and the benefits it brings to…

A Web Application Firewall (WAF) operates at the application layer, providing protection for web requests and responses. WAFs can safeguard your web applications from common threats such as SQL injections, cross-site scripting (XSS), and other vulnerabilities. Additionally, they can monitor and filter traffic that may lead to Denial of Service (DoS) attacks, helping ensure the…

Hello everyone Hello, everyone I am currently working on growing a Node.js application and considering moving from a monolithic to a micro service architecture. As the user base and data load continue to expand, I have discovered performance bottlenecks and difficulties in maintaining various portions of the app. What best practices and critical considerations would…

Dev Developing applications with new AI technology can be an exciting and rewarding experience. Here are some steps to help you get started: Define your objective: Clearly outline the problem you want to solve or the task you want to automate with AI technology. Understanding your objective will guide the development process. Choose the right…

What is word embeddings? Word embeddings are a type of word representation used in natural language processing (NLP) and machine learning. They involve mapping words or phrases to vectors of real numbers in a continuous vector space. The idea is that words with similar meanings will have similar embeddings, making it easier for algorithms to…

Using a proxy server to bypass regional blocking is a common and effective method. As an intermediary, the proxy server can hide the user’s real IP address, making the user’s request look like it comes from the geographic location of the proxy server, thereby bypassing regional blocking. Key steps to bypass regional blocking using a…

Hey, Dev.to community! 👋 Welcome to a beginner-friendly guide to Building REST APIs in Java. Whether you’re just getting started or want to solidify your understanding, this article will walk you through the basics, providing easy-to-follow explanations and practical examples. What is a REST API? REST (Representational State Transfer) APIs are a popular way for…

When writing Python code, it’s common to encounter situations where different types of errors can occur. Handling these exceptions properly is crucial for writing robust and maintainable code. But did you know that you can catch multiple exceptions in one line? Let’s dive in! The Problem: Handling Multiple Exceptions Imagine you have a piece of…

Je crée un moteur de jeu! Introduction à cette grande aventure Depuis quelques semaines maintenant je travaille régulièrement sur un projet qui je pense peut être intéressant à raconter, la création de mon moteur de jeux vidéos en JavaScript et HTML5 basé sur les canvas. Tu te demande sûrement pourquoi avoir choisi HTML5 et JavaScript…

This is a Plain English Papers summary of a research paper called When Building Search or Recommendation Systems, Choose Retriever Wisely: HNSW vs. Flat vs. Inverted Indexes. If you like these kinds of analysis, you should join AImodels.fyi or follow me on Twitter. Overview Provides operational advice for dense and sparse retrievers like HNSW, Flat,…

This is a Plain English Papers summary of a research paper called Harnessing Graph Neural Networks: Revolutionizing Epidemic Modeling and Forecasting. If you like these kinds of analysis, you should join AImodels.fyi or follow me on Twitter. Overview The paper provides a review of how graph neural networks (GNNs) can be used in epidemic modeling….

This is a Plain English Papers summary of a research paper called Large Language Models’ Cognitive Capabilities: An Indicator of Artificial General Intelligence?. If you like these kinds of analysis, you should join AImodels.fyi or follow me on Twitter. Overview Examines the general intelligence factor, known as the “g factor,” in large language models Employs…