SOLVE-SMART Posted Monday at 07:08 PM Posted Monday at 07:08 PM Hi folks ๐ , just out of curiosity: I'm interested in which DBMS database management systems you use. Whether privately or professionally, which ones do you work with? If you like, you can also write a little context about it (area of application, etc.). But as always, it's not a must. I'm not interested in what you've tried, but rather what you use "frequently" or are at least somehow familiar with. ==> Thank you for participating and have a nice day โ๏ธ . Best regards, Sven ==> AutoIt related: ๐ GitHub, ๐ Discord Server, ๐ย Cheat Sheet,ย ๐ย autoit-webdriver-boilerplate Spoiler ๐ย Au3Forums ๐ฒ AutoIt (en) Cheat Sheet ๐ AutoIt limits/defaults ๐ Code Katas: [...] (comming soon) ๐ญ Collection of GitHub users with AutoIt projects ๐ย False-Positives ๐ฎย Me on GitHub ๐ฌย Opinion about new forum sub category ๐ย UDF wiki list โย VSCode-AutoItSnippets ๐ย WebDriver FAQs ๐จโ๐ซย WebDriver Tutorial (coming soon)
argumentum Posted Monday at 07:37 PM Posted Monday at 07:37 PM Provider=Advantage OLE DB Provider That above is the "other" I use. MySQL for my "AutoIt as a CGI"** , and the beloved SQLite. **ย in apache/php. I either code an AutoIt page generator, or a JSON string "returner", or anything that would avoid me coding perl or php. And use a MySQL UDF from somewhere that is in code I haven't touch in years, and would take for me to go to the client(s) PC(s) to look at to tell you exactly the one. Note to self: get organized !, you ย ๐ SOLVE-SMART 1 Follow the link to my code contributionย ( and other things too ). FAQ -ย Please Read Before Posting.
SOLVE-SMART Posted Monday at 09:38 PM Author Posted Monday at 09:38 PM Thank you @argumentum. 1 hour ago, argumentum said: I either code an AutoIt page generator, or a JSON string "returner", or anything that would avoid me coding perl or php. More than understandable, thanks. 2 hours ago, argumentum said: And use a MySQL UDF from somewhere that is in code I haven't touch in years, and would take for me to go to the client(s) PC(s) to look at to tell you exactly the one. No thanks, I don't need to know that much detail. But it's interesting nonetheless. Best regards Sven argumentum 1 ==> AutoIt related: ๐ GitHub, ๐ Discord Server, ๐ย Cheat Sheet,ย ๐ย autoit-webdriver-boilerplate Spoiler ๐ย Au3Forums ๐ฒ AutoIt (en) Cheat Sheet ๐ AutoIt limits/defaults ๐ Code Katas: [...] (comming soon) ๐ญ Collection of GitHub users with AutoIt projects ๐ย False-Positives ๐ฎย Me on GitHub ๐ฌย Opinion about new forum sub category ๐ย UDF wiki list โย VSCode-AutoItSnippets ๐ย WebDriver FAQs ๐จโ๐ซย WebDriver Tutorial (coming soon)
Musashi Posted yesterday at 07:33 AM Posted yesterday at 07:33 AM 12 hours ago, SOLVE-SMART said: I'm interested in which DBMS database management systems you use. Note: Hi Sven, You started an identical survey in the German forum. I will repeat my answer here so that our international friends (f, m, d) can also read it. For larger projects, I primarily use PostgreSQL. This DBMS is extremely powerful, extensively documented, and very pleasant in terms of licensing. Otherwise, SQLite also serves me well, as it is easy to integrate. Depending on the application, PostgreSQL would be too much of a โcannonโ . SOLVE-SMART 1 "In the beginning the Universe was created. This has made a lot of people very angry and been widely regarded as a bad move."
jchd Posted yesterday at 08:38 AM Posted yesterday at 08:38 AM I only use SQLite for both personal and pro needs. I don't even use code (AutoIt or other) to manage my DBs: I run SQLite Expert Pro 24/7 and this covers 99.9% of my daily needs. The only extras I use are a handful of extensions I wrote (in C) to make my life easier. SOLVE-SMART 1 This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe hereRegExp tutorial: enough to get startedPCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta. SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt)
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now