Maintenance script: Created page with " === Community Driven Site Status Board === ==== Step 1: Design phase ==== ==== Step 2: Study of needed tools ==== *The backend database will be an sqlite3 database. ..."

2015-08-26T12:28:18Z

Created page with " === Community Driven Site Status Board === ==== Step 1: Design phase ==== ==== Step 2: Study of needed tools ==== *The backend database will be an sqlite3 database. ..."

New page

=== Community Driven Site Status Board ===

==== Step 1: Design phase ====

==== Step 2: Study of needed tools ====

*The backend database will be an sqlite3 database. This might not be the most suitable database for time-stamped entries but for this small size project it probably serves well.
*sqlite3 is installed on mon
*More links to usefull tutorials:
**http://freshmeat.net/articles/sqlite-tutorial
**http://souptonuts.sourceforge.net/readme_sqlite_tutorial.html
*A short overview of the commands I use in the command line sqlite3 environment
<pre>
sqlite /root/joris/CDSSB/test.db
create table t1 (t1key INTEGER PRIMARY KEY, timeStamp DATE, status TEXT, entryName TEXT, severity INTEGER);
drop table t1

.tables
.schema t1
.dump t1

insert into t1 (timeStamp,status,entryname,severity) values (date('now'),'All is fine','Joris',4);
select * from t1;
</pre>

*The frontend webpage will be written in php.
*Links with tutorials:
**http://www.w3schools.com/php
**http://zetcode.com/databases/sqlitephptutorial/
**http://www.switchonthecode.com/tutorials/php-tutorial-creating-and-modifying-sqlite-databases
**http://henryranch.net/software/ease-into-sqlite-3-with-php-and-pdo/
*Location of files and uesfull php commands
<pre>
/var/www/html/JorisTesting/CDSSB
</pre>

{{TracNotice|{{PAGENAME}}}}

CDSSB - Revision history

Maintenance script: Created page with " === Community Driven Site Status Board === ==== Step 1: Design phase ==== ==== Step 2: Study of needed tools ==== *The backend database will be an sqlite3 database. ..."