MariaDB & HeidiSQL

[Ian Oldfield]

Hi,

I would be most grateful for any tips or advice on connecting to MariaDB.  That is my preferred DB and would like guidance on that if possible?  Specifically, any connections issues or limits.   Alternatively, I guess many people have other preferences, such as Postgres, MySQL or SQL Server, so any opinions would be appreciated on the merits of different systems.

Thank you very much.

Ian.

Ian Oldfield, MSc, CertEd.

Director,  Synthetic Data Ltd

[Peter Horsbøll Møller]

Hi Ian

 

You should be able to connect to the database using ODBC.

I recall having connected to its predecessor MySQL many years back in time.

 

However, I’m not sure if MapInfo Pro will support any spatial data stored in MariaDB, if it’s capable of handling this type of data.

You can however store coordinates and MapInfo Pro will be able to create points from these coordinate pairs when you open the table.

 

Peter

 

—

Peter Horsbøll Møller

Principal Sales Engineer - Distinguished Engineer

Precisely.com

 

From: 'Ian Oldfield' via MapInfo-L <mapi...@googlegroups.com>
Sent: Tuesday, 2 May 2023 19.42
To: MapInfo-L <mapi...@googlegroups.com>
Subject: [MI-L] MariaDB & HeidiSQL

 

This message originated Externally. Use proper judgement and caution with attachments, links, or responses.

 

--
--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en

---
You received this message because you are subscribed to the Google Groups "MapInfo-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mapinfo-l+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mapinfo-l/4a2cb2a8-79a0-4645-a8da-b250aae4be0en%40googlegroups.com.

[Ian Oldfield]

Hi Peter,

Thank you, as always, that was my plan, I'll see how I get on.      I am hoping to get some feedback on the use of MariaDB or other preferred solutions from those users who connect to external sources.

Kind regards

Ian.