User Tools

Site Tools


Sidebar

Dan's Wiki

DokuWiki Instructions (local) DokuWiki Manual
Site Checker (Orphans Wanted)

Edit Sidebar

projects:cantata:version3:start

This is an old revision of the document!


Cantata Version 3

Worked on Cantata Version 3 starting mid-2016. Vacillated between different ways, current writing with these tools:

  • PHP 5.6
  • Laravel
  • VirtualBox
  • Vagrant
  • PHPStorm IDE

I set up the Oracle VirtualBox software, then ran some scripts under Vagrant which sets up a virtual machine with PHP, Laravel, MySql, and a micro web server. PhpStorm connects to this virual box, and using its built-in SSH Session window, I can run command line functions against Laravel's Artisan. 9/8/2016.

Javascript

JQuery

PHP

PHP File Upload Info

Ajax

File Upload Jquery Extension

Database

Compared to Cantata2, this Cantata3 database information takes into account the move to Laravel. Also, when setting up the Model/DB Tables, noticed that the Keywords for Cantata2 only applied to the Song Level, but perhaps should have been at the File level as well. This would allow filtering or tagging for various people leading - to make it quicker to select keys, etc.

Database Namequizkidn_cantata3
User Namequizkidn_can3
  • create database quizkidn_cantata3;
  • create user 'quizkidn_can3'@'%' identified by 'cantatapass3';
  • grant all on quizkidn_cantata3.* to 'quizkidn_can3'@'%';
  • FLUSH PRIVILEGES;
  • select user from mysql.user;

User Security

Performance

Noticed that just getting a MySQL connection from my workstation to the server ivan, took over 2 seconds.

projects/cantata/version3/start.1473390562.txt.gz · Last modified: 2016/09/09 03:09 by dwheele