Page 1 of 1
MS SQL Express native support
Posted: Thu Jun 22, 2017 8:31 pm
by NetNinja
Hi,
I'd like to have MS SQL Express (or standard) native support like sqlite or Postgre
thanks
Re: MS SQL Express native support
Posted: Tue Jun 27, 2017 7:23 pm
by infratec
As workaround:
Use ODBC with creating the DSN 'on the fly'.
Re: MS SQL Express native support
Posted: Tue Jun 27, 2017 8:37 pm
by NetNinja
infratec wrote:As workaround:
Use ODBC with creating the DSN 'on the fly'.
Yes, but ODBC is slow... The best thing is to have embedded, native support of MS SQL like sqlite or Postgre.
bye
Re: MS SQL Express native support
Posted: Tue Jun 27, 2017 9:36 pm
by ts-soft
NetNinja wrote:infratec wrote:As workaround:
Use ODBC with creating the DSN 'on the fly'.
Yes, but ODBC is slow... The best thing is to have embedded, native support of MS SQL like sqlite or Postgre.
bye
But will never come, is not crossplattform!
Re: MS SQL Express native support
Posted: Tue Jun 27, 2017 10:49 pm
by bbanelli
ts-soft wrote:NetNinja wrote:infratec wrote:As workaround:
Use ODBC with creating the DSN 'on the fly'.
Yes, but ODBC is slow... The best thing is to have embedded, native support of MS SQL like sqlite or Postgre.
bye
But will never come, is not crossplattform!
What would be Windows solution for static linking to PB's EXE?
Re: MS SQL Express native support
Posted: Wed Jun 28, 2017 8:52 pm
by the.weavster
NetNinja wrote:Yes, but ODBC is slow...
I don't see any inherent reason ODBC should be slow. A particular implementation of an ODBC driver may be slow but there's no reason it should be a universal truth.
Have you actually tested it?
Re: MS SQL Express native support
Posted: Wed Jun 28, 2017 10:27 pm
by Lunasole
From my experience that ODBC is only "relatively slow".
You should not use database if have no LOT of data (just because it is stupid and not optimal, to use whole SQL when dealing with amount which can easily be handled by those maps/hash-tables etc), and if you have such a lot, then ODBC overhead makes no any difference
Also what about MS SQL Server - I hated it, but it is so cool and nicely done comparing to any alternatives for windows/linux ^^
Anyway don't think it can be added to PB somehow, but adding ODBC support looks not too bad (and it can be done for all 3 platforms).
// some partially related offtop also:
However I would like more if something making work with C++ objects simpler be added natively, that's probably one of things that can make PB some "more professional" and interesting to more coders (hah, which is questionable plus, as often if something becomes too popular, it becomes averaged, degrades & die ^^). Why? Because those damn POO/classes are everywhere and it is damn complicated to deal with C++ from PB, if you want for example to write plugin for something like Photoshop or just use another library/engine. I would made separate topic for that if only had some ideas how this can be done nicely ^^