Deprecated: Return type of MediaWiki\Session\PHPSessionHandler::open($save_path, $session_name) should either be compatible with SessionHandlerInterface::open(string $path, string $name): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/session/PHPSessionHandler.php on line 181
Deprecated: Return type of MediaWiki\Session\PHPSessionHandler::close() should either be compatible with SessionHandlerInterface::close(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/session/PHPSessionHandler.php on line 196
Deprecated: Return type of MediaWiki\Session\PHPSessionHandler::read($id) should either be compatible with SessionHandlerInterface::read(string $id): string|false, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/session/PHPSessionHandler.php on line 210
Deprecated: Return type of MediaWiki\Session\PHPSessionHandler::write($id, $dataStr) should either be compatible with SessionHandlerInterface::write(string $id, string $data): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/session/PHPSessionHandler.php on line 238
Deprecated: Return type of MediaWiki\Session\PHPSessionHandler::destroy($id) should either be compatible with SessionHandlerInterface::destroy(string $id): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/session/PHPSessionHandler.php on line 344
Deprecated: Return type of MediaWiki\Session\PHPSessionHandler::gc($maxlifetime) should either be compatible with SessionHandlerInterface::gc(int $max_lifetime): int|false, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/session/PHPSessionHandler.php on line 365
Deprecated: Message implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/language/Message.php on line 138
Deprecated: MapCacheLRU implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/libs/MapCacheLRU.php on line 36
Deprecated: strcasecmp(): Passing null to parameter #1 ($string1) of type string is deprecated in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/session/CookieSessionProvider.php on line 99
Deprecated: Return type of Wikimedia\Rdbms\IResultWrapper::count() should either be compatible with Countable::count(): int, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/libs/rdbms/database/resultwrapper/IResultWrapper.php on line 39
Deprecated: Return type of Wikimedia\Rdbms\IResultWrapper::seek($pos) should either be compatible with SeekableIterator::seek(int $offset): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/libs/rdbms/database/resultwrapper/IResultWrapper.php on line 67
Deprecated: Return type of Wikimedia\Rdbms\IResultWrapper::current() should either be compatible with Iterator::current(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/libs/rdbms/database/resultwrapper/IResultWrapper.php on line 80
Deprecated: Return type of Wikimedia\Rdbms\IResultWrapper::next() should either be compatible with Iterator::next(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/libs/rdbms/database/resultwrapper/IResultWrapper.php on line 91
Deprecated: Return type of Wikimedia\Rdbms\IResultWrapper::key() should either be compatible with Iterator::key(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/libs/rdbms/database/resultwrapper/IResultWrapper.php on line 85
Deprecated: Return type of Wikimedia\Rdbms\ResultWrapper::valid() should either be compatible with Iterator::valid(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/libs/rdbms/database/resultwrapper/ResultWrapper.php on line 181
Deprecated: Return type of Wikimedia\Rdbms\ResultWrapper::rewind() should either be compatible with Iterator::rewind(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/libs/rdbms/database/resultwrapper/ResultWrapper.php on line 161
Deprecated: Return type of MediaWiki\Session\Session::count() should either be compatible with Countable::count(): int, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/session/Session.php on line 603
Deprecated: Return type of MediaWiki\Session\Session::current() should either be compatible with Iterator::current(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/session/Session.php on line 609
Deprecated: Return type of MediaWiki\Session\Session::next() should either be compatible with Iterator::next(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/session/Session.php on line 621
Deprecated: Return type of MediaWiki\Session\Session::key() should either be compatible with Iterator::key(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/session/Session.php on line 615
Deprecated: Return type of MediaWiki\Session\Session::valid() should either be compatible with Iterator::valid(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/session/Session.php on line 633
Deprecated: Return type of MediaWiki\Session\Session::rewind() should either be compatible with Iterator::rewind(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/session/Session.php on line 627
Deprecated: Return type of MediaWiki\Session\Session::offsetExists($offset) should either be compatible with ArrayAccess::offsetExists(mixed $offset): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/session/Session.php on line 643
Deprecated: Return type of & MediaWiki\Session\Session::offsetGet($offset) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/session/Session.php on line 656
Deprecated: Return type of MediaWiki\Session\Session::offsetSet($offset, $value) should either be compatible with ArrayAccess::offsetSet(mixed $offset, mixed $value): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/session/Session.php on line 666
Deprecated: Return type of MediaWiki\Session\Session::offsetUnset($offset) should either be compatible with ArrayAccess::offsetUnset(mixed $offset): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/session/Session.php on line 671
Deprecated: RawMessage implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/RawMessage.php on line 35
Deprecated: Return type of CacheTime::jsonSerialize() should either be compatible with JsonSerializable::jsonSerialize(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/json/JsonUnserializableTrait.php on line 26
Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/libs/rdbms/database/resultwrapper/IResultWrapper.php:26) in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/changes/ChannelFeed.php on line 95
Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/libs/rdbms/database/resultwrapper/IResultWrapper.php:26) in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/changes/ChannelFeed.php on line 100
Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/libs/rdbms/database/resultwrapper/IResultWrapper.php:26) in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/WebResponse.php on line 74
Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/libs/rdbms/database/resultwrapper/IResultWrapper.php:26) in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/WebResponse.php on line 74
Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/libs/rdbms/database/resultwrapper/IResultWrapper.php:26) in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/WebResponse.php on line 74
Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/libs/rdbms/database/resultwrapper/IResultWrapper.php:26) in /var/www/vhosts/sicdb.com/httpdocs/wiki/includes/WebResponse.php on line 74 https://www.sicdb.com/wiki/index.php?action=history&feed=atom&title=Software_DescriptionSoftware Description - Revision history2026-10-31T09:13:20ZRevision history for this page on the wikiMediaWiki 1.37.1https://www.sicdb.com/wiki/index.php?title=Software_Description&diff=347&oldid=prevSalkin: /* Software Components */2022-11-09T16:57:31Z<p><span dir="auto"><span class="autocomment">Software Components</span></span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 16:57, 9 November 2022</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l26">Line 26:</td>
<td colspan="2" class="diff-lineno">Line 26:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* Perform quick statistics to validate query before export</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* Perform quick statistics to validate query before export</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* Export to various file formats (.csv, .xlsx, .r (R Studio), .sqlite3, more following)</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* Export to various file formats (.csv, .xlsx, .r (R Studio), .sqlite3, more following)</div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">Import, Export, Statistics, Charts and more are expendable. Soon it will be possible to directly run python scripts!</ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Installation and running ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Installation and running ==</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The environment can be installed fully preconfigured to use in any modern browser. Refer to [[Get Started]] for further information.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The environment can be installed fully preconfigured to use in any modern browser. Refer to [[Get Started]] for further information.</div></td></tr>
</table>Salkinhttps://www.sicdb.com/wiki/index.php?title=Software_Description&diff=150&oldid=prevSalkin at 11:42, 9 October 20222022-10-09T11:42:49Z<p></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 11:42, 9 October 2022</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Introduction ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Introduction ==</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">We </del>provide a software package to simplify building up a database, browsing through data and exporting specific parts of the database in one of the supported file formats. </div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">Working with medium sized datasets like SICdb, containing billions of entries, may present a challenge to work with. Therefore we </ins>provide a software package to simplify building up a database, browsing through data and exporting specific parts of the database in one of the supported file formats. </div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>To install our software refer to the [[Get Started]] page.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>To install our software refer to the [[Get Started]] page.</div></td></tr>
</table>Salkinhttps://www.sicdb.com/wiki/index.php?title=Software_Description&diff=146&oldid=prevSalkin: Created page with "== Introduction == We provide a software package to simplify building up a database, browsing through data and exporting specific parts of the database in one of the supported file formats. To install our software refer to the Get Started page. == Software Components == === MySQL Server Community Edition === MySQL is an open-source relational database managment system.<ref>https://en.wikipedia.org/wiki/MySQL</ref> === phpMyAdmin === PhpMyAdmin is one of the..."2022-10-09T10:52:58Z<p>Created page with "== Introduction == We provide a software package to simplify building up a database, browsing through data and exporting specific parts of the database in one of the supported file formats. To install our software refer to the <a href="/Documentation/Get_Started" title="Get Started">Get Started</a> page. == Software Components == === MySQL Server Community Edition === MySQL is an open-source relational database managment system.<ref>https://en.wikipedia.org/wiki/MySQL</ref> === phpMyAdmin === PhpMyAdmin is one of the..."</p>
<p><b>New page</b></p><div>== Introduction ==<br />
<br />
We provide a software package to simplify building up a database, browsing through data and exporting specific parts of the database in one of the supported file formats. <br />
<br />
To install our software refer to the [[Get Started]] page.<br />
<br />
== Software Components ==<br />
<br />
=== MySQL Server Community Edition ===<br />
<br />
MySQL is an open-source relational database managment system.<ref>https://en.wikipedia.org/wiki/MySQL</ref> <br />
<br />
=== phpMyAdmin ===<br />
<br />
PhpMyAdmin is one of the most popular open source MySQL administration tools.<ref>https://en.wikipedia.org/wiki/PhpMyAdmin</ref><br />
<br />
=== RooDataServer ===<br />
<br />
[[RooDataServer]] is the software we created to import, view and export data from a relational dataset like SICdb. <br />
<br />
==== Core Features ====<br />
* Import the dataset<br />
* Create and edit queries using predefined fields<br />
* Perform quick statistics to validate query before export<br />
* Export to various file formats (.csv, .xlsx, .r (R Studio), .sqlite3, more following)<br />
<br />
== Installation and running ==<br />
The environment can be installed fully preconfigured to use in any modern browser. Refer to [[Get Started]] for further information.</div>Salkin