My database moved from MS-Access

Hi,

Here is the continuation talk from the previous article.

I decided to move my data of MS-Access to SQLite.
SQLite is a database application like MS-Access, to create a database file of SQLite, alike .accdb or .mdb file of MS-Access. And it's a free application.

I worked it out like the next.
1. study about SQLite
2. define and create the database table with SQLite
3. remake SQL programs for SQLite-View like MS-Access query
      (referring the SQL programs of the Querys of the MS-Access)
4. make the import-files for SQLite from my database of MS-Access 
      (doing copy&paste every the database table, and a little modification)
5. do import the files into SQLite, then sqlite file is outed with the data.
      (I had to get the 10 SQLite files, that's my data for ten years.)

The following applications I decided to use relate to SQLite.

[Windows applications]:
    *sqlite.exe (SQLite 3.46.1, the newest version); using through CUI
    *DB Browser for SQLite v3.13.0; using through GUI
        - SQLite 3.46.0
              (able to the newest version by replaced sqlite3.dll)
    *python.exe (Python 3.12.6); using through CUI
        - SQLite 3.45.3 library, called by python programs
              (able to the newest version by replaced sqlite3.dll)

[iPad applications]:
    *SQLite Mobile Client 6.16 (with Pro, not free); using through GUI
        - SQLite 3.46.1
    *Pythonista 3.4 ; using through GUI
        - SQLite 3.43.2 library, called by python programs
        - python 3.10.4
    *iSH 1.3.2 (with apk-alpine-v3.18)
        - sqlite (SQLite 3.41.2); using through CUI
        - python3 ; using through CUI
             (Python 3.11.10 with SQLite 3.41.2 library)

Python is a programing language as a famous, and one of the most likely to use myself. Even though I've only ever a little used with Python, the above is care for just in case of when I use.

On both Windows and iPad, I want to create, view and search my sqlite files as database. As the files are supported on many program languages, I can even view them with my created programs.

And then, for me creating programs, it's important to check the versions of my using applications because I need to be care to use the program's features supported on any applications.

For example, a SQL function on SQLite;
      date('2024-03-31', '-1 months', 'floor').
The modifier of 'floor' is supported from version 3.46.0 of SQLite.
On some applications, as this modifier is not capable for my using, I have to use another way. Like this, I need to know the SQLite's features it's available for the all application I want to use.

Anyway, it's convenient for my database to be capable on both Windows and iPad by SQLite. And I search whole the ten years, ten files, by a program I created. I can do more than before.

The result is very good.

Thanks for your reading,
Masa