Uniface Reporting Service Adds Year Comparisons, Cash Forecasts and Sales Funnel Using Plain SQL

·9 views

A customer app built in Uniface 10 gained a reporting service covering a cockpit, month-end report, year comparison, margins, cash forecast, stock turnover, service figures and a sales funnel. All of it runs in a single service, KPI2_SVC, which builds plain SQL, queries SQLite and returns Uniface lists or writes HTML files. The cockpit returns eighteen figures bundled as key-value items rather than separate output parameters. The author deliberately avoided window functions, CTEs and multiple scalar subqueries, after an earlier SELECT without a FROM clause silently terminated the Uniface process. Year-over-year comparisons instead use derived tables with twelve literal month rows, so months without revenue still appear. The approach was tested with Rocket Uniface 10.4.03 and SQLite 3.50.2 in October 2026.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Python Decorators Explained: How Functions Wrap Other Functions

A beginner-focused guide breaks down Python decorators, a feature often seen as confusing at first. It shows how repeated logging code across functions can be replaced by a decorator that wraps each function. The article explains that the @ symbol is shorthand for passing a function into a decorator and reassigning the result. It also covers how *args and **kwargs let a decorator work with any function, and lists common uses such as logging, timing, caching, authentication, and retry logic.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Scanner Probed a Site for 400 Secret Files in One Minute; None Were Exposed

A single client sent about 1,180 requests to a domain in one minute, requesting roughly 400 sensitive file paths such as environment files, WordPress configs, and cloud credentials. The client identified itself as tlm-scanner/2.0, and the site returned no sensitive files, with only the home page and redirects or refusals for the rest. Shortly afterward, a slower sweep disguised with browser user agents targeted a subdomain and included a path tied to AI provider keys. The author argues that such scans are routine and that site owners should check their own logs, since successful probes often go unnoticed.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

AI Student Launches Personal Developer Portfolio Showcasing Projects and Interests

A student studying AI and Data Science has launched a personal developer portfolio to consolidate their work in one place. Rather than just listing languages and frameworks, the site is meant to reflect their learning journey and the projects they are building. The creator also used the project as a way to experiment with presenting technical work through a polished web experience. Their next focus is Generative AI, LLM-powered applications, and AI agents, with plans to turn ideas into practical projects. They have invited other developers working on AI engineering to connect and share their work.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

New proof settles A(4)=4 for a 2-group problem via a single-vector argument

A researcher's open notebook on Kakeya-type problems reports a result on finite 2-groups whose involutions are all central. The author applies a closer look at a single vector to sharpen a restriction lemma from an earlier post. The analysis establishes that the invariant A(4) equals 4, which settles the question for groups with a self-centralising normal subgroup of the form Z_4^a x Z_2^b. The argument relies on anisotropic linear systems and a polar form, and it also establishes M(4)=4. The author notes that part of the verification was computer-assisted and that the associated tests passed before publication.

0 comments Read more at DEV Community