Share My Creation [B4A] Firebase Notifications Alternative - Source Codes

sfsameer

Well-Known Member
Licensed User
Longtime User
Hello my dear,

Within 48 hours we will release the MySql version

*Am not suppose to share any details, but we are in the process of creating an new database engine "b4x database engine"
Will be released very soon


Thank you,
Saif
 

sfsameer

Well-Known Member
Licensed User
Longtime User
If I understand what it will be, it's a great idea
Faster, secure and 12 million records resulting in database size of 39kb only, meaning the data compression methods we used are more than amazing

The time of the select query of the 12 million records were 4 seconds (ms sql 30 minutes)

Also it can work on windows, MacOS, Linux, Android, ios or even a free php server like 000webhost (the ultimate cross platform)

I think I have shared way too much ? ?
 

cklester

Well-Known Member
Licensed User

Sorry, Saif, but after I heard you guys were doing a new database engine, I decided to try my hand at it.

So far, I have 15 million records in 37kb, and query all records only takes 2.8 seconds.

My engine works on Windows, MacOS, Linux, Android, iOS, Windows Phone, and Commodore Amiga.

However, I will never share my code, so go ahead and share yours when you are ready.

? ??
 

scsjc

Well-Known Member
Licensed User
Longtime User
Amiga2000 great computer ??????
 

cklester

Well-Known Member
Licensed User
Amiga2000 great computer ??????

Yes! I started with a VIC-20, went to Commodore 64, then Amiga 500, and, finally, Amiga 4000!

Ah, the good ol' days. Too bad the companies who owned those computers weren't able to capitalize on the superiority of their products!
 

amorosik

Expert
Licensed User

If you work in Microsoft Windows environment, surely MsSql has some points more than MySql
But apart from the technical issues, the most important thing in my opinion, is the fact that the MySql license is not clear whether it can allow free use or not, because if you go to read it you will see that the use free is bound to use it on programs for which the source code must be visible
Personally, after trying both of them, I prefer MsSql
 

Xfood

Expert
Licensed User
a great new miracle, you are truly a time traveler, a futurist. Thanks Saif you are great
 

scsjc

Well-Known Member
Licensed User
Longtime User
Yes! I started with a VIC-20, went to Commodore 64, then Amiga 500, and, finally, Amiga 4000!

Ah, the good ol' days. Too bad the companies who owned those computers weren't able to capitalize on the superiority of their products!
My beginnings were also very basic, I started with a ZXSpectrum on 1984, and then I was fortunate to have an Amiga2000 in 1988 with 3MB ram, 20MB hdd, Genlock, and many other things, Impressive for its time ???

Totally agree, it hurts that these companies did not have capital to finance and compete in the market, perhaps today the standard would not have been the PC that we all know.

 

amorosik

Expert
Licensed User

Aaaaaghhh.....
From ZxSpectrum to Amiga.... from Sinclair to Commodore.... aaaggghhhhh...... betrayal, betrayal
???
 

scsjc

Well-Known Member
Licensed User
Longtime User
Aaaaaghhh.....
From ZxSpectrum to Amiga.... from Sinclair to Commodore.... aaaggghhhhh...... betrayal, betrayal
???
Amiga was not designed by comodore ???, comodore was only the manufacturer.
Do you know that he had hidden in the rom v1.2 the name of who made the Amiga,... and comodore was not able to find it when he released the Amiga to Market? ???
 

amorosik

Expert
Licensed User

4 sec vs 1800 sec ?

If the two systems have been tested under the same conditions (same hardware that supports them, same db structure, same number of rows present, search on non-indexed fields, no other program that uses cpu, etc.) the difference seems truly exceptional.
Are both interrogable via sql type language?
Are we sure that the comparison was made under the same conditions?
 

sfsameer

Well-Known Member
Licensed User
Longtime User
4 sec vs 1800 sec ?
Yes.

Are both interrogable via sql type language?
We have change the syntax a little bit to make it easier for example, to do a left join between table 1 and table 2
B4X:
Select [Table1] and [Table2]
Left Join by [Tabel1].ID = [Table2].HeaderID

Are we sure that the comparison was made under the same conditions?
The Same Environment and The Same Server.
 

sfsameer

Well-Known Member
Licensed User
Longtime User
LEFT JOIN ON ?
is there any SQL syntax where the join is not called "ON"?
Sometimes the SQL Joins are very confusing specially if you have multiple joins in one query.
So using BY instead of ON make a big difference in understanding the query.

Also if you have noticed, the example query in my post is different from normal query, instead of "select * from" it's "Select" only
and the structure is different as well.

 

Alexander Stolte

Expert
Licensed User
Longtime User
We will see how it is then in use, I personally find the new syntax more confusing because it does not work as in traditional languages such as MSSQL, MySQL or PostgreSQL.

Good luck
 

Mashiane

Expert
Licensed User
Longtime User
Interesting...

Q. What if you just want a portion of the data in terms of particular fields?

Q. Will it be able to have offline and sync functionality?
 

sfsameer

Well-Known Member
Licensed User
Longtime User
Interesting...

Q. What if you just want a portion of the data in terms of particular fields?

Q. Will it be able to have offline and sync functionality?
1- Unlimited characters.

Currently the supported Data types :
1- Int
2- String
3- Images
4- numeric

But we are working on adding new data types, for example : Views which means you can store a layout, button, textbox, labels, etc... in the table.

2- Yes of course.

 
Cookies are required to use this site. You must accept them to continue using the site. Learn more…