▄▄             ▄▄▄  ▄▄▄ Power
█  █ ▄▄▄▄ ▄▄▄▄▄ █  █ █  █
█▄▄█ █▄▄▄ █ █ █ █▀▀▄ █▀▀▄
█  █ ▄▄▄█ █ █ █ █▄▄▀ █▄▄▀

Login
Register
/ aa about.it ad amd64 and.who api asm asmbb asmbb.features authentication bbcode best bugs cares chat common debian deck design dll docker email embed fast feature files fossil fresh.ide friendly gamedev heap help hiawatha i18n ideas incredible interop learning libfresh limit links linux mailing.list meme meta.http-equiv minimag money mysql neo nginx numbers orly os outage pass password post-by-email programmers programming proile read-by-email resources safety script.alert.xss secret seo skins sodom source sourcecode subdirectory subforum support tags templates test test123 type very.ugly video work xss игнат котики парола русский тест уеб.програмиране хабр.наполеон
Categories Threads

Mysql support? RSS

Hi, I came here from flarum forum.

Can you provide support for mysql Database?

Thank you!

ganuonglachanh

Hi, I came here from flarum forum.

Can you provide support for mysql Database?

Thank you!

Well, no, it is not even planned.

And why? MySQL is a client-server database, that need to be specially installed and managed.

SQLite on the other hand is small, fast, does not need any installation procedures and will work on shared hosting without request and bandwidth limits.

johnfound
ganuonglachanh

Hi, I came here from flarum forum.

Can you provide support for mysql Database?

Thank you!

Well, no, it is not even planned.

And why? MySQL is a client-server database, that need to be specially installed and managed.

SQLite on the other hand is small, fast, does not need any installation procedures and will work on shared hosting without request and bandwidth limits.

Thanks for the reply, I still concern about whether Asmbb can handle multi user with Sqlite, multi read and write to the same file cause performance issues.

Any benchmark that ASMBB can handle 10k users at the same time with read and write post?

Thanks!

ganuonglachanh

Any benchmark that ASMBB can handle 10k users at the same time with read and write post?

There is no benchmark, but with the appropriate hardware it is probably possible. Notice, that SQLite performance is often underestimated. In WAL mode and after some synchronization options switched off (because not needed when working on a web server) it performs pretty quick.

Although I can hardly imagine web forum with 10K users posting simultaneously. At least they need first to read the previous post in order to answer. Such posts will be one big mess and pretty hard for following and reading, so most of the users will leave such a forum.

johnfound
ganuonglachanh

Any benchmark that ASMBB can handle 10k users at the same time with read and write post?

There is no benchmark, but with the appropriate hardware it is probably possible. Notice, that SQLite performance is often underestimated. In WAL mode and after some synchronization options switched off (because not needed when working on a web server) it performs pretty quick.

Although I can hardly imagine web forum with 10K users posting simultaneously. At least they need first to read the previous post in order to answer. Such posts will be one big mess and pretty hard for following and reading, so most of the users will leave such a forum.

Thanks for the Sqlite tips, my current forum have 20 GB data in mysql, will try to convert to ASMBB to test rofl

ganuonglachanh

Thanks for the Sqlite tips, my current forum have 20 GB data in mysql, will try to convert to ASMBB to test rofl

This would be a really great contribution for the project, especially if you share the conversion scripts!

The AsmBB database structure is here: source/create.sql and don't hesitate to ask, if something is not clear enough.

A like option will be appreciated so i can like his post about conversion :-D

kari

A like option will be appreciated so i can like his post about conversion :-D

+1 ;)

I am working right now on a conversions scripts for the old versions of phpbb (circa v2.0) and will publish them soon.

The conversion procedure is not pretty complex, but somehow boring :-( and consists of several steps:

  1. Create SQLite database with the same scheme as the original database and copy all information into it. The main problem here is the differences between MySQL and SQLite syntax and the buggy conversion scripts. I have written a special tool for converting the syntax.

  2. Insert into this database all the attached files (if stored as a files, like in phpbb) because AsmBB keeps the attachments inside the database.

  3. Create new empty AsmBB forum.

  4. From the sqlite console in AsmBB, execute the conversion script. The script must be executed from AsmBB console, because it uses several user defined SQL functions that are missing from the standard SQLite.

Categories Threads

Mysql support? RSS

AsmBB v2.6 (check-in: f15fadce65c1fa6d); SQLite v3.28.0 (check-in: 884b4b7e502b4e99);

©2016..2018 John Found; Licensed under EUPL.
Powered by Assembly language
Created with Fresh IDE

Icons are made by Egor Rumyantsev, vaadin and icomoon from www.flaticon.com