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
