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 via changing the setting on it.
!: -- 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.
Any data that comes in is stored in JS and can be worked with via the command line (and the FGH syntax in ASD).
This data can then go back into the database in various ways, update the existing database, or get spit out as json or some other format (should be customizable).
You should be able to convert QWE into ZXC/PHP syntax. This allows for using QWE as an engine for rapid prototyping, or even using it as such in JS (granted ASD is probably a better way to make something).
