MariaDB Foundation

Mentors: Student: Alan Cueva

<p>The objective of this project is to create a new string formatting function, similar to printf in C and format in Python, in MariaDB to avoid complex select statements full of CONCAT() and FORMAT() functions.</p> <p>The idea of this function is to format each field with existing formatting functions available in MariaDB, so the syntax has to be designed in a smart way to easily accommodate future additions.</p>

Mentors: Student: michaeokoko

<p>Histograms in databases are compact summaries of the data distribution in a column. They are usually used by the query optimizer on non-indexed columns to produce efficient query plans, which then determine how many rows are read during query execution.</p> <p>This project aims to:</p> <ul> <li>Add support for storing precise histogram bucket bounds (similar to PostgreSQL and MySQL).</li> <li>Switch the MariaDB histogram storage to JSON which will in turn enable other histogram formats such as most-common-values (MCV), allow DBAs to examine the histograms on their own, and improve the overall histogram precision.</li> </ul>

Mentors: Student: xing-zhi jiang

<p>The main goal of this project is to create a component that has a clear API that can provide autocomplete feature for the jupyter kernel - mariadb_kernel. And also I hope that component can be easily integrated with not just jupyter, but also VSCode and Atom … etc popular editor. The main feature has two:</p> <ol> <li>can get the latest MariaDB keywords and functions for autocompletion. (implement new table in MariaDB's information schema, and can use SQL command to get the information)</li> <li>provide an introspection feature that can inspect the word's info and some real data.</li> </ol> <p>And this project autocompletion feature is based on mycli's autocompletion engine. Then do some enhancement on that. Such as:</p> <ol> <li>Database suggestion before 「.」. Ex: 「insert into db_name_to_be_completed.table_name VALUES (...) 」</li> <li>add global and session variable suggestions</li> <li>can suggest system default database, table, column. Ex: add column suggest for system table like mysql.user.</li> <li>Autocompletion about database_name.table_name_to_be_completed could suggest the table, which not in the currently selected database</li> <li>fix some bugs related to the word of the user is the column name and also is the keyword</li> </ol>

Mentors: Student: Vladislav Kakurin

<p>Development and implementation new kind of io_cache for optimization's purposes</p>

Mentors: Student: Kartik Soneji

<p>This project aims to remove the compile time dependencies on compression libraries and defer them to run time.<br> Right now, the MariaDB server needs all supported libraries to be preset during startup.<br> For example, the Ubuntu build (<code>MariaDB: 10.3.22</code>) only supports <code>LZ4</code>, and <code>Snappy</code>. The server <em>can</em> use other libraries, like <code>LZMA</code> and <code>BZip2</code>, but needs to be recompiled.<br> Instead, we can load libraries dynamically at runtime, so using a new library is as simple as installing a package.</p>