- Jun 6, 2020
- 11,559
- 4,422
i have a problem with a REST Api i aim building in B4j that i am thinking on how to solve for a while and i cannot find an efficient way.
so i have many entries that i read from the DB (mysql/sqlite) and i would like to show it on the website.
the problem is this:
it is a statistic collection of the use and i collect all data and save it inside a list (blob type) that is associated to a user in the DB.
first i saved every entry as a new line in the DB but then i was thinking that this table will get very fast very huge so i decided to store that data in a LIST and always update that list only that is associated to a user and now it is only a single line in the db but i cannot read from it directly and perform queries because it is a blob type so i have to read the list and do all logic in b4j inside.
so i will give an example.
i have many users that are from a specific country now i want to group the users by country and show them sorted in a table.
in pure sql i would do it...
so i have many entries that i read from the DB (mysql/sqlite) and i would like to show it on the website.
the problem is this:
it is a statistic collection of the use and i collect all data and save it inside a list (blob type) that is associated to a user in the DB.
first i saved every entry as a new line in the DB but then i was thinking that this table will get very fast very huge so i decided to store that data in a LIST and always update that list only that is associated to a user and now it is only a single line in the db but i cannot read from it directly and perform queries because it is a blob type so i have to read the list and do all logic in b4j inside.
so i will give an example.
i have many users that are from a specific country now i want to group the users by country and show them sorted in a table.
in pure sql i would do it...
برای دیدن لینک ها باید ثبت نام کنید
برای دیدن لینک ها باید ثبت نام کنید