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

Groups > alt.comp.lang.php > #26 > unrolled thread

Re: PHP class based database system with some sql features(some queries)

Back to article view | Back to alt.comp.lang.php

This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by below is the oldest one visible, not the original post.

Contents

  Re: PHP class based database system with some sql features(some queries) "J.O. Aho" <user@example.net> - 2020-05-04 15:21 +0200
    Re: PHP class based database system with some sql features(some queries) kristjan1291983@gmail.com - 2020-05-04 07:27 -0700
      Re: PHP class based database system with some sql features(some queries) "J.O. Aho" <user@example.net> - 2020-05-04 17:25 +0200
      Re: PHP class based database system with some sql features(some queries) "J.O. Aho" <user@example.net> - 2020-05-04 17:29 +0200
        Re: PHP class based database system with some sql features(some queries) kristjan1291983@gmail.com - 2020-05-05 07:59 -0700
          Re: PHP class based database system with some sql features(some queries) kristjan1291983@gmail.com - 2020-05-05 08:00 -0700
          Re: PHP class based database system with some sql features(some queries) "J.O. Aho" <user@example.net> - 2020-05-05 18:19 +0200
        Re: PHP class based database system with some sql features(some queries) "J.O. Aho" <user@example.net> - 2020-05-05 18:33 +0200
          Re: PHP class based database system with some sql features(some queries) kristjan1291983@gmail.com - 2020-05-06 02:08 -0700

#26 — Re: PHP class based database system with some sql features(some queries)

On 04/05/2020 10.33, kristjan1291983@gmail.com wrote:
> SQL allowed queries:
> 
> select * from classa;
> select a from classa;
> select * from classa join classb on (classa.a=classb.c);
> select * from classa where a=abc and b=abcd;
> select * from classa where a=abc;

Great you have found a hobby, but please don't multipost the same 
message to multiple news groups, do a crosspost instead, that way 
everyone will be able of taking part of a conversation, also do not post 
the code it self, there are many good places to host the code which 
makes it easier to find the latest version, I would suggest github.com 
which is today the most popular one.

[toc] | [next] | [standalone]

#27

esmaspäev, 4. mai 2020 16:22.01 UTC+3 kirjutas J.O. Aho:
> On 04/05/2020 10.33, kristjan1291983@gmail.com wrote:
> > SQL allowed queries:
> > 
> > select * from classa;
> > select a from classa;
> > select * from classa join classb on (classa.a=classb.c);
> > select * from classa where a=abc and b=abcd;
> > select * from classa where a=abc;
> 
> Great you have found a hobby, but please don't multipost the same 
> message to multiple news groups, do a crosspost instead, that way 
> everyone will be able of taking part of a conversation, also do not post 
> the code it self, there are many good places to host the code which 
> makes it easier to find the latest version, I would suggest github.com 
> which is today the most popular one.

Yes, is will keep that in mind …
Btw have you tried it out yourself and if yes, then, what do you think of that ?

Kristjan
6861327
kristjan 12 9 1983 @ gm ail . c o m

[toc] | [prev] | [next] | [standalone]

#28

On 04/05/2020 16.27, kristjan1291983@gmail.com wrote:

> Btw have you tried it out yourself and if yes, then, what do you think of that ?
I have to say no I haven't tried your db engine, at the moment I don't 
do much PHP and the database needs I have don't fit for recreating the 
database table file each time it's updated.

-- 

  //Aho

[toc] | [prev] | [next] | [standalone]

#29

On 04/05/2020 16.27, kristjan1291983@gmail.com wrote:

> Yes, is will keep that in mind …

Seems you remove all but one listed newsgroup and destroy the 
possibility to keep a conversation between the groups.


> Btw have you tried it out yourself and if yes, then, what do you think of that ?

I have to say no I haven't tried your db engine, at the moment I don't 
do much PHP and the database needs I have don't fit for recreating the 
database table file each time it's updated.



-- 

  //Aho

[toc] | [prev] | [next] | [standalone]

#30

esmaspäev, 4. mai 2020 18:29.04 UTC+3 kirjutas J.O. Aho:
> On 04/05/2020 16.27, kristjan1291983@gmail.com wrote:
> 
> > Yes, is will keep that in mind …
> 
> Seems you remove all but one listed newsgroup and destroy the 
> possibility to keep a conversation between the groups.
>
I cannot remove newsgroups.


> 
> > Btw have you tried it out yourself and if yes, then, what do you think of that ?
> 
> I have to say no I haven't tried your db engine, at the moment I don't 
> do much PHP and the database needs I have don't fit for recreating the 
> database table file each time it's updated.
> 
> 
> 
> -- 
> 
>   //Aho

[toc] | [prev] | [next] | [standalone]

