Questions tagged [databases]
The databases tag has no summary.
68 questions
0
votes
0
answers
73
views
Access data from Microsoft Access DB
Clearly I don't know what I'm doing. Before I retired I had to access MS SQL databases. Now I am trying to use MS Access. Most of what I found on the web is 8-10 years old, and possibly that's why I'm ...
- 4,044
2
votes
2
answers
153
views
0
votes
1
answer
95
views
Connection of MariaDB 11.2 to work with Mathematica 13.3.1
I would like to get the proper driver settings in place to permit the
mariaDB database to connect to Mathematica via a JDBC driver running on
a Windows11 64-bit machine.
I've got mariaDB version 11.2 ...
- 2,055
2
votes
2
answers
174
views
Write an expression that queries all of MMA to find the top M Symbols with the most Options or M Symbols having N Options?
I apologize, but I'm way over my pay-grade on this one, so I don't have any code to share that needs correcting. That is because I really don't know how to start this. I feel like this has a very easy ...
- 2,507
1
vote
1
answer
635
views
JDBC::error when connecting to MySQL database
I'm trying to connect to a MySQL database. I've seen quite a few different methods (some of which are conflicting and seem to be outdated) of connecting but haven't managed to get any to work so far.
...
- 379
3
votes
1
answer
115
views
Are Experimental Functions like DatabaseReference not available on Mathematica for Raspberry Pi?
I tried calling DatabaseReference and RelationalDatabase on version 12.3.1.0 for the Raspberry Pi, and found that the functions were not defined. I see in the documentation that they are Experimental ...
- 451
0
votes
0
answers
123
views
Failure connecting local MySQL server
I have locally installed and run the latest version of Oracle MySQL Community Server 8.0 on port 3306. I successfully established connections to it from locally installed Oracle MySQL Workbench 8.0 ...
- 62.5k
2
votes
0
answers
119
views
Store Mathematica results in an external rdbms
I want to store Mathematica results in an external rdbms, Postgres specifically.
The Mathematica documentation talks a lot (eg in 'Relational Database Quick Start') about extracting data from external ...
- 21
5
votes
1
answer
373
views
Plot a Map of German Bundesländer with specified colors assigned to them
I would like to draw a map of the German states ("Bundesländer") with Mathematica 12.
I found examples how to outline countries. But I need the next smaller levels.
I have not found anything ...
- 2,903
3
votes
0
answers
159
views
error database connection MMA 12.2
I work with MMA 12.0. When I want to make a connection with met Oracle Database, I do:
...
- 2,855
0
votes
2
answers
77
views
Extracting city names in the text form from the function CountryData
I was planning to create an array with all capital cities in Europe using the following command:
CountryData["Europe", "CapitalCity"]
But ...
- 103
4
votes
1
answer
1k
views
Openning JSON file, (NDJSON, new line delimited) -- big file
I am trying since many hours to open a JSON file ("new line delimited") that has this as structure
...
- 671
2
votes
2
answers
141
views
EntityFunction for Relational Database error [closed]
I am a student and I am new of Mathematica.
I am working with relational databases and I am following the guide "Relational Database quick start" find here: https://reference.wolfram.com/language/...
- 21
5
votes
0
answers
200
views
Speeding up postgres queries in v12.1?
New in v12.1 is the ability to connect to Postgres. I have a Postgresql database with a few million images (stored as byte data). Each image retrieval is ~10 seconds, so I need to speed it up! But how ...
- 31.9k
6
votes
1
answer
145
views
RelationalDatabases and dates (Mathematica 12)
As related to the new database functionality in version 12, I am trying to retrieve a specific entity (row) or group of entities (multiple rows) between a date range in an MS SQL database. The ...
- 376