B4XDatabase

Status
Not open for further replies.

sfsameer

Well-Known Member
Licensed User
Longtime User
i assume function, trigger, (store) procedure and (job) scheduler will be available on your db engine too...
Currently version contains :
1- Stored Procedures
2- Functions

But we will add the other functions as well
 

amorosik

Expert
Licensed User
Sincere congratulations on the new project that will be released Point 4 seems to me of particular interest, and brings the proposed system closer to the functionalities available only with a few other products such as Firebase or Mqtt systems

I see in point 3 particular emphasis on the speed of extracting information from the database, but are you talking about searches on non-indexed fields?

Will there be triggers to let the database engine execute functions directly?
 

sfsameer

Well-Known Member
Licensed User
Longtime User
Sincere congratulations on the new project that will be released Point 4 seems to me of particular interest, and brings the proposed system closer to the functionalities available only with a few other products such as Firebase or Mqtt systems

I see in point 3 particular emphasis on the speed of extracting information from the database, but are you talking about searches on non-indexed fields?

Will there be triggers to let the database engine execute functions directly?
1-There is an ingredient we can't disclose because it's our secret source as they say, but we have developed a way to speed up the process of selecting a query on both indexed and non-indexed fields, even if the query contains many 'WHERE' conditions.

2- Currently no, but we will add it to the engine
 

amorosik

Expert
Licensed User
A DBaaS product could be useful. You'll be competing with Amazon, right? Microsoft? Google? :oops: 😁

There really isn't much to laugh about
As you well know, Firebase was acquired by Google from Envolve, a startup born in 2011, and therefore we are not talking about something impossible to achieve.
Information technology is evolving much faster than what we are able to use, personally
I think that even if we do not realize it, we are in the golden age of information technology
The engine of a database, is a fundamental component in any information system, and therefore I would not be surprised that the project could have an echo greater than what we expect.
 

amorosik

Expert
Licensed User
1-There is an ingredient we can't disclose because it's our secret source as they say, but we have developed a way to speed up the process of selecting a query on both indexed and non-indexed fields, even if the query contains many 'WHERE' conditions.

I believe this is one of the key points for any database engine, optimizing queries and using indexes where possible
So I understand that not all of the code will be released as a source, do I understand correctly?
 

sfsameer

Well-Known Member
Licensed User
Longtime User
I believe this is one of the key points for any database engine, optimizing queries and using indexes where possible
So I understand that not all of the code will be released as a source, do I understand correctly?
None of the codes will be released, it will be released as a database engine.
an EXE and a cloud service.
 

sfsameer

Well-Known Member
Licensed User
Longtime User
Ah ok, thanks for the clarification. So only the tool to design/manage is Windows (or cloud), the database itself (quering, CRUD) can be used on all platforms if I understand correctly.
Exactly, it can be used on B4X products using a library we built that communicates with the database.

This type of project requires a huge documentation which we are creating at the moment.
 

amorosik

Expert
Licensed User
Exactly, it can be used on B4X products using a library we built that communicates with the database.
This type of project requires a huge documentation which we are creating at the moment.

Only for B4x ?
Not for other developer enviroment (dot net, odbc, vba, flutter, ecc ...) ?
 

Hamied Abou Hulaikah

Well-Known Member
Licensed User
Longtime User
@sfsameer It is better to direct your efforts for useful projects like your's existing projects, This kind of project is dead from now! Yes we know you are brilliant man, but you should adjust your direction carefully, time is going from your age man :)
 

sfsameer

Well-Known Member
Licensed User
Longtime User
@sfsameer It is better to direct your efforts for useful projects like your's existing projects, This kind of project is dead from now! Yes we know you are brilliant man, but you should adjust your direction carefully, time is going from your age man :)
I usually don't respond to these type of posts but hey why not.
1- We are already releasing updates on our projects and new updates are coming very soon this week as well.
2- "This kind of project is dead from now", we didn't even release it yet and it's dead?

Never underestimate new ideas, B4X came from a question started by erel stating :
What do you think about adding support for Android devices?
Do you plan to do Android development?

I would appreciate any feedback...

And after 11 years, here we all are...

 

Mashiane

Expert
Licensed User
Longtime User
Awesome. My question would be on offline and online sync functionality.

I am using couchdb for offline web apps which have a functionality to sync when online. Off course this is a a nosql approach, no possibility of running sql queries or joins as it's merely like key value pairs. However will an awesome rest api, they say it's like Mongo.

Also, the dB engine you will release will only work on vps environments and not shared hosting?
 

cd1001

Member
Licensed User
Longtime User
I strongly disagree, that this effort might be not worth it. IMHO is one reason for the pending breakthrough of B4X as a widespread tool it’s lacking database-building-features. I could write a whole essay, why I think so. Here is a try of a shortened version: B4X-Solutions need to become the new Access-Databases in corporate environments. Even though the IT-departments don’t like it and always want to get rid of them, there is a lot ‎of or‎‎ga‎‎nizat‎‎ion‎‎al ‎‎‎‎inertia‎ of these Apps. They are built by Non-It-People for their specific needs, often because of the lack of inhouse-support from the IT-department and the lack of money. This solutions are stubborn beasts. And this is the angle, where B4X must sneak it’s way into a zone, where professionals can’t deny it. What do citizen developers need? A database. Almost always. If it’s possible, to mimic the MS-Access-Environment in some way, then a massive crowd of part-time-developers, who are suffering from the abandonment of Microsoft of it’s famous desktop-db today, would switch the train. For them and for newbies is an integrated IDE with database-building-functionalities much more comprehensible than building a db with separate (costly) tools. As I see it, Saif proposed a solution in this direction. I’d say go for it!

My answers to the questions:
  • The Web App-Approach would bypass corporate-installation-policies
  • Could be both made possible?
  • Currency-Type would be nice
Best

Carsten
 

amorosik

Expert
Licensed User
@sfsameer It is better to direct your efforts for useful projects like your's existing projects, This kind of project is dead from now! Yes we know you are brilliant man, but you should adjust your direction carefully, time is going from your age man :)

A db engine is not simple useful, is a a super-useful project !!!
Is a brick that EVERY software need
In addition, I don't know if you have read the features, but I would like to point out that a client can be 'notified' of the changes that have occurred in the data
How many other db servers do you know that allow this functionality?
The central point is the functions that the system must allow to create
If the functions are the same as SqlLite or MySql or Sql Server, surely you will not find interest.
But if the characteristics are different it is possible, I would say augurable, that the project can spread well beyond the audience of users of this forum
 

AnandGupta

Expert
Licensed User
Longtime User
Hi Saif

Congratulation!

You have shown again that you are not afraid of stepping in uncharted terrain and even holding the bull by the horn.

Many programmers will not even dream forget think of making a database engine when financially mighty MS has de-facto standard. You have achieved something which makes you stand closer to Erel (in my humble opinion).

Both of you have helped the development community with your expertise in more ways than we can say Thank You. 🙏
 
Status
Not open for further replies.
Top