Adjunct to ZXC that allows for very short syntax for queries.
Comes with a PHP-ZXC interpreter but also the main use I want it for is a browser based remote dB client that supports those kinds of short queries, as a reasonable replacement for phpmyadmin for many tasks.
Also theoretically allows javascript database queries which can allow very fast prototyping, with the string moved to the backend later since it's identical in both places.
Shoud allow for table creation/manipulation, not just data manip. Makes these kinds of tasks *way* easier. With some confirmation to make sure you're actually getting what you want.
The start of a QWE command is a prefix of two characters -- the first is the category of what you're manipulating and the second is what specifically you're doing. At the moment I have these:
?: -- select queries
?+ -- insert queries
?= -- update queries
?/ -- delete queries
#: -- show tables
#+ -- create table
#= -- alter table
#/ -- truncate table
#// -- drop table
Confirmations
Updates and deletes (as well as truncates/drops) offer a confirmation screen (y/n) as well as helpful information to prevent catastrophic mistakes. This can be counting the number of rows, showing an example of what an update will do, etc.
Confirmations can be suppressed by adding a ! to the beginning or end of the QWE statement, provided the setting for the one used is turned on.
is also used as part of a statement:
!: -- shows all confirmation settings
!+X -- turns X setting on.
!/X -- turns X setting off.
!=X -- toggles X setting.
X here can be an individual setting name, a comma-separated list, or by itself will target all of them.
Any time you're turning a confirmation off, you get a confirmation. This cannot be suppressed, for safety.
Confirmation setting names:
update
delete
truncate
drop
Anything related to individual helpful information.