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
Server Administrator
Chapters
- Software Configuration Files
- Creating a robots.txt file
- Upgrade Script
- Maintenance Tasks
- Memcache Configuration
- Redis Configuration
- Annotated main.inc
- Squiz Matrix Script Index
- Import/Export Scripts
- Move Assets Scripts
- System Integrity Scripts
- System Management Scripts
- Remove Assets Scripts
- Backup Script
- Purge Trash Script
- Recreate Link Tree Script
- Remove Internal Message Script
- Add/Remove URL Script
- Replace URL Script
- Reset Root Password Script
- Rollback Management Script
- Session Cleanup Script
- System Parse Design Scripts
- Publish Static Content Script
- System Check Script
- Matrix SQL Client
- Update LDAP Bridge References Script
The Latest
Tutorials
- 02 Jul 2019
- 28 May 2019
- 30 Jul 2018
- 12 Jul 2018
-
How To Create an Upcoming Events Listing Using a Calendar Search Page
18 Jun 2018 - 19 Apr 2018
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.