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 ...
- 111k
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 ...
- 36.8k
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.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 ...
- 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 ...
- 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 ...
- 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 ...
- 111k
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), ...
- 111k
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 ...
- 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 ...
- 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/...
- 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 ...
- 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.
...
- 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:
...
- 264k
6
votes
Accepted
Create Table of replacement rules
The shortest solution is to set attribute Listable for g:
...
Kuba♦
- 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 ...
- 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, *...
- 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 ...
- 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.
...
- 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 ...
- 62.7k
4
votes
Accepted
Importing crude oil prices from WolframAlpha
You can import the prices from the Energy Information Administration.
...
- 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:
...
- 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 ...
- 161
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 ...
- 67k
4
votes
Slow work of SQLInsert with SQLite
Using SQLBeginTransaction works fast with the SQLite version 3.7.2 distributed with Mathematica 10 :
...
- 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 ...
- 2,962
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 ...
- 111k
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 ...
- 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:
...
- 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,271
Only top scored, non community-wiki answers of a minimum length are eligible