Based on the lexical analysis of "update," "select," "insert," and "delete" SQL statements, an automatic caching strategy is implemented. The strategy involves caching the data when executing a select operation and associating the table name contained in the SQL statement with the corresponding cached records. When executing update, insert, or delete operations, the table name from the SQL statement is extracted, and any cached records containing this table name from previous select operations are deleted. This strategy enables seamless caching without delay and eliminates the need to worry about data synchronization issues. It is particularly effective for tables with infrequent data modifications. For tables with frequent modifications, they can be ignored by configuring the strategy accordingly.

Go to Download

walterwoshid/dissect

2 Favers
38 Downloads

A set of tools for lexical and syntactical analysis written in pure PHP - Fork by WalterWoshid

Go to Download

Libraries tagged by lexical analasys

yuubit/tokenizer

hexydec/tokenise

goaop/dissect

abdulklarapl/lexer

remorhaz/lexer-runtime

kothman/lexer

ghostwriter/syntax

coco-project/sql-cache

walterwoshid/dissect