300x250 AD TOP

Search This Blog

Paling Dilihat

  • RISC-V Linux on ESP32
    RISC-V Linux on ESP32
    I've been playing with the idea of running linux on ESP32 since the first days I've met its more robust module, the WROVER-B, on pap...
  • LVGL ESP32 and Desktop Development Walkthrough
    LVGL ESP32 and Desktop Development Walkthrough
    UI for Embedded is always a hassle, find the right MCU, find the right Display, connect the right wires and that's even before writing t...
  • Embedding QuickJS in your Projects
    Embedding QuickJS in your Projects
    QuickJS is small and embeddable Javascript engine made by the famous Fabrice Bellard , it supports ES2020 specifications and made available...
  • Unit Testing with ESP32 and PlatformIO
    Unit Testing with ESP32 and PlatformIO
    Writing Quality Code and Tests usually goes hand in hand, some find it more productive to write code and then write tests for it and others,...
  • Using the ILI9488
    Using the ILI9488
    The ILITEK ILI9488 is one of the larger and cheaper SPI displays available to the maker community,, available in 3.5" and 4". How...
  • A Million Times
    A Million Times
    A while ago someone at work approached me with an idea to build a replica of  " A Million Times " by Humans Since 1982 , while the...
  • ESP32 SD Card Optimization
    ESP32 SD Card Optimization
     Reading and writing SD Cards with ESP32 should be simple, however, the amount of moving parts in esp-idf makes that a complicated task, fir...
  • ESP32 Performance Profiling
    ESP32 Performance Profiling
    The ESP32 is very capable but even the most capable of devices can get overwhelmed when using it extensively, so how can we find out what is...
  • PlatformIO Static Code Analysis
    PlatformIO Static Code Analysis
    Source Writing code and testing it with unit and integration tests can provide high quality executable, however, it does not indicate if its...
  • Embedding Micropython in your Projects
    Embedding Micropython in your Projects
    MicroPython is a python implementation for microcontrollers and other low resource requirement implementation which can make it perfect for...
Powered by Blogger.
View Dror Gluska's LinkedIn profileView Dror Gluska's profile

Tuesday, April 6, 2010

Google like SQL Full Text Search Transformation

Dror Gluska April 06, 2010  No comment
Have you ever tried to use SQL Full text search syntax? 
It could be a pain in the... you need to parse it and make sure there is no attempt to inject any sql, the parenthesis are opened and closed, quotes are closed if opened and I'm probably forgetting something.


Eric W. Bachtal wrote an article and a class that does it for you.


Give it a try, it made my life very easy.


I've also uploaded a copy to my repository in case the link ever go down.


Update: It should be noted that Jonathan Wood also implemented something similar, I haven't tested it though, next project then. Tags:

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)