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
16 votes
Accepted

DatabaseLink and Libreoffice odb

A few tricks are required, but it is possible to create a database in LibreOffice and read the data via DatabaseLink in MMA. Here is a summary of worked for me ...
LouisB's user avatar
  • 12.6k
14 votes
Accepted

How to extract Bitmap image from SQL records?

Summary The Northwind database was originally an MS Access database, so the pictures are BMP images wrapped within OLE objects. We must strip the OLE header before parsing them. The following ...
WReach's user avatar
  • 68.9k
14 votes

How to speed up interpreting numbers from strings?

I would like to link this W Community thread here where I asked for functionality like this in 2015 September, and explained why it's critical to have it. I can't link to individual posts but you can ...
Szabolcs's user avatar
  • 235k
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
8 votes

JDBC-to-ODBC bridge gone. How to connect to SQL Server now in case of Windows Authentication?

Following Rolf Mertig's tip I examined the merits of Microsoft's latest JDBC driver (not included in Mathematica 11). It worked, but it was quite a trip. The itenary can be found below. Note that you'...
Sjoerd C. de Vries's user avatar
7 votes
Accepted

Why has this SQLInsert behaviour changed?

It looks like a bug to me. Any input larger than 2^31 -1 is truncated to 32 bits, whereas a BIGINT should be able to hold 64 bit numbers. What you see is the interpretation of that remainder in two's ...
Sjoerd C. de Vries's user avatar
7 votes
Accepted

Maintaining SQLConnections

Moving my comments into an answer: If you create forceConnection[conn_]:=If[.. then you don't have to worry about replacing conn...
Kuba's user avatar
  • 137k
6 votes
Accepted

Local Storage of Periodically Collected Data (without using DataDrop)

I will show an example of how easy it is to set up a database, sometimes things seem complicated or overkill because one hasn't seen a good example of how simple it can be. Start by connecting to a ...
C. E.'s user avatar
  • 70.7k
6 votes
Accepted

Retrieve column data from MongoCollection

I've written this solution as an aggregation because aggregations are likely to be what you want to do more often, so will show you how to set it up. disclaimer: I don't have your data so I am doing ...
Mike Honeychurch's user avatar
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
  • 68.9k
6 votes
Accepted

SQLite and Mathematica

DatabaseLink` and the Database` functions are actually two completely independent ways to access databases. The ...
Albert Retey's user avatar
  • 23.6k
5 votes

JDBC-to-ODBC bridge gone. How to connect to SQL Server now in case of Windows Authentication?

Yes you are right, JDBC-to-ODBC support is gone as Mathematica uses java8. However 11.0.1 mathematica comes with a support for using open source JDBC driver which can be used to connect Microsoft ...
dsingh's user avatar
  • 669
5 votes
Accepted

How to speed up interpreting numbers from strings?

Import and ImportString handle the e number format okay. You might be able to Import ...
Simon Woods's user avatar
5 votes
Accepted

Context of SQLBinary in Package

In short, the reason for the behaviour you observe is this: Some DatabaseLink functions will only work if "DatabaseLink`" is in ...
Szabolcs's user avatar
  • 235k
5 votes
Accepted

Can't connect to MS SQL using Active Directory Integrated Services via DatabaseLink

I downloaded the MS SQL driver from Microsoft https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15 and installed it under C:\Users\myuser\...
Zviovich's user avatar
  • 9,308
5 votes
Accepted

How to access an English-Chinese dictionary database file correctly?

This SQL file is not a sqlite3 database file. I don't know whether Wolfram Mathematica includes a complete MySQL program. I installed the latest version of MariaDB/MySQL on my computer. 1. Install ...
J.W Kang's user avatar
  • 408
3 votes

How to access an English-Chinese dictionary database file correctly?

(Not an answer, or a partial answer.) I am not sure how many people would be willing / prepared to click on buttons on a site with language they do not understand. I think using GitHub repositories ...
Anton Antonov's user avatar
3 votes
Accepted

OpenSQLConnection fails - due to some Java problem?

I received the following from Wolfram and it worked for me: As a workaround, please try the following: Download Microsoft mssql jdbc driver zip fie from https://docs.microsoft.com/en-us/sql/connect/...
HJensen's user avatar
  • 537
3 votes
Accepted

How to select a SQLConnection from SQLConnections[] by its "Name" property?

The Name option is not unique, so we could be more than one result, if we ask all connections with a particular name. Try this: ...
LouisB's user avatar
  • 12.6k
3 votes

I have a bigdata CSV file as a single table of five columns and almost 10 million rows

So more and more I think what you're trying to do is simply infeasible via Mathematica. The bundled Microsoft Access driver (UCanAccess) won't touch Excel and the old Microsoft Excel driver has ...
b3m2a1's user avatar
  • 46.9k
3 votes
Accepted

Connection to SQL server - Failed

The error message indicates that the server host name is in error. This is because the instance name has been tacked onto the end of server host name (wwe**pe.**.***.ds\MSSQL***). While this is ...
WReach's user avatar
  • 68.9k
3 votes
Accepted

Insert a DateObject into MySQL database?

You may use SQLDateTime with DateList. ...
Edmund's user avatar
  • 42.3k
2 votes

How do I insert Unicode into a MySQL database?

Based on this answer, I solved the issue by adding "Properties" -> {"characterEncoding" -> "UTF-8"} to the connection: ...
balping's user avatar
  • 438
2 votes

Insert a DateObject into MySQL database?

As it turns out, DateObject is not the only problem here. I kind of lack in some basic knowledge in SQL. Here are the mistakes I made. ...
407PZ's user avatar
  • 1,461
2 votes
Accepted

Querying ( e.g. ) Google Trends Data with Mathematica front-end

You can experiment with the RNACentral public PostgreSQL database. ...
Rohit Namjoshi'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
1 vote
Accepted

Retrieve the Date/Time difference in a MongoCollection

I have found an answer. My main obstacle was the parsing of date-time string into a ISODate( ). ...
Romke Bontekoe's user avatar
1 vote

How to extract Bitmap image from SQL records?

Thanks to @WReach's help, ...
Jerry's user avatar
  • 2,459
1 vote

JDBC-to-ODBC bridge gone. How to connect to SQL Server now in case of Windows Authentication?

I am not sure this will be helpful, as I am running Mathematica 9, but maybe the issue is the same, as move from 32 bit to 64 bit. I use this code as I move from Windows 32 bit to Windows 64 bit, ...
Manuel --Moe-- G's user avatar

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