Jump to content

Which DBMS (database management systems) do you use?  

7 members have voted

  1. 1. Which DBMS (database management systems) do you use?

    • DB2
      0
    • InfluxDB
      0
    • MongoDB or more/other NoSQL DBs
      1
    • MS SQL Server
      2
    • MySQL (MariaDB)
      2
    • Oracle
      0
    • PostgreSQL
      3
    • Redis
      1
    • SQLite
      5
    • Other
      1
    • None
      0


Recommended Posts

Posted

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)

Posted
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 :censored:ย ๐Ÿ˜…

Follow the link to my code contributionย ( and other things too ).
FAQ -ย Please Read Before Posting.
autoit_scripter_blue_userbar.png

Posted

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

==> 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)

Posted
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โ€ ;).

Musashi-C64.png

"In the beginning the Universe was created. This has made a lot of people very angry and been widely regarded as a bad move."

Posted

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.

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 here
RegExp tutorial: enough to get started
PCRE 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)

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...