Development
As it should be with all programs/applications, txtSQL is constantly under construction and development. In this page you'll be able to find the work that's currently under way (towards the 4.0 final release). There aren't any manuals for this code yet, but they will be developed, it does take time, a lot of time, to come up with decent documentation from which anyone can follow. txtSQL 4.0's primary goal was to include a SQL parser and interpreter which for the most part has been accomplished (txtSQL.tokenizer.php and txtSQL.lexer.php) -- you can actually parse queries and come up with results that are passed to the txtSQL.core.php file. If you know anything about OOP (object-oriented programming) it should serve as a nice stepping stone in learning and debugging the code, which brings me to my next poin. No large project is ever accomplished by a single individual, which is why I've posted these files on the internet -- to get the collective support of people interested in helping txtSQL grow more secure and efficient. Please, please, please post bugs and fixes and whatever else you deem appropriate in the online forums
PLEASE be advised that this code is entirely developmental and should NOT be used in an active site where data loss or corruption is a route which is innaffordable.
You can read this short tutorial on how to get started with 4.0
- txtSQL.tokenizer.php - The tokenizer class - splits queries up into "tokens" and pass them onto the lexer
- txtSQL.lexer.php - Puts together "tokens" passed by the tokenizer and makes sense of them (extends txtSQL_Tokenizer)
- txtSQL.core.php - Core workhorse functions like creating/dropping tables, selecting etc. (extends txtSQL_Lexer)
- txtSQL.class.php - Main class file (extends txtSQL_Core)