Xyndravandria Dyverath composes and executes MySQL database queries programmatically. It represents a database system with PHP classes. Other classes are available to compose other parts of the queries like conditions, fields, values, limit clauses, etc. A separate class can also query database table metadata like table fields and primary keys.
Time Star is calendar-based software to make bookings, manage work, and issue quotations, job sheets, invoices, and receipts. Full e-commerce facilities, content management, and a whole range of additional work management features are available. Set reminders and get an email with the details. Place a booking by adding an event into the calendar. Manage your jobs in day, week, and month views. You can create and manage user accounts. Mark jobs as complete then set account terms for payment. Manage complete and incomplete work. Add materials / parts and suppliers to your invoices as well as 3rd party fees. Add extra information about your jobs by setting fields and uploading files and images. Check paid and unpaid customer accounts Generate quotations, job sheets, invoices, and receipts to send to your clients. Take payments online for your completed jobs. Create graphs using client, work, and financial data.
The goal of dzo is to treat application database objects the same way the application's source code is treated, with respect to development, revision control, and deployment. Dzo uses a text file that contains native create statements for all database objects and compares them against the actual database-schema. As a result, dzo creates the SQL statements needed to update the database schema (or you can let dzo execute the SQL statements directly). If your application lives in a Tomcat or Java EE application server, dzo has a servlet that controls the deployment process, inspects and executes the necessary database changes, and finally deploys the application. Dzo currently works with HSQLDB, MySQL, Oracle, PostgreSQL, and SQL Server (more to come).