However, there doesn't seem to be any way to call those scripts/function from an SQL query.Į.g. I can see that Valentina supports Javascript and that you can save scripts in the vsp project files. It's possible to build up quite complex logic in QtScript and so the integration with SQL, whether it's querying based on them or updating tables etc, is very powerful. (2) In SQLiteStudio, it's possible to define functions in QtScript, which then can be called from SQL statements. If necessary, I could live with running my projects in Valentina DB, if I can get (2) to work below. I know that Valentina DB itself has hashing functions, but I'd like to be able to use them within SQLite. I can see there is an option to "Show Extensions" in the Schema editor if you right click on the database name, with options to add/delete, but those buttons don't work and the sha1 library isn't listed. I can't see that the extension is loading at all. I've downloaded the dlls from here:, but if I try: However, I can't get the extensions to load in Valentina Studio. I know that SQLite doesn't support that natively, but there are extensions available that allow you to use that. (1) I need to be able to use hashing functions ( e.g. This is all running locally, rather than server based. I came across Valentina Studio, which looks fully featured, but I'm having trouble replicating functionality that I'm used to with SQLiteStudio, while still using my SQLite databases. I've been using SQLiteStudio for some years, but it doesn't seem to be maintained as much as it used to be so I'm looking for an alternative.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |