mIRC Home    About    Download    Register    News    Help

Print Thread
Joined: Feb 2003
Posts: 2,737
Raccoon Offline OP
Hoopy frood
OP Offline
Hoopy frood
Joined: Feb 2003
Posts: 2,737
Dear Khaled,

I'm curious what it would take to add a proper SQL implementation to mIRC today, naively, not an external DLL and slow helper-script. It seems a lot of software frivolously adds an SQL engine without much overhead. Ie, SQLite is completely embedded and only half a megabyte compiled; +10% overhead for mIRC. I'm wondering if this topic could be visited.

I think for you, it could help you manage things like the IAL and banlists much more efficiently, and for scripts, it would enable us to do a lot of nifty things that hash tables simply cannot -- like summing columns of data. You might even have fun implementing it.


Well. At least I won lunch.
Good philosophy, see good in bad, I like!
Joined: Aug 2016
Posts: 57
R
Babel fish
Offline
Babel fish
R
Joined: Aug 2016
Posts: 57
support this!

Joined: Jan 2004
Posts: 1,330
L
Hoopy frood
Offline
Hoopy frood
L
Joined: Jan 2004
Posts: 1,330
Since you're going there, I use CryptUnprotectData to decrypt data stored in SQLITE_BLOB. If that could be built in somehow, to remove need for external crypt dll where binvar passing is terrible.

Unrelated, a simple suggestion to support flags in the open call (SQLITE_OPEN_READONLY et al)

Last edited by Loki12583; 12/07/18 07:03 PM.
Joined: Nov 2015
Posts: 15
D
Pikka bird
Offline
Pikka bird
D
Joined: Nov 2015
Posts: 15
deffo agreeing! Would save alot performance.


Link Copied to Clipboard