PHP and fast files database

Started by RonaldVance, Feb 26, 2023, 01:25 AM

Previous topic - Next topic

RonaldVanceTopic starter

Hi there!

I am currently working on a PHP project that needs to store data quickly and have a fast insertion/selection process. Do you have any recommendations for this?

I would prefer options that do not require external modules like sqlite, as the hosting platform has strict requirements on the minimum set of external PHP modules that can be used. I'm hoping to find a class that is integrated into the project, and can be used to manage the database efficiently.


It seems that you are not content with using MySQL and instead want to handle the files yourself. Can you explain why you feel this way?

Before making any decisions, it is important to understand your reasons for wanting to take this approach.

That being said, I would still suggest finding a hosting platform that supports MySQL and using it. MySQL has proven to be a reliable and widely-used database management system, and it can greatly simplify the process of storing and managing data for your project.


Hey there!

The requirements for a project can vary greatly, depending on what is needed. For instance, if a project requires complex samples or a large database, the requirements will be quite different compared to a smaller project.

As an example, in my work with small stores that are linked to an affiliate program, I find that storing the serialized array of products and categories in a file is sufficient. This method works well with a product count of fewer than 5,000.

However, for larger volumes, a more robust solution like MooSQL may be necessary. It's worth noting that while MooSQL may not be actively developing, it's still a viable option if you don't need a lot of functionality beyond basic SQL queries. Ultimately, the choice of storage and database largely depends on the specific needs of the project.


It's important to know whether the customer has prior knowledge of hosting services and databases, or if they're just looking for something because they heard about it somewhere.

In terms of what the client is actually looking for, it's worth clarifying their intentions. For example, are they looking to host doorways or something else entirely? Understanding their requirements is crucial in determining the best solution for their needs.

Additionally, it may be helpful to educate the client on the benefits and limitations of different types of hosting services and databases, as well as guiding them towards a solution that will meet their needs both now and in the future. This way, they can make a more informed decision and be confident in their choice.