Re: [sqlite] Abuse of the SQLite website

You could adapt this ruleset used to block ssh bruteforce attacks: ( quoting from http://www.la-samhna.de/library/brutessh.html ) iptables -A INPUT -p tcp --dport 22 -m state --state NEW -m recent --set \ --name SSH -j ACCEPT iptables -A INPUT -p tcp --dport 22 -m recent --update --seconds 60

Re: [sqlite] Running in memory only

Salut Benjamin, Simplest way to make that happen is to use a ram disk, google for 'RamDisk' and the platform you are using. Then you can use the existing sqlite binary/library but all I/O occurs in memory. When you want to persist, you just copy it to a hard disk... D.

Re: [sqlite] Proposed 3.3.0 changes. Was: 5/2==2

1/3. Store that mysql ;-) Or what about PI? Or the square root of 10? Not all reals can be represented as fractions either. Surd-tastic. Whilst computers are finite state machines such approximations are the most reasonable compromise between accuracy and performance. Or should that be

Re: [sqlite] Proposed 3.3.0 changes. Was: 5/2==2

Well, since you put it that way. May I go one step farther and request that this new Dynamic Type also adhere to "Bankers Rounding" commonly implemented as BCD in other so equipped databases. Please, no. I'll handle rounding in my application, I don't need it on the database. Not all

Re: [sqlite] Proposed 3.3.0 changes. Was: 5/2==2

Am I alone in thinking that a division operator that does different things depending on the declared datatype of a column is an abomination? Absolutely not. Of course he won't be alone, doesn't make him ( or you ) correct or in fact incorrect. I think allowing mathematical operators built