Logo Squiz Matrix Community

Matrix SQL Client

Last Updated: 17 Jan 2020

The matrixsqlclient.php script initiates an interactive database terminal in PHP to run commands against the Matrix database.

This can be used as an alternative to the native PostgreSQL psql and Oracle SQL*Plus clients.

This script is located in the /scripts directory and requires only one parameter, the system root.

An example usage of this script is shown below:

$ php matrixsqlclient.php [system_root]
 
Welcome to matrixsqlclient (version 1.01, r108), the interactive database terminal in PHP.

You are now connected.
Database type: oci.

localhost/matrix=# select * from sq_ast_attr_val where assetid = '7';
 assetid | attrid | contextid | custom_val | use_default  
---------+--------+-----------+------------+------------- 
 7       | 672    | 0         | Public     | 1            
 7       | 676    | 0         | User       | 1            
(2 rows)

localhost/matrix=# \timing
Timing is on
localhost/matrix=# select count(*) from sq_internal_msg:
 count (*)
----------
 457622
(1 row)

Time:  2329.879 ms

Previous Chapter Next Chapter

Server Administrator

Chapters

  1. Software Configuration Files
  2. Pre-Uploading Files
  3. Creating a robots.txt file
  4. Upgrade Script
  5. Maintenance Tasks
  6. Memcache Configuration
  7. Redis Configuration
  8. Annotated main.inc
  9. Squiz Matrix Script Index
  10. Import/Export Scripts
  11. Move Assets Scripts
  12. System Integrity Scripts
  13. System Management Scripts
  14. Remove Assets Scripts
  15. Backup Script
  16. Purge Trash Script
  17. Recreate Link Tree Script
  18. Remove Internal Message Script
  19. Add/Remove URL Script
  20. Replace URL Script
  21. Reset Root Password Script
  22. Rollback Management Script
  23. Session Cleanup Script
  24. System Move Update Script
  25. System Parse Design Scripts
  26. Publish Static Content Script
  27. System Check Script
  28. Matrix SQL Client
  29. Update LDAP Bridge References Script

Send Feedback

Noticed an error?
Want to suggest an improvement?

Let Us Know

The Latest

Feedback

Let Us Know What You Think

Let us know if you spot any errors or if you have any ideas on how we can improve the Matrix Community Website.

Contact Squiz for Demo

Let us show you the true power of Squiz Matrix by giving you a personalised demonstration.

Contact Squiz