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 ...
user avatar
17 votes

Graph databases / Nosql with Mathematica

Mathematica can also connect to Neo4J via the REST API. Instructions for use on OS X: 1. Install Neo4j 2. start the webserver $ sudo apachectl start 3. start ...
user avatar
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 ...
user avatar
  • 10.7k
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 ...
user avatar
  • 1,158
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 ...
user avatar
  • 25.3k
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 ...
user avatar
  • 25.3k
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 ...
user avatar
10 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), ...
user avatar
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 ...
user avatar
  • 67k
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 ...
user avatar
  • 3,469
7 votes

Slow work of SQLInsert with SQLite

Firstly, a bit about SQLite insert performances: https://stackoverflow.com/questions/1711631/how-do-i-improve-insert-per-second-performance-of-sqlite https://stackoverflow.com/questions/3852068/...
user avatar
  • 1,179
7 votes
Accepted

Insert large amount of data in HSQL

Two possible solutions are Use MySQL, SQLite or any other database that is not an in-memory database. HSQL keeps all its data in the memory at all times. I'm leaving this for future visitors since ...
user avatar
  • 68.7k
6 votes
Accepted

How to update bundled SQLite library (or driver?) in V10 for OS X

Mathematica 10 ships with version 3.7.2 of the Xerial SQLite JDBC driver. Let me first verify your findings. ...
user avatar
  • 198
6 votes

Create Table of replacement rules

Of course in this case it would be better if you could write a single Table expression: ...
user avatar
  • 264k
6 votes
Accepted

Create Table of replacement rules

The shortest solution is to set attribute Listable for g: ...
user avatar
  • 132k
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 ...
user avatar
  • 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, *...
user avatar
  • 67k
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 ...
user avatar
  • 4,154
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. ...
user avatar
  • 11.5k
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 ...
user avatar
  • 62.7k
4 votes
Accepted

Importing crude oil prices from WolframAlpha

You can import the prices from the Energy Information Administration. ...
user avatar
  • 29.1k
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: ...
user avatar
  • 67k
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 ...
user avatar
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 ...
user avatar
  • 67k
4 votes

Slow work of SQLInsert with SQLite

Using SQLBeginTransaction works fast with the SQLite version 3.7.2 distributed with Mathematica 10 : ...
user avatar
  • 16.8k
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 ...
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 ...
user avatar
3 votes
Accepted

How to check empty tables using SQL Select or Execute?

Here is one options: If[SQLExecute[con, "Select * from TABLE","MaxRows" -> 1] == {},True, False] If it's just a test, Using ...
user avatar
  • 25.3k
3 votes
Accepted

How to create and implement a small database on Mathematica?

I recommend looking into Dataset. Here is a test dataset: ...
user avatar
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....
user avatar
  • 1,271

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