mIRC Home    About    Download    Register    News    Help

Print Thread
Adding an SQL database to mIRC not too crazy? #263346 11/07/18 02:35 PM
Joined: Feb 2003
Posts: 2,642
Raccoon Offline OP
Hoopy frood
OP Offline
Hoopy frood
Joined: Feb 2003
Posts: 2,642
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!
Re: Adding an SQL database to mIRC not too crazy? [Re: Raccoon] #263350 12/07/18 05:20 PM
Joined: Aug 2016
Posts: 44
R
rockcavera Offline
Ameglian cow
Offline
Ameglian cow
R
Joined: Aug 2016
Posts: 44
support this!


rockcavera
#Scripts @ irc.VirtuaLife.com.br
Re: Adding an SQL database to mIRC not too crazy? [Re: Raccoon] #263351 12/07/18 06:55 PM
Joined: Jan 2004
Posts: 1,274
L
Loki12583 Offline
Hoopy frood
Offline
Hoopy frood
L
Joined: Jan 2004
Posts: 1,274
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.
Re: Adding an SQL database to mIRC not too crazy? [Re: Loki12583] #264032 21/10/18 10:32 AM
Joined: Nov 2015
Posts: 13
DarkTexas Offline
Pikka bird
Offline
Pikka bird
Joined: Nov 2015
Posts: 13
deffo agreeing! Would save alot performance.


Chris 'DarkTexas' D.
Technical Administrator
ICQ-Chat IRC Services
http://icq-chat.com