Path: csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: "J.O. Aho" Newsgroups: comp.lang.php Subject: Re: Looking for relational database programmed in PHP Date: Fri, 20 Dec 2019 07:21:04 +0100 Lines: 32 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit X-Trace: individual.net hogAMFGgzo6vDs1p+1EA3g2eeulLhsOYiIQ6XWkX7ickC0o52W Cancel-Lock: sha1:YTCRCXkbWLuauKj6kTgcHKSZM1E= User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.3.0 In-Reply-To: Content-Language: en-US-large Xref: csiph.com comp.lang.php:18120 On 19/12/2019 23:33, robamman2019@gmail.com wrote: > neljapäev, 19. detsember 2019 19:29.58 UTC+2 kirjutas Jerry Stuckle: >> On 12/19/2019 11:10 AM, robamman2019@gmail.com wrote: >>> I'm looking for relational database, that doesn't need extension to be enabled in php.ini and saves data to directory and is programmed in PHP. >>> >>> Examples, that aren't what I need: "sqlite" - needs extension to be enabled. >>> "microdb" (https://morris.github.io/microdb/) - isn't relational. >> >> I doubt you'll find anything, but if you did PHP would be way too slow >> to do much of anything. There's a reason why relational databases are >> written in a compiled language. A lot of code needs to be executed even >> for the simplest of queries. >> > Yes, but I have my own reasons for that. When my webpage goes offline, I have to fast move the webpage to another place. This kind of thing would be good for browser internet games, that don't take so much space. > I am pretty sure there is one already made, so that I don't have to start programming it myself. The solution is to use plain text files in that case, they work ok as long as you are working with a relatively small quantity of data. The source code for sqlite is around 11M and it's dynamically linked, so you rewrite it in PHP you would need a larger code as sqlite is dynamically linked to other libraries which you would also need to write in PHP. Your relation database written in PHP would be slower than sqlite and would affect your site performance too. As far as I know, all webhotels who provide PHP do also provide sqlite support as it by default enabled in php.ini. -- //Aho