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 ...
- 113k
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), ...
- 113k
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 ...
- 113k
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 ...
- 161
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 ...
- 3,032
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 ...
- 113k
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:
...
- 678
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:
...
- 37.1k
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.
...
- 121
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 ...
- 113k
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