..:: AsmBB ::..: Mysql support?
<img src="https://board.asm32.info/images/title.svg" alt="Title img">
<h1>AsmBB is ultrafast web forum, written entirely in assembly language. This site is the official support development forum and demo/test installation.</h1>
tag:board.asm32.info,2018-03-06:Thread2492018-12-28T19:19:45Zjohnfound on Mysql support?tag:board.asm32.info,2018-03-06:Post157342018-12-28T19:19:45Z
<blockquote><header>kari</header><p>A like option will be appreciated so i can like his post about conversion <img class="inline" src="/templates/Urban+Sunrise/_images/emoticons/lol.gif" alt=":-D" />
</p></blockquote>
<p>+1 <img class="inline" src="/templates/Urban+Sunrise/_images/emoticons/wink.gif" alt=";)" />
</p>
<p>I am working right now on a conversions scripts for the old versions of phpbb (circa v2.0) and will publish them soon.
</p>
<p>The conversion procedure is not pretty complex, but somehow boring <img class="inline" src="/templates/Urban+Sunrise/_images/emoticons/sad.gif" alt=":-(" /> and consists of several steps:
</p>
<ol type=""><li><p>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.
</p></li>
<li><p>Insert into this database all the attached files (if stored as a files, like in phpbb) because AsmBB keeps the attachments inside the database.
</p></li>
<li><p>Create new empty AsmBB forum.
</p></li>
<li><p>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.
</p></li>
</ol>
johnfoundkari on Mysql support?tag:board.asm32.info,2018-03-06:Post157332018-12-28T17:13:46Z
<p>A like option will be appreciated so i can like his post about conversion <img class="inline" src="/templates/Urban+Sunrise/_images/emoticons/lol.gif" alt=":-D" /> </p>
karijohnfound on Mysql support?tag:board.asm32.info,2018-03-06:Post156922018-11-24T15:45:18Z
<blockquote><header>ganuonglachanh</header><p>Thanks for the Sqlite tips, my current forum have 20 GB data in mysql, will try to convert to ASMBB to test <img class="inline" src="/templates/Urban+Sunrise/_images/emoticons/rofl.gif" alt="rofl" />
</p></blockquote>
<p>This would be a really great contribution for the project, especially if you share the conversion scripts!
</p>
<p>The AsmBB database structure is here: <a href="https://asm32.info/fossil/repo/asmbb/artifact/3beb304f3e2b781a">source/create.sql</a> and don't hesitate to ask, if something is not clear enough.
</p>
johnfoundganuonglachanh on Mysql support?tag:board.asm32.info,2018-03-06:Post156892018-11-24T15:34:54Z
<blockquote><header>johnfound</header><blockquote><header>ganuonglachanh</header><p>Any benchmark that ASMBB can handle 10k users at the same time with read and write post?
</p></blockquote>
<p>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.
</p>
<p>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.
</p>
</blockquote>
<p>Thanks for the Sqlite tips, my current forum have 20 GB data in mysql, will try to convert to ASMBB to test <img class="inline" src="/templates/Urban+Sunrise/_images/emoticons/rofl.gif" alt="rofl" />
</p>
ganuonglachanh johnfound on Mysql support?tag:board.asm32.info,2018-03-06:Post156852018-11-24T09:55:00Z
<blockquote><header>ganuonglachanh</header><p>Any benchmark that ASMBB can handle 10k users at the same time with read and write post?
</p></blockquote>
<p>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.
</p>
<p>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.
</p>
johnfoundganuonglachanh on Mysql support?tag:board.asm32.info,2018-03-06:Post156812018-11-24T07:47:53Z
<blockquote><header>johnfound</header><blockquote><header>ganuonglachanh</header><p>Hi, I came here from flarum forum.
</p>
<p>Can you provide support for mysql Database?
</p>
<p>Thank you!
</p></blockquote>
<p>Well, no, it is not even planned.
</p>
<p>And why? MySQL is a client-server database, that need to be specially installed and managed.
</p>
<p>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.
</p>
</blockquote>
<p>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.
</p>
<p>Any benchmark that ASMBB can handle 10k users at the same time with read and write post?
</p>
<p>Thanks!
</p>
ganuonglachanh johnfound on Mysql support?tag:board.asm32.info,2018-03-06:Post156792018-11-24T07:16:50Z
<blockquote><header>ganuonglachanh</header><p>Hi, I came here from flarum forum.
</p>
<p>Can you provide support for mysql Database?
</p>
<p>Thank you!
</p></blockquote>
<p>Well, no, it is not even planned.
</p>
<p>And why? MySQL is a client-server database, that need to be specially installed and managed.
</p>
<p>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.
</p>
johnfoundganuonglachanh on Mysql support?tag:board.asm32.info,2018-03-06:Post156742018-11-24T03:56:37Z
<p>Hi, I came here from flarum forum.
</p>
<p>Can you provide support for mysql Database?
</p>
<p>Thank you!</p>
ganuonglachanh