18 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 ...
14 votes

Graph databases / Nosql with Mathematica

For MongoDB instead of using the Rest interface using urls as suggested by Mike, you can use the Java driver. Here's the proof of concept that should allow a lot of fruitful things ... I'm still ...
  • 10.9k
12 votes

Graph databases / Nosql with Mathematica

I have an open-source MongoDB Mathematica driver here: https://github.com/zbjornson/MongoDBLink. There are quick setup instructions and an overview in the readme. It's built on the official Java ...
  • 1,168
12 votes

Graph databases / Nosql with Mathematica

Here is one example of how to create a neo4j connection using JDBC driver from this git. The steeps are: 1- Put the JAR file (neo4j-jdbc-2.0.1-SNAPSHOT-jar-with-dependencies.jar) together with other ...
  • 25.8k
11 votes
Accepted

Slow work of SQLInsert with MS SQL Server in V10

After some useless hours in Google trying to understand jTDS, I discovered that DatabaseLink implementation is a open Package, and that ...
  • 25.8k
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), ...
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 ...
10 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 ...
  • 67.8k
9 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 ...
  • 3,469
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 ...
  • 3,469
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, *...
  • 67.8k
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 ...
  • 4,204
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 ...
  • 65.5k
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. ...
  • 11.9k
4 votes
Accepted

How to Insert Multiples Rows in Database (SQL)

To pass batch parameters to SQLExecute, we must specify the arguments as a single list-of-lists. Each sublist is expected to contain one value for each parameter ...
  • 67.8k
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 ...
4 votes
Accepted

Importing crude oil prices from WolframAlpha

You can import the prices from the Energy Information Administration. ...
  • 30.3k
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 ...
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 ...
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: ...
  • 67.8k
3 votes
Accepted

How to create and implement a small database on Mathematica?

I recommend looking into Dataset. Here is a test dataset: ...
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....
  • 1,291
3 votes

Mathematica with MongoDB database

If you want to bypass .NET and do something that I personally find more intuitive then run it all through the terminal. I'm running OS X 10.10 and have Mongo 3.2 installed. Create a document: ...
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 &...
  • 35.6k
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. ...
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. ...
  • 40.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 ...
2 votes
Accepted

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

If you use named graphs, you can do the following: ...
  • 12.7k
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, ...
  • 9,347
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&...
  • 4,559

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