Subj : Re: JSLibs
To   : Deuce
From : Badopcode
Date : Sun Feb 26 2012 03:16 pm

 >  > I would love to have SQLite abilities.  This would make script developmen
 >  > a ton more easier and faster to do bigger projects.
 > 
 > I have some work on adding ODBC support to Synchronet.  I think that marryin
 > a specific engine would be a mistake - expecially one as purposefully weak a
 > SQLite.

ODBC would be very cool.  But SQLite is not weak and a lot lower over head than
running a SQL server on the same server that your applications are running on.
 As long as there is a single server scenario SQLite is a very practical
alternative.
If Synch was to adopt a ODBC model it would make the most sense if Synch's db
stuff got stored via ODBC instead local binary packed files.
That would go a long ways into making Synch a enterprise class super daemon.  I
never got the feeling that that was the direction of Synch.  But I would
applaud this direction as Synch naturally does social networking which is a
major demand of business websites now days.
But on the downside to ODBC is that there is a level of complication to setting
up ODBC drivers.  On Windows its fairly simple and can be a step-by-step with
screenshots.  ODBC on Linux can sometimes be hellish.
Probably the best tactic to eliminating a flood of "How do I setup ODBC?"
questions in the forums would be to setup ODBC as a build directive and on the
precompiled distributions only compile the packed binary configs.
My thinking was just a SQLite interface that extends the Javascript engine as
an alternative to regular file IO routines.  ODBC for just the Javascript
engine would be a bit overkill.  IMHO

---
 þ Synchronet þ Darkest Hour BBS - thedhbbs.com

.