1,000,000 records = 500,000 bits ???Bits.
1,000,000 records = 500,000 bits ???Bits.
I said bits replying to your previous post which was (bytes).1,000,000 records = 500,000 bits ???
I had to look up what "clowning" meant. Seems it means "to bring ridicule upon someone". (ref)Please stop the clowning and the assumptions.
Again :I had to look up what "clowning" meant. Seems it means "to bring ridicule upon someone". (ref)
When I hear fascinating claims without any real explanation I tend to get curious. This curiousity sometimes leads to questions, so I ask them. I'm sorry you feel ridiculed when I'm asking honest questions to better understand your claims.
As for the assumptions... I imagine you're talking about me assuming you have test files for your tables? Well, it did just make sense to me. How else would you be able to make those fantastic claims on how much disk space was used? Surely you didn't just pull the numbers out of thin air.
Now, that's just plain wrong - that's not what he said.1,000,000 records = 500,000 bits ???
Half byte per row. What is each row made of... air? ?
Bits.
We have to move the blue box into the back room.
We have to move the red box into the living room.
We have to move the yellow boxes into the back room.
He has to move the blue box into the bed room now.
Yesterday, she did move the blue boxes into the back room.
There are many features that i can't discuses until we release the project, but :Bringing discussion to fruitful point.
Saif,
Can we replace the sqlite database in our B4A with your database, since it is small, we will benefit ?
I may have missed the point if you already mentioned it.
Very coolThere are many features that i can't discuses until we release the project, but :
1- Unlike SQLite, B4XDatabase can be used/modified by multiple users at the same time, where SQLite doesn't support concurrency (no more than one user can be writing to the database at the same time)
2- It can be accessed remotely and locally
3- In MS SQL the database growth is managed by MB and in our case it's managed by KB
4- A lot faster than SQLite
5- We have added 2 new features which is : Manual Commit and Automatic Commit
6- Data monitoring in real-time
7- Because it's designed and developed to be used in B4X products so we are adding a new field to the database which is (Objects) meaning you can store labels, objects, text, maps, lists, etc... and this can be used in many ways for example designing app templates where you draw the whole activity/form from the database.
There are many other features which make this database engine great.
Currently we have many ways to prevent data loss, decrease in speed and abnormal size increase, two of them are :Database Speed and Capacity are key to a great database.
My only other wish is to have a database that does not collapse, or slow down dramatically, just because you added or deleted too many records.
Reorganisation of a database periodically is the making or breaking of the database.
How do you get around Reorganisation of a Database where there are always users connected to it. (Either intentionally or unintentionally).
I have an application that adds and removes over 500,000 records a day - I am using a Microsoft Access database which dies, and doubles in size, if I dont reorganise
the database immediately after the process. The catch is, you can't reorganise an Access database if users are attached to it.
Currently I do prefer using MS SQL Server.
Thank you Guys, that sounds good here are my comments and suggestions:Hello everyone,
Couple of months ago we have talked about creating a database engine.
The idea was to create a database engine that can be :
1- Used in all B4X products
2- Faster than any database engine out there
3- select query of millions of records would take couple of milliseconds
4- real-time data changes without having to add a timer in your app, it will automatically alert you in case there was any change in the database you are connected to
5- B4X Library that initializes the connections, select, insert, update, delete, Real-Time data, etc...
6- Multi-Users
7- Query Designer
8- 10 Millions of tables and rows and the database result will result in less than 500KB file.
9- Very secure, once the connections are closed, the database will be encrypted and can't be decrypted unless you use B4XDatabase Engine.
We have finished developing this amazing project, which is a huge step for us.
We have couple of questions we would like to ask you guys to make it even better :
1- Currently we have developed the database engine as a Desktop App in B4J, Should we develop it as a Web App (B4J Web App) to make it more accessible on every type of platform (Mobile, Windows, Linux, MAC, etc...) ?
2- Should we add a cloud feature, where you can upload your B4XDatabase to our cloud services and you wouldn't need to have your own servers, just create the B4XDatabase and connect to it?
3- Current data types are (Int, Date, DateTime, String, Numbers, Files) What else would you like us to add?
If you have any feature you would like to add/modify please let us know
The B4XDatabase engine (B4Xdb.com) will be released within this month
Database Engine website : https://b4xdb.com/
Thank you,
Saif
The release date will be announced on 26-12-2021At least I think the forum members including me are interesting to be informed what about your release plan.
Stay well
Happy Christmas and Successful New YSear
Guenter
Currently no, but we will look into itIt has any sync future with other databases?
Like Mysql or MSSql