Logo Squiz Matrix 5 Documentation

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