Think Bigger - Think on Future

[Otto]

Hello friends,

It is entirely possible to build your own CRUD functionality using low-level functions, especially in an RDP environment where database access is limited to the RDP server or the web server. With appropriate file and memory management, this can be a viable solution.

Approach for Implementation: Low-Level File Operations: You can manage files directly using low-level functions in programming languages like HARBOUR/FIVEWIN (C, C++), or even PHP (with native file operations). For each CRUD operation, use specific read and write mechanisms to manage the data in the database file.

Custom Indexing: By implementing your own indexing, you can make search and sorting functions efficient without relying on external database technologies.

Access Control: In an RDP environment, access could be granted only to authorized applications, minimizing the risk of external access. You could also implement a simple authentication and permission system to further secure access.

Performance Optimization: By writing code tailored to the specific needs of your environment, you can optimize the performance of your CRUD operations by caching data in memory, performing write operations in batches, or setting up logging for repeated queries.

Error and Transaction Management: Ensure your system handles transactions securely and creates error logs to prevent data loss or corruption.

Advantages:

Flexibility: You have full control over the implementation and can tailor features to your specific requirements. Security: With low-level control, you can better secure data access. Maintainability: You can design your system to work without external database engines, which is advantageous in a restricted environment like RDP.

However, we don’t need the usual advice on SQL here.

This topic should not cover that. For our purposes in an RDP or web server environment with small to medium access numbers, SQL databases are often outdated and come with unnecessary overhead. Modern file systems can efficiently handle large amounts of data, and a streamlined, low-level implementation saves resources, reduces complexity, and is usually more cost-effective and easier to maintain for small to medium-sized businesses.


As we have seen from other posts, the RDP concept is unfortunately still not understood by everyone in this forum.

It is important to understand that the data should belong to you, not to an SQL server. It requires direct access, without intermediaries and unnecessary layers.

Best regards,
Otto