You searched for database - Software Development at Program Tom LTD

Database Integrations in Spring Boot

Posted on March 12, 2025 by Toma Velev

Here are minimal examples of different Database Integrations in Spring Boot that you could choose from in your applications. 1. JdbcTemplate (Plain JDBC) JdbcTemplate is a lower-level approach that directly executes SQL queries. import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.core.RowMapper; import org.springframework.stereotype.Repository; import java.sql.ResultSet; import java.sql.SQLException; import java.util.List; @Repository public class UserJdbcRepository { private final JdbcTemplate jdbcTemplate; public…

Restoring MariaDB Database Running inside Docker

Posted on September 2, 2024September 2, 2024 by Toma Velev

Restoring MariaDB Database Running inside Docker has not worked as expected – like – simple copying the externally mapped volume files and restarting the container. Understand what Docker container is You need to first understand what docker (or any other tech like it) contaienr is. It is sandboxed and isolated linux distribution. It runs with…

Optimizing Data Transfer – Front-End, Database & Micro Services

Posted on February 29, 2024March 1, 2024 by Toma Velev

No matter if you are using Micro Services or Monolith software architecture, you need to optimize Data Transfer – especially when handling huge size of information. The most minimal case is – between the server and the Front-End, and optimally – between the backend software modules. Caching Implement caching mechanisms at various layers of your…

Where is best to keep the Logic – in the Database or in the Application Layer?

Posted on December 11, 2023December 11, 2023 by Toma Velev

The decision of where to keep the logic, whether in the database or in the application layer, depends on various factors and the specific requirements of your application. Both approaches have their advantages and disadvantages, and the right choice often involves trade-offs. Here are some considerations to help you decide. Keeping Logic in the Database…

2024 – Never Aging – Database Apps – Best Practices

Posted on September 27, 2023September 27, 2023 by Toma Velev

Follow these Best Practices to Build a robust and long-lasting Database Apps in 2024 – from the start of your development. Choose a Scalable Database System Select a database system that is known for its scalability and longevity. Popular choices include PostgreSQL, MySQL, or cloud-based solutions like Amazon RDS or Google Cloud SQL. Ensure it…

Database Normalization & Micro Services & Role Separation

Posted on August 11, 2021August 11, 2021 by Toma Velev

In this article I’m gonna make a relation between three things found in software design and development: Database Normalization Micro Services Architecture Company Roles Separation From a purely abstract technological point of view, in the major case – deep completeness of these minifications are considered good. But, too much detailization creates complexity could spread beyond…

How To Use Indexed DB – a Database in the Web Browser

Posted on December 27, 2020October 9, 2023 by Toma Velev

Can I Use IndexedDB – the Database of the Web Browsers? IndexedDB Database is the accepted (standardized) way of storing semi-structured & organized information in the Web Browsers. It is supported by most of them in their latest version: https://caniuse.com/indexeddb. In programming terms – you could check the support programmatically this way: window.indexedDB = window.indexedDB…

What are ways to Optimize the backend endpoints in Spring Boot

Posted on July 12, 2025 by Toma Velev

To Optimize backend endpoints in a Spring Boot app with Java 17 can significantly improve performance and scalability. Here’s a structured list of strategies, starting from database-level optimizations and moving to application and infrastructure layers: Database/SQL Optimization ✅ Optimize SQL Queries Use EXPLAIN plans to analyze slow queries. Use proper indexing on columns used in…

Could a Flutter App save a Flag even after uninstall

Posted on July 12, 2025 by Toma Velev

No, a standard Flutter App (or any mobile app) cannot persist a Flag or data after executing uninstall, because: 🔒 App Data Is Deleted on Uninstall When a user uninstalls your app: All app data stored on the device is removed, including: Shared preferences SQLite databases Internal storage Cache This behavior is enforced by both…

Could iOS flutter app logs be viewed while running in release modetate

Could iOS flutter app logs be viewed while running in release mode – started after previous closed state

Posted on July 12, 2025July 13, 2025 by Toma Velev

In Flutter, iOS app logs in release mode are very limited, and typically not viewable through flutter logs or Xcode like in debug or profile mode. However, depending on what exactly you’re trying to capture, here’s a breakdown of what’s possible: 🔍 1. Flutter Logs in Release Mode flutter logs will not show Dart-level logs…