Skip to main content
19 votes
Accepted

What are the benefits of Entity Classes for Databases?

Preamble As was already hinted in the comments, the new functionality is a much higher level. It is basically a compiler from entity query language to SQL, specialized to a given SQL dialect of the ...
Leonid Shifrin's user avatar
11 votes
Accepted

How to manipulate date in SQL via the EntityFramework?

The issue here is that there are restrictions upon the form of EntityFunction definitions when an entity store is backed by a relational data source. In order to ...
WReach's user avatar
  • 69k
11 votes
Accepted

How to do a database query on substrings?

I am one of the developers for the new relational database connectivity features. Very soon, a rather extensive tutorial will be added to the current documentation (via documentation paclet update), ...
Leonid Shifrin's user avatar
10 votes

RelationalDatabase in Mathematica 12

General The new relational databases functionality does currently support SQLite, MySQL, PostgreSQL, MS SQL, and the support for Oracle is coming very soon. There are a few steps one has to go ...
Leonid Shifrin's user avatar
10 votes

Mathematica with MongoDB database

Wolfram Language version 11.3 now has support for MongoDB. You can connect to a MongoDB database via MongoConnect. For example, connecting to a database running ...
Sebastian's user avatar
  • 3,479
6 votes

Graph databases / Nosql with Mathematica

Wolfram Language version 11.3 now has support for interfacing with MongoDB. You can connect to a MongoDB database via MongoConnect. For example, connecting to a ...
Sebastian's user avatar
  • 3,479
6 votes
Accepted

How to map MS SQL Server onto the Entity Framework?

This is not so much a solution as a description of reproduction steps... but the short version of my story was to exit Mathematica, relaunch and try again. analysis current as of Mathematica v12, *...
WReach's user avatar
  • 69k
6 votes
Accepted

Plot a Map of German Bundesländer with specified colors assigned to them

Randomly-colored map Let's start with a colored map of the first level of administrative divisions for a country. We'll use Germany, but any country that has curated data for administrative divisions ...
creidhne's user avatar
  • 5,225
5 votes
Accepted

Openning JSON file, (NDJSON, new line delimited) -- big file

Import[myfile.ndjson,"JSON"] doesn't work because the file as a whole is not valid JSON. But each line is valid JSON and so we can treat the file as a ...
Jason B.'s user avatar
  • 68.7k
5 votes

How to load a RelationalDatabase stored in the WolframCloud?

Yes, but there appears to be a work-around: Upload the SQLite database to the cloud and make a note of its URL. ...
LouisB's user avatar
  • 12.6k
4 votes
Accepted

How to load a RelationalDatabase stored in the WolframCloud?

I received an answer from Wolfram Research Technical Support. They say that it is not presently possible to access a file-based relational database (like SQLite) by specifying a URL. You have to get ...
Seth Chandler's user avatar
4 votes
Accepted

How do I visualize images stored in SQL?

The leading byte sequence 255, 216, 255, 224 looks like the file header that one finds when an image is in JPEG File Interchange Format. To import such an image, we can use: ...
WReach's user avatar
  • 69k
4 votes

Add new JDBC Driver to connect Mathematica to SQL database

In the case where you want to use an updated driver in preference to an older one shipped with Mathematica, AddToClassPath[ ...path..., Prepend -> True]. For ...
Chris F Carroll's user avatar
4 votes
Accepted

RelationalDatabases and dates (Mathematica 12)

Admittedly the date and time support for the new relational databases is not yet exactly where we would like it to be. Under the following assumptions You have already registered the database ( as ...
Leonid Shifrin's user avatar
3 votes
Accepted

Write an expression that queries all of MMA to find the top M Symbols with the most Options or M Symbols having N Options?

Call "nsymbols" the max. number of symbols searched. Then the names of symbols can be get by "Names". As the names are strings we need to change them into symbols. Then we may use &...
Daniel Huber's user avatar
  • 52.6k
3 votes

Importing SQL view vs table

In the question you do not specify which database driver you use to open the connection with JDBC. I have been experimenting with Microsoft Access Database drive and I had similar problems in the past....
Athanassios's user avatar
  • 1,301
3 votes
Accepted

How to create and implement a small database on Mathematica?

I recommend looking into Dataset. Here is a test dataset: ...
gogoolplex's user avatar
2 votes
Accepted

How to use SPARQLSelect filter (SPARQLEvaluation["CONTAINS"]) on two named graphs?

If you use named graphs, you can do the following: ...
Carl Lange's user avatar
  • 13.1k
2 votes

How can I connect database oracle with Mathematica

You might want to explicitly add the Oracle JDBC jar to the CLASSPATH used by Mathematica. ...
Ludovic Kuty's user avatar
2 votes

Importing SQL view vs table

You may use SQLTable in SQLSelect so that the table names are properly formatted for the database system you are using. ...
Edmund's user avatar
  • 42.3k
2 votes

EntityFunction for Relational Database error

Since EntityFunction, just like Function, holds its variable and body, you will have to inject the value into it. This is not ...
Leonid Shifrin's user avatar
2 votes
Accepted

JDBC::error when connecting to MySQL database

MySQL provides two authentication plugins for user passwords: sha256_password and caching_sha2_password. In MySQL 8.0, ...
Domen's user avatar
  • 26.3k
2 votes

Write an expression that queries all of MMA to find the top M Symbols with the most Options or M Symbols having N Options?

One can use free form syntax and Entities. Type "=" at the beginning of cell to start free form syntax. Then type: "list of mathematica functions&...
userrandrand's user avatar
  • 5,892
1 vote

Connection of MariaDB 11.2 to work with Mathematica 13.3.1

After getting some additional information from WRI regarding alternative connections for various databases not in their examples, I was able to make the connection once I had properly set the proper ...
Stuart Poss's user avatar
  • 1,883
1 vote
Accepted

Extracting city names in the text form from the function CountryData

You can use the functions CanonicalName and CommonName: ...
kglr's user avatar
  • 396k
1 vote

Extracting city names in the text form from the function CountryData

Use EntityValue with the property "CanonicalName": ...
Carl Woll's user avatar
  • 131k
1 vote
Accepted

SQLInsert SQLExpr not working in V11

You can use StringReplace to replace \[Rule] with ->: ...
Greg Hurst's user avatar
  • 36.2k
1 vote
Accepted

Cloud Form Function Database

The Wolfram Development Platform Producer plan features database connectivity, which would allow access to a SQLite database in the Wolfram Cloud. For example, this query should return an empty list (...
Christopher Haydock's user avatar
1 vote

Connect to remote Ms-sql Database

...
Syed Maftahur Rahman Sohel's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible