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 ...
- 114k
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 ...
- 12.2k
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 ...
- 233k
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 ...
- 68.4k
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), ...
- 114k
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'...
- 65.6k
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 ...
- 65.6k
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♦
- 136k
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, *...
- 68.4k
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 ...
- 70k
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 ...
- 37.4k
6
votes
Accepted
SQLite and Mathematica
DatabaseLink` and the Database` functions are actually two completely independent ways to access databases. The ...
- 23.5k
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 ...
- 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 ...
- 84.6k
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 ...
- 233k
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\...
- 9,288
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 ...
- 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 ...
- 37.5k
3
votes
Accepted
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:
...
- 12.2k
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 ...
- 46.6k
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 ...
- 68.4k
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/...
- 517
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:
...
- 428
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.
...
- 1,441
2
votes
Accepted
Querying ( e.g. ) Google Trends Data with Mathematica front-end
You can experiment with the RNACentral public PostgreSQL database.
...
- 10.1k
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, ...
- 18.9k
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( ).
...
- 1,883
1
vote
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, ...
- 1,057
Only top scored, non community-wiki answers of a minimum length are eligible