#31

teisipäev, 5. mai 2020 17:59.22 UTC+3 kirjutas kristja...@gmail.com:
> esmaspäev, 4. mai 2020 18:29.04 UTC+3 kirjutas J.O. Aho:
> > On 04/05/2020 16.27, kristjan1291983@gmail.com wrote:
> > 
> > > Yes, is will keep that in mind …
> > 
> > Seems you remove all but one listed newsgroup and destroy the 
> > possibility to keep a conversation between the groups.
> >
I cannot remove not my newsgroups.

> 
> 
> > 
> > > Btw have you tried it out yourself and if yes, then, what do you think of that ?
> > 
> > I have to say no I haven't tried your db engine, at the moment I don't 
> > do much PHP and the database needs I have don't fit for recreating the 
> > database table file each time it's updated.
> > 
> > 
> > 
> > -- 
> > 
> >   //Aho

[toc] | [prev] | [next] | [standalone]

#32

On 05/05/2020 16.59, kristjan1291983@gmail.com wrote:
> esmaspäev, 4. mai 2020 18:29.04 UTC+3 kirjutas J.O. Aho:
>> On 04/05/2020 16.27, kristjan1291983@gmail.com wrote:
>>
>>> Yes, is will keep that in mind …
>>
>> Seems you remove all but one listed newsgroup and destroy the
>> possibility to keep a conversation between the groups.
>>
> I cannot remove newsgroups.

On my posts you see I write to alt.comp.lang.php and alt.php.sql, while 
yours just have one or the other, your client (google groups) don't work 
properly.

-- 

  //Aho

[toc] | [prev] | [next] | [standalone]

#33

On 05/05/2020 11.45, kristjan1291983@gmail.com wrote:
> esmaspäev, 4. mai 2020 18:29.04 UTC+3 kirjutas J.O. Aho:
>> On 04/05/2020 16.27, kristjan1291983@gmail.com wrote:
>>
>>> Yes, is will keep that in mind …
>>
> Interesting….. My reply seems to have been deleted…….

No, it's not deleted, it's just that when you reply you reply only to 
one of the newsgroups, not both, I tend to add the missing newsgroup 
back, so if you are in the "wrong" newsgroup it may look your post is 
missing.


>>> Btw have you tried it out yourself and if yes, then, what do you think of that ?
>>
>> I have to say no I haven't tried your db engine, at the moment I don't
>> do much PHP and the database needs I have don't fit for recreating the
>> database table file each time it's updated.
>>
> How you know my dbsys is slower ?
> It takes about 10000/8 times less space.


Test 1:
Create a table with your primary key column "id" and a data column 
"name", do 10000 inserts into the table, with an increasing id number.

Test 2:
Create 3 tables, each can have a primary key column "id" and a data 
column "name", insert 100000 rows in each table (with id from 1 to 
100000 on each table) and then make a select that joins all the 3 tables 
on the id.

You can compare the time with sqlite.

-- 

  //Aho

[toc] | [prev] | [next] | [standalone]

#34

What are you trying to say? How much faster can it get ? 

teisipäev, 5. mai 2020 19:33.19 UTC+3 kirjutas J.O. Aho:
> On 05/05/2020 11.45, kristjan1291983@gmail.com wrote:
> > esmaspäev, 4. mai 2020 18:29.04 UTC+3 kirjutas J.O. Aho:
> >> On 04/05/2020 16.27, kristjan1291983@gmail.com wrote:
> >>
> >>> Yes, is will keep that in mind …
> >>
> > Interesting….. My reply seems to have been deleted…….
> 
> No, it's not deleted, it's just that when you reply you reply only to 
> one of the newsgroups, not both, I tend to add the missing newsgroup 
> back, so if you are in the "wrong" newsgroup it may look your post is 
> missing.
> 
> 
> >>> Btw have you tried it out yourself and if yes, then, what do you think of that ?
> >>
> >> I have to say no I haven't tried your db engine, at the moment I don't
> >> do much PHP and the database needs I have don't fit for recreating the
> >> database table file each time it's updated.
> >>
> > How you know my dbsys is slower ?
> > It takes about 10000/8 times less space.
> 
> 
> Test 1:
> Create a table with your primary key column "id" and a data column 
> "name", do 10000 inserts into the table, with an increasing id number.
> 
> Test 2:
> Create 3 tables, each can have a primary key column "id" and a data 
> column "name", insert 100000 rows in each table (with id from 1 to 
> 100000 on each table) and then make a select that joins all the 3 tables 
> on the id.
> 
> You can compare the time with sqlite.
> 
> -- 
> 
>   //Aho

[toc] | [prev] | [standalone]

Back to top | Article view | alt.comp.lang.php

csiph-web