Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.php > #18120

Re: Looking for relational database programmed in PHP

Path csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From "J.O. Aho" <user@example.net>
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 <h637ihFaea8U1@mid.individual.net> (permalink)
References <bb6ab77d-df8a-49e5-bd79-a467cf81ae57@googlegroups.com> <qtgc2g$f29$1@jstuckle.eternal-september.org> <eb202ee0-3be6-4ed0-ac3c-d1820e304d68@googlegroups.com>
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 <eb202ee0-3be6-4ed0-ac3c-d1820e304d68@googlegroups.com>
Content-Language en-US-large
Xref csiph.com comp.lang.php:18120

Show key headers only | View raw


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

Back to comp.lang.php | Previous | NextPrevious in thread | Next in thread | Find similar | Unroll thread


Thread

Looking for relational database programmed in PHP robamman2019@gmail.com - 2019-12-19 08:10 -0800
  Re: Looking for relational database programmed in PHP Jerry Stuckle <jstucklex@attglobal.net> - 2019-12-19 12:30 -0500
    Re: Looking for relational database programmed in PHP robamman2019@gmail.com - 2019-12-19 14:33 -0800
      Re: Looking for relational database programmed in PHP Jerry Stuckle <jstucklex@attglobal.net> - 2019-12-19 17:49 -0500
        Re: Looking for relational database programmed in PHP robamman2019@gmail.com - 2019-12-20 09:37 -0800
          Re: Looking for relational database programmed in PHP Jerry Stuckle <jstucklex@attglobal.net> - 2019-12-20 16:51 -0500
            Re: Looking for relational database programmed in PHP robamman2019@gmail.com - 2019-12-21 05:25 -0800
              Re: Looking for relational database programmed in PHP Jerry Stuckle <jstucklex@attglobal.net> - 2019-12-21 17:48 -0500
                Re: Looking for relational database programmed in PHP Kristjan Robam <robamman2019@gmail.com> - 2019-12-22 00:20 -0800
                Re: Looking for relational database programmed in PHP Jerry Stuckle <jstucklex@attglobal.net> - 2019-12-22 10:05 -0500
              Re: Looking for relational database programmed in PHP Arno Welzel <usenet@arnowelzel.de> - 2019-12-22 18:04 +0100
                Re: Looking for relational database programmed in PHP robamman2019@gmail.com - 2019-12-22 10:10 -0800
      Re: Looking for relational database programmed in PHP "J.O. Aho" <user@example.net> - 2019-12-20 07:21 +0100
        Re: Looking for relational database programmed in PHP robamman2019@gmail.com - 2019-12-20 09:44 -0800
          Re: Looking for relational database programmed in PHP "J.O. Aho" <user@example.net> - 2019-12-20 20:28 +0100
            Re: Looking for relational database programmed in PHP robamman2019@gmail.com - 2019-12-21 05:20 -0800
              Re: Looking for relational database programmed in PHP "J.O. Aho" <user@example.net> - 2019-12-22 15:35 +0100
            Re: Looking for relational database programmed in PHP Jerry Stuckle <jstucklex@attglobal.net> - 2019-12-21 17:50 -0500
              Re: Looking for relational database programmed in PHP robamman2019@gmail.com - 2019-12-22 00:24 -0800
  Re: Looking for relational database programmed in PHP kristjanise129@gmail.com - 2020-03-13 09:50 -0700
    Re: Looking for relational database programmed in PHP Jerry Stuckle <jstucklex@attglobal.net> - 2020-03-13 14:33 -0400
      Re: Looking for relational database programmed in PHP kristjanise129@gmail.com - 2020-03-13 11:58 -0700
        Re: Looking for relational database programmed in PHP "J.O. Aho" <user@example.net> - 2020-03-13 20:09 +0100
          Re: Looking for relational database programmed in PHP robamman2020@hotmail.com - 2020-03-13 23:02 -0700
        Re: Looking for relational database programmed in PHP Jerry Stuckle <jstucklex@attglobal.net> - 2020-03-13 18:19 -0400
          Re: Looking for relational database programmed in PHP robamman2020@hotmail.com - 2020-03-13 23:04 -0700
        Re: Looking for relational database programmed in PHP Arno Welzel <usenet@arnowelzel.de> - 2020-03-14 13:21 +0100
          Re: Looking for relational database programmed in PHP Kristjan Robam <robamman2020@hotmail.com> - 2020-03-14 09:26 -0700
  Re: Looking for relational database programmed in PHP Kristjan Robam <robamman2020@hotmail.com> - 2020-03-19 11:43 -0700
  Re: Looking for relational database programmed in PHP Kristjan Robam <robamman2020@hotmail.com> - 2020-03-19 13:16 -0700
  Re: Looking for relational database programmed in PHP Kristjan Robam <robamman2020@hotmail.com> - 2020-03-20 02:31 -0700
  Re: Looking for relational database programmed in PHP Kristjan Robam <robamman2020@hotmail.com> - 2020-03-20 05:13 -0700
  Re: Looking for relational database programmed in PHP Kristjan Robam <robamman2020@hotmail.com> - 2020-03-20 08:09 -0700
  Includable simple object based relational php database, that saves data to files and uses only 1 file (the database system php file) Kristjan Robam <robamman2020@hotmail.com> - 2020-03-21 11:45 -0700
  Re: Looking for relational database programmed in PHP Kristjan Robam <robamman2020@hotmail.com> - 2020-03-21 23:29 -0700
    Simple object based php database system, that saves data to files and needs only 1 php file(the system php file) Kristjan Robam <robamman2020@hotmail.com> - 2020-03-24 09:06 -0700
  Re: Looking for relational database programmed in PHP Kristjan Robam <robamman2020@hotmail.com> - 2020-03-24 22:46 -0700
    Re: Looking for relational database programmed in PHP Kristjan Robam <robamman2020@hotmail.com> - 2020-03-26 01:16 -0700
      Re: Looking for relational database programmed in PHP robamman2020@hotmail.com - 2020-03-28 08:21 -0700
        Re: Looking for relational database programmed in PHP Luuk <luuk34@gmail.com> - 2020-03-28 17:39 +0100
          Re: Simple object based relational database system, that saves data to files and is includable(php file) robamman2020@hotmail.com - 2020-03-29 08:46 -0700
            Re: Simple object based relational php database system, that saves data to files and is includable(php file) robamman2020@hotmail.com - 2020-03-29 08:52 -0700
              Re: Simple object based relational php database system, that saves data to files and is includable(php file) Luuk <luuk34@gmail.com> - 2020-03-30 20:02 +0200
                Re: Simple object based relational php database system, that saves data to files and is includable(php file) Allodoxaphobia <trepidation@example.net> - 2020-04-01 02:49 +0000
                Re: Simple object based relational php database system, that saves data to files and is includable(php file) robamman2020@hotmail.com - 2020-03-31 23:16 -0700
                Re: Simple object based relational php database system, that saves data to files and is includable(php file) Arno Welzel <usenet@arnowelzel.de> - 2020-04-01 16:47 +0200
            Re: Simple object based relational database system, that saves data to files and is includable(php file) Jim H <invalid@invalid.invalid> - 2020-03-30 18:16 +0000
              Re: Simple object based relational database system, that saves data to files and is includable(php file) Arno Welzel <usenet@arnowelzel.de> - 2020-03-31 11:59 +0200
                Re: Simple object based relational database system, that saves data to files and is includable(php file) robamman2020@hotmail.com - 2020-03-31 23:15 -0700
                Re: Simple object based relational database system, that saves data to files and is includable(php file) Arno Welzel <usenet@arnowelzel.de> - 2020-04-01 16:48 +0200
                Re: Simple object based database system, that saves data to files and is includable(php file) robamman2020@hotmail.com - 2020-04-01 10:03 -0700

csiph-web