is it possible to connect blockland/vce to ms sql database? if so, how?

[Kalphiter]

He should actually have SQLite support, probably more important the MySQL support.

[Ad Bot]

[aludane]

He should actually have SQLite support, probably more important the MySQL support.

There's a ruby-gem for that.

[Kalphiter]

There's a ruby-gem for that.

but this isn't ruby



whoah

[mctwist]

He should actually have SQLite support, probably more important the MySQL support.

The current add-on cache implementation uses SQLite. He also uses some functions to be called to alter the cache. However, he haven't added any direct functionality either because he doesn't like people messing with his cache(He doesn't want to you touch anything in the code anyway), or it was a pain implementing it so it work with a script.
I would not see it as a problem as TCPObject is socket based and an SQLite call should be socket based as it should be in a different thread(Correct me if I'm wrong).

More over, an example if Badspot would ever dare to implement such a functionality:

Code: [Select]

SQLite
{
methods:
connect(host, user, pass, db)
close()
query(query)
result()
clearResults()
}The connect method could be stripped everything but db if Badspot only wants it to be local. I would prefer it like this though.

[Kalphiter]

However, he haven't added any direct functionality either because he doesn't like people messing with his cache(He doesn't want to you touch anything in the code anyway), or it was a pain implementing it so it work with a script.

I was hoping for a function to check if a hash is already in the cache.

[mctwist]

I was hoping for a function to check if a hash is already in the cache.

Sure thing, but why check it there as it is done automatically? Badspot really wanted no one to touch it(translation: break it) so he made the only connection to it a handful of functions that only tells it to update, if even that!

[Chrono]

Sure thing, but why check it there as it is done automatically? Badspot really wanted no one to touch it(translation: break it) so he made the only connection to it a handful of functions that only tells it to update, if even that!

There's a function to add a file to the cache.

It will add it regardless if it's already in there or not.

Kalphiter only wants it to write if the file isn't in there already.

[Kalphiter]

There's a function to add a file to the cache.

It will add it regardless if it's already in there or not.

Kalphiter only wants it to write if the file isn't in there already.

I actually want it split into two steps, because I would be dealing with a list of hashes in order to avoid checking the hashes of a ton of files. The function used to add a file to the cache will compute the hash of the file; that is something I really need to avoid. Music can actually be packaged in ZIP files and upon startup, the cache is compared with a precomputed list of hashes and music files copied to the music folder, which is revolutionary.