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 --

[sqlite] Porting help please :-)

there Ive just recently ported ( in the nastiest dirtiest way so far ) sqlite onto another platform - that is AmigaOS version 4.0 ( powerpc ):http://www.os4depot.net/index.php?function=showfile&file=library/misc/sqlite3.tar.gz However I had to put a health warning on it because in order to get

Re: [sqlite] Porting help please :-)

Thanks for responding Gé There are the usual options of buffered and unbuffered file i/o in AmigaOS. A given file can be opened either in a shared mode, or an exclusive mode by a process, but it can also be locked first and then opened. It cannot be locked individually for a given pthread runnin

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 pr

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 databa

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 in