Reading data from a sqlite database
13 views (last 30 days)
Show older comments
Hi,
I'm trying to import data from a sqlite database. Some of the data in the database are floating point values that are less than 1. When I run the MATLAB fetch command to read the data, the result is a cell array with zero values:
{[0]}, {[0]},....
Then when I run cell2mat to convert the cell array to a numeric array, I get an array of zeros.
The fetch command is:
values = fetch(conn, sqlquery);
How do I should read database values that are less than 1 floating point numbers?
Thank you,
Keihan Rafii
1 Comment
Mann Baidi
on 7 Dec 2023
Edited: Mann Baidi
on 7 Dec 2023
Hi,
I am not facing any issue in fetching floating values that are less than 1 on my end. Can you share the database and the query which you are trying to fetch?
Answers (1)
Samay Sagar
on 25 Sep 2024
You might encounter the above issue if the data type is not handled correctly.
You can follow these steps to ensure that the data is imported correctly:
- Ensure that the columns in your SQLite database are defined with a floating-point type (e.g., "REAL").
- Before converting the data to matrix, inspect the raw data fetched from the database to verify the values. You can set up breakpoints in your code to inspect variable values.
- If the values are too small(say 0.0000001), the values can appear as 0 due to loss in precision. You can change the display format to long to resolve this.
format long
For more information related to debugging, you can refer the following documentation:
0 Comments
See Also
Categories
Find more on Database Toolbox in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!