Sample work

Examples of how the work runs

These are demos and case notes. There is no real client name, logo or data.

Examples of how the work runs
Corporate site demo
Demo

Corporate site demo

Technology: PHP, HTML, CSS

Problem. The page breaks on a phone. A visitor leaves before understanding the work, and there is nowhere to leave a quote.

Solution. A short homepage, service blocks and a validated contact form. Copy is entered in the business’s own words.

Result. Demo: the page can be used with one hand, and an incomplete form is not stored. This is not a client case.You will receive an email notification when a form is submitted to the admin panel.

Admin panel demo
Demo

Admin panel demo

Technology: PHP, JSON

Problem. Incoming requests live in scattered notes. Nobody can see which ones were answered.

Solution. A single-admin sign-in, a request list and a status field: new, seen, quoted, closed. Use of our proprietary admin panel software.

Result. Demo: a record from the form shows up in the panel and its status can change. There is real client data.

SQL case note
Demo

SQL case note

Technology: SQL

Problem. A monthly report query gets slower each time the table grows.

Solution. Backup first. Then the extra subquery is simplified, a fitting index is tried, and the result is checked on a sample set.

Result. Sample note: the query plan gets simpler. No timing promise is made, and no number is invented without real data. SQL queries can be optimized in a very short time.