{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":712310483,"defaultBranch":"master","name":"AISdb","ownerLogin":"AISViz","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2023-10-31T08:06:06.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/149179252?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1715698983.0","currentOid":""},"activityList":{"items":[{"before":"8dcdc29c630f5d4378854e71728f671f89abac4d","after":"d108d74ae2ab65b04b3a3865b99b8d6743bce70e","ref":"refs/heads/query_processor","pushedAt":"2024-06-02T19:07:51.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Jinnkunn","name":"Jinnkunn","path":"/Jinnkunn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20015597?s=80&v=4"},"commit":{"message":"Update AISProcessor","shortMessageHtmlLink":"Update AISProcessor"}},{"before":"4e182941bd83fe5983782314dadd0a3aa0a993ab","after":"1584d38a1d7704c9bd12e6c1a6bbe72f554e529f","ref":"refs/heads/dependabot/cargo/cargo-security-group-0fc1d89af6","pushedAt":"2024-05-21T17:21:28.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"gabrielspadon","name":"Gabriel Spadon","path":"/gabrielspadon","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6691923?s=80&v=4"},"commit":{"message":"Merge branch 'master' into dependabot/cargo/cargo-security-group-0fc1d89af6","shortMessageHtmlLink":"Merge branch 'master' into dependabot/cargo/cargo-security-group-0fc1…"}},{"before":"2c6cb9a21b2eea0e2f6725289b400a8261fbe365","after":"8dcdc29c630f5d4378854e71728f671f89abac4d","ref":"refs/heads/query_processor","pushedAt":"2024-05-14T15:14:51.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Jinnkunn","name":"Jinnkunn","path":"/Jinnkunn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20015597?s=80&v=4"},"commit":{"message":"Add min_speed_filter","shortMessageHtmlLink":"Add min_speed_filter"}},{"before":"4f4177ccf7070bacfd4d2822e8fd3e08ca87acd5","after":"2c6cb9a21b2eea0e2f6725289b400a8261fbe365","ref":"refs/heads/query_processor","pushedAt":"2024-05-14T15:08:31.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Jinnkunn","name":"Jinnkunn","path":"/Jinnkunn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20015597?s=80&v=4"},"commit":{"message":"Add interface restriction for AISProcssor","shortMessageHtmlLink":"Add interface restriction for AISProcssor"}},{"before":null,"after":"4f4177ccf7070bacfd4d2822e8fd3e08ca87acd5","ref":"refs/heads/query_processor","pushedAt":"2024-05-14T15:03:03.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"Jinnkunn","name":"Jinnkunn","path":"/Jinnkunn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20015597?s=80&v=4"},"commit":{"message":"Create new API for query processing","shortMessageHtmlLink":"Create new API for query processing"}},{"before":null,"after":"5859ccd8524582ac50a8966ae379676fc4ab0a68","ref":"refs/heads/dependabot/cargo/cargo-f4b48e3438","pushedAt":"2024-04-05T15:47:37.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"dependabot[bot]","name":null,"path":"/apps/dependabot","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/29110?s=80&v=4"},"commit":{"message":"Bump the cargo group across 3 directories with 6 updates\n\nBumps the cargo group with 6 updates in the / directory:\n\n| Package | From | To |\n| --- | --- | --- |\n| [h2](https://github.com/hyperium/h2) | `0.3.21` | `0.3.26` |\n| [mio](https://github.com/tokio-rs/mio) | `0.8.8` | `0.8.11` |\n| [openssl](https://github.com/sfackler/rust-openssl) | `0.10.57` | `0.10.64` |\n| [rustix](https://github.com/bytecodealliance/rustix) | `0.38.13` | `0.38.32` |\n| [webpki](https://github.com/briansmith/webpki) | `0.22.1` | `0.22.4` |\n| [whoami](https://github.com/ardaku/whoami) | `1.4.1` | `1.5.1` |\n\nBumps the cargo group with 1 update in the /aisdb_lib directory: [whoami](https://github.com/ardaku/whoami).\nBumps the cargo group with 2 updates in the /receiver directory: [webpki](https://github.com/briansmith/webpki) and [whoami](https://github.com/ardaku/whoami).\n\n\nUpdates `h2` from 0.3.21 to 0.3.26\n- [Release notes](https://github.com/hyperium/h2/releases)\n- [Changelog](https://github.com/hyperium/h2/blob/v0.3.26/CHANGELOG.md)\n- [Commits](https://github.com/hyperium/h2/compare/v0.3.21...v0.3.26)\n\nUpdates `mio` from 0.8.8 to 0.8.11\n- [Release notes](https://github.com/tokio-rs/mio/releases)\n- [Changelog](https://github.com/tokio-rs/mio/blob/master/CHANGELOG.md)\n- [Commits](https://github.com/tokio-rs/mio/compare/v0.8.8...v0.8.11)\n\nUpdates `openssl` from 0.10.57 to 0.10.64\n- [Release notes](https://github.com/sfackler/rust-openssl/releases)\n- [Commits](https://github.com/sfackler/rust-openssl/compare/openssl-v0.10.57...openssl-v0.10.64)\n\nUpdates `rustix` from 0.38.13 to 0.38.32\n- [Release notes](https://github.com/bytecodealliance/rustix/releases)\n- [Commits](https://github.com/bytecodealliance/rustix/compare/v0.38.13...v0.38.32)\n\nUpdates `webpki` from 0.22.1 to 0.22.4\n- [Commits](https://github.com/briansmith/webpki/commits)\n\nUpdates `whoami` from 1.4.1 to 1.5.1\n- [Changelog](https://github.com/ardaku/whoami/blob/v1/CHANGELOG.md)\n- [Commits](https://github.com/ardaku/whoami/compare/v1.4.1...v1.5.1)\n\nUpdates `whoami` from 1.4.1 to 1.5.1\n- [Changelog](https://github.com/ardaku/whoami/blob/v1/CHANGELOG.md)\n- [Commits](https://github.com/ardaku/whoami/compare/v1.4.1...v1.5.1)\n\nUpdates `webpki` from 0.22.2 to 0.22.4\n- [Commits](https://github.com/briansmith/webpki/commits)\n\nUpdates `whoami` from 1.4.1 to 1.5.1\n- [Changelog](https://github.com/ardaku/whoami/blob/v1/CHANGELOG.md)\n- [Commits](https://github.com/ardaku/whoami/compare/v1.4.1...v1.5.1)\n\n---\nupdated-dependencies:\n- dependency-name: h2\n  dependency-type: indirect\n  dependency-group: cargo\n- dependency-name: mio\n  dependency-type: indirect\n  dependency-group: cargo\n- dependency-name: openssl\n  dependency-type: indirect\n  dependency-group: cargo\n- dependency-name: rustix\n  dependency-type: indirect\n  dependency-group: cargo\n- dependency-name: webpki\n  dependency-type: indirect\n  dependency-group: cargo\n- dependency-name: whoami\n  dependency-type: indirect\n  dependency-group: cargo\n- dependency-name: whoami\n  dependency-type: indirect\n  dependency-group: cargo\n- dependency-name: webpki\n  dependency-type: indirect\n  dependency-group: cargo\n- dependency-name: whoami\n  dependency-type: indirect\n  dependency-group: cargo\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>","shortMessageHtmlLink":"Bump the cargo group across 3 directories with 6 updates"}},{"before":"88a2a6ee425261d2d70ec13c5b8e3c8b455fa353","after":"3163dbb7b04ecb06a4855d95ffb9c8263247888f","ref":"refs/heads/master","pushedAt":"2024-03-27T19:31:46.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"gabrielspadon","name":"Gabriel Spadon","path":"/gabrielspadon","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6691923?s=80&v=4"},"commit":{"message":"Update readme.rst","shortMessageHtmlLink":"Update readme.rst"}},{"before":"273964a83d788d22e0660dc2e690dcab9275e1f0","after":"4e182941bd83fe5983782314dadd0a3aa0a993ab","ref":"refs/heads/dependabot/cargo/cargo-security-group-0fc1d89af6","pushedAt":"2024-03-27T15:55:34.000Z","pushType":"push","commitsCount":8,"pusher":{"login":"gabrielspadon","name":"Gabriel Spadon","path":"/gabrielspadon","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6691923?s=80&v=4"},"commit":{"message":"Merge branch 'master' into dependabot/cargo/cargo-security-group-0fc1d89af6","shortMessageHtmlLink":"Merge branch 'master' into dependabot/cargo/cargo-security-group-0fc1…"}},{"before":"a6975c443c89ec83cc3eb848b86d1978bd7e9d1e","after":"88a2a6ee425261d2d70ec13c5b8e3c8b455fa353","ref":"refs/heads/master","pushedAt":"2024-03-27T15:50:26.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"gabrielspadon","name":"Gabriel Spadon","path":"/gabrielspadon","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6691923?s=80&v=4"},"commit":{"message":"Update readme.rst","shortMessageHtmlLink":"Update readme.rst"}},{"before":"4c77340a42070c14e259ee5c274229d41377a813","after":"a6975c443c89ec83cc3eb848b86d1978bd7e9d1e","ref":"refs/heads/master","pushedAt":"2024-03-26T21:42:02.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"gabrielspadon","name":"Gabriel Spadon","path":"/gabrielspadon","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6691923?s=80&v=4"},"commit":{"message":"Update readme.rst","shortMessageHtmlLink":"Update readme.rst"}},{"before":"3742afc5a79c8143b6152a548a68e6e93d3ccd8a","after":"4c77340a42070c14e259ee5c274229d41377a813","ref":"refs/heads/master","pushedAt":"2024-03-19T16:39:44.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"gabrielspadon","name":"Gabriel Spadon","path":"/gabrielspadon","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6691923?s=80&v=4"},"commit":{"message":"Add file type preference and handling in parser\n\nAdded a new parameter 'type_preference' to customize file processing in the parser. Files get processed based on the preferred file type, enhancing flexibility and control in file handling. This parameter is also integrated with the decode_msgs function in decoder.py.","shortMessageHtmlLink":"Add file type preference and handling in parser"}},{"before":"721ab4e5d17e1aedc989a26d632a769a30c6424c","after":"3742afc5a79c8143b6152a548a68e6e93d3ccd8a","ref":"refs/heads/master","pushedAt":"2024-03-19T16:20:56.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"gabrielspadon","name":"Gabriel Spadon","path":"/gabrielspadon","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6691923?s=80&v=4"},"commit":{"message":"Change IM0 number data type to i64\n\nThe IM0 number field's data type has been updated from i32 to i64 in the db.rs file. This change is necessary to accommodate larger IM0 numbers, ensuring accurate database representations of these values.","shortMessageHtmlLink":"Change IM0 number data type to i64"}},{"before":"cb73b37c3a7b76132782460f4698dc07664014ff","after":"721ab4e5d17e1aedc989a26d632a769a30c6424c","ref":"refs/heads/master","pushedAt":"2024-03-19T14:29:49.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"gabrielspadon","name":"Gabriel Spadon","path":"/gabrielspadon","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6691923?s=80&v=4"},"commit":{"message":"Uncomment parsing functions in csvreader.rs\n\nThe parsing functions in the csvreader.rs file have been uncommented. Specifically, the 'mmsi', 'imo_number', and 'mothership_mmsi' fields are now being parsed as originally intended. This restoration is critical to enabling correct extraction of data from CSV files.","shortMessageHtmlLink":"Uncomment parsing functions in csvreader.rs"}},{"before":"7fa589be11d65cc40bfa8a5b18cc103c6cd12b4a","after":"cb73b37c3a7b76132782460f4698dc07664014ff","ref":"refs/heads/master","pushedAt":"2024-03-19T14:17:24.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"gabrielspadon","name":"Gabriel Spadon","path":"/gabrielspadon","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6691923?s=80&v=4"},"commit":{"message":"Comment out parsing functions in csvreader.rs\n\nThe parsing functions in the csvreader.rs file have been commented out. This was done for the 'mmsi', 'imo_number', and 'mothership_mmsi' fields to temporarily disable parsing of these fields. This change is expected to change how information is read from CSV files.","shortMessageHtmlLink":"Comment out parsing functions in csvreader.rs"}},{"before":"30f852063f107baaf3e1ae589bedcfd901ec8512","after":"7fa589be11d65cc40bfa8a5b18cc103c6cd12b4a","ref":"refs/heads/master","pushedAt":"2024-03-19T13:27:12.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"gabrielspadon","name":"Gabriel Spadon","path":"/gabrielspadon","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6691923?s=80&v=4"},"commit":{"message":"Update data parsing datatype in csvreader.rs\n\nChanged the data type for mmsi, imo_number, and mothership_mmsi to i64 in csvreader.rs. This change corrects the parsing process from the incoming csv data. It enhances data handling efficiency and prepares for further improvements on data parsing tasks.","shortMessageHtmlLink":"Update data parsing datatype in csvreader.rs"}},{"before":null,"after":"273964a83d788d22e0660dc2e690dcab9275e1f0","ref":"refs/heads/dependabot/cargo/cargo-security-group-0fc1d89af6","pushedAt":"2024-03-18T19:24:56.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"dependabot[bot]","name":null,"path":"/apps/dependabot","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/29110?s=80&v=4"},"commit":{"message":"Bump the cargo group across 1 directory with 5 updates\n\nBumps the cargo group with 5 updates in the / directory:\n\n| Package | From | To |\n| --- | --- | --- |\n| [h2](https://github.com/hyperium/h2) | `0.3.21` | `0.3.25` |\n| [mio](https://github.com/tokio-rs/mio) | `0.8.8` | `0.8.11` |\n| [openssl](https://github.com/sfackler/rust-openssl) | `0.10.57` | `0.10.64` |\n| [rustix](https://github.com/bytecodealliance/rustix) | `0.38.13` | `0.38.31` |\n| [webpki](https://github.com/briansmith/webpki) | `0.22.1` | `0.22.4` |\n\n\nUpdates `h2` from 0.3.21 to 0.3.25\n- [Release notes](https://github.com/hyperium/h2/releases)\n- [Changelog](https://github.com/hyperium/h2/blob/v0.3.25/CHANGELOG.md)\n- [Commits](https://github.com/hyperium/h2/compare/v0.3.21...v0.3.25)\n\nUpdates `mio` from 0.8.8 to 0.8.11\n- [Release notes](https://github.com/tokio-rs/mio/releases)\n- [Changelog](https://github.com/tokio-rs/mio/blob/master/CHANGELOG.md)\n- [Commits](https://github.com/tokio-rs/mio/compare/v0.8.8...v0.8.11)\n\nUpdates `openssl` from 0.10.57 to 0.10.64\n- [Release notes](https://github.com/sfackler/rust-openssl/releases)\n- [Commits](https://github.com/sfackler/rust-openssl/compare/openssl-v0.10.57...openssl-v0.10.64)\n\nUpdates `rustix` from 0.38.13 to 0.38.31\n- [Release notes](https://github.com/bytecodealliance/rustix/releases)\n- [Commits](https://github.com/bytecodealliance/rustix/compare/v0.38.13...v0.38.31)\n\nUpdates `webpki` from 0.22.1 to 0.22.4\n- [Commits](https://github.com/briansmith/webpki/commits)\n\n---\nupdated-dependencies:\n- dependency-name: h2\n  dependency-type: indirect\n  dependency-group: cargo-security-group\n- dependency-name: mio\n  dependency-type: indirect\n  dependency-group: cargo-security-group\n- dependency-name: openssl\n  dependency-type: indirect\n  dependency-group: cargo-security-group\n- dependency-name: rustix\n  dependency-type: indirect\n  dependency-group: cargo-security-group\n- dependency-name: webpki\n  dependency-type: indirect\n  dependency-group: cargo-security-group\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>","shortMessageHtmlLink":"Bump the cargo group across 1 directory with 5 updates"}},{"before":"d5f2b2ce147d8d75e62f75f7ccd97f81fe4b41df","after":null,"ref":"refs/heads/temporal-fix","pushedAt":"2024-03-18T19:23:44.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"gabrielspadon","name":"Gabriel Spadon","path":"/gabrielspadon","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6691923?s=80&v=4"}},{"before":"d016f3fe32f108644ae76fcc02237d1bdd823a44","after":"30f852063f107baaf3e1ae589bedcfd901ec8512","ref":"refs/heads/master","pushedAt":"2024-03-18T19:23:43.000Z","pushType":"pr_merge","commitsCount":4,"pusher":{"login":"gabrielspadon","name":"Gabriel Spadon","path":"/gabrielspadon","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6691923?s=80&v=4"},"commit":{"message":"Merge pull request #76 from AISViz/temporal-fix\n\nIncluding utc_second on the queries and tracks.","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2192917420\" data-permission-text=\"Title is private\" data-url=\"https://github.com/AISViz/AISdb/issues/76\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/AISViz/AISdb/pull/76/hovercard\" href=\"https://github.com/AISViz/AISdb/pull/76\">#76</a> from AISViz/temporal-fix"}},{"before":"7c17e0d3e9c660570f73ac912b22a8cc45fb3955","after":"d5f2b2ce147d8d75e62f75f7ccd97f81fe4b41df","ref":"refs/heads/temporal-fix","pushedAt":"2024-03-18T19:16:34.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"gabrielspadon","name":"Gabriel Spadon","path":"/gabrielspadon","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6691923?s=80&v=4"},"commit":{"message":"Version matching.","shortMessageHtmlLink":"Version matching."}},{"before":"d8f628817da0d92ba98e0440e386471c73a5cabd","after":"7c17e0d3e9c660570f73ac912b22a8cc45fb3955","ref":"refs/heads/temporal-fix","pushedAt":"2024-03-18T19:11:17.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"gabrielspadon","name":"Gabriel Spadon","path":"/gabrielspadon","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6691923?s=80&v=4"},"commit":{"message":"Version Rollback","shortMessageHtmlLink":"Version Rollback"}},{"before":"2d286e2584a24233ab055465acd327e9154b342f","after":null,"ref":"refs/heads/master-fix","pushedAt":"2024-03-18T18:06:24.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"gabrielspadon","name":"Gabriel Spadon","path":"/gabrielspadon","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6691923?s=80&v=4"}},{"before":"d016f3fe32f108644ae76fcc02237d1bdd823a44","after":"d8f628817da0d92ba98e0440e386471c73a5cabd","ref":"refs/heads/temporal-fix","pushedAt":"2024-03-18T18:06:15.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"gabrielspadon","name":"Gabriel Spadon","path":"/gabrielspadon","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6691923?s=80&v=4"},"commit":{"message":"Including utc_second on the queries and tracks.","shortMessageHtmlLink":"Including utc_second on the queries and tracks."}},{"before":null,"after":"d016f3fe32f108644ae76fcc02237d1bdd823a44","ref":"refs/heads/temporal-fix","pushedAt":"2024-03-18T18:02:30.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"gabrielspadon","name":"Gabriel Spadon","path":"/gabrielspadon","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6691923?s=80&v=4"},"commit":{"message":"Remove dynamic and static insert triggers\n\nThis commit removes the SQL functions 'dynamic_insert' and 'static_insert' that are used as triggers before inserting into the dynamic and static AIS tables respectively. Their references in CREATE statements were no longer needed. The removal of these obsolete functions simplifies the codebase and prevents any potential confusion.","shortMessageHtmlLink":"Remove dynamic and static insert triggers"}},{"before":"d8b9b50b73d2acd738aaf7d77cdd55116ea7c3d4","after":"2d286e2584a24233ab055465acd327e9154b342f","ref":"refs/heads/master-fix","pushedAt":"2024-03-12T19:45:58.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"gabrielspadon","name":"Gabriel Spadon","path":"/gabrielspadon","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6691923?s=80&v=4"},"commit":{"message":"Refactor filename parsing and enable debug logs\n\nThis commit modifies filename parsing methods in csvreader and decode modules for better efficiency. By using the 'rsplit_once' function instead of 'Path' struct methods, the parsing process is streamlined. The debug logs, previously commented out, are also enabled which will assist in tracking and debugging operations.","shortMessageHtmlLink":"Refactor filename parsing and enable debug logs"}},{"before":null,"after":"d8b9b50b73d2acd738aaf7d77cdd55116ea7c3d4","ref":"refs/heads/master-fix","pushedAt":"2024-03-12T19:20:25.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"gabrielspadon","name":"Gabriel Spadon","path":"/gabrielspadon","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6691923?s=80&v=4"},"commit":{"message":"Adjust filename parsing and enable debug logs\n\nThis commit updates the way filenames are parsed within csvreader and decode modules. Now, 'rsplit_once' function is used instead of 'Path' struct methods. Additionally, previously commented out debug logs have been enabled. The refactored filename parsing is more direct while debug logs will aid in tracing and debugging.","shortMessageHtmlLink":"Adjust filename parsing and enable debug logs"}},{"before":"2f06926122969140e0485a140421f1b0691d08b1","after":"d016f3fe32f108644ae76fcc02237d1bdd823a44","ref":"refs/heads/master","pushedAt":"2024-03-12T16:39:41.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"gabrielspadon","name":"Gabriel Spadon","path":"/gabrielspadon","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6691923?s=80&v=4"},"commit":{"message":"Remove dynamic and static insert triggers\n\nThis commit removes the SQL functions 'dynamic_insert' and 'static_insert' that are used as triggers before inserting into the dynamic and static AIS tables respectively. Their references in CREATE statements were no longer needed. The removal of these obsolete functions simplifies the codebase and prevents any potential confusion.","shortMessageHtmlLink":"Remove dynamic and static insert triggers"}},{"before":"b1ab0fa2ab3a3e5c0088ac516a428c6dbdb9626b","after":"2f06926122969140e0485a140421f1b0691d08b1","ref":"refs/heads/master","pushedAt":"2024-03-12T16:36:10.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"gabrielspadon","name":"Gabriel Spadon","path":"/gabrielspadon","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6691923?s=80&v=4"},"commit":{"message":"Remove obsolete dynamic and static trigger SQL functions\n\nThe dynamic and static trigger SQL functions were removed in this commit, as they were no longer needed. Similarly, corresponding references to these functions in the 'decoder.py' file have also been removed. This cleanup helps to prevent any potential confusion that could occur from maintaining obsolete code.","shortMessageHtmlLink":"Remove obsolete dynamic and static trigger SQL functions"}},{"before":"1fd0584cf7b59b752684d78ba9035662ffd2de2e","after":"b1ab0fa2ab3a3e5c0088ac516a428c6dbdb9626b","ref":"refs/heads/master","pushedAt":"2024-03-12T16:14:23.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"gabrielspadon","name":"Gabriel Spadon","path":"/gabrielspadon","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6691923?s=80&v=4"},"commit":{"message":"Refactor calculations and ensure proper data typecasting\n\nThis revision addresses issues concerning data typecasting in our database operations, particularly changing the 'mmsi' and 'imo_number' attributes to integers. Moreover, it simplifies calculations within the worker count determination logic by directly importing 'min' along with 'max'.","shortMessageHtmlLink":"Refactor calculations and ensure proper data typecasting"}},{"before":"b30fa50078b22ff3e30f3206c2f2a0328f35f6d0","after":null,"ref":"refs/tags/1.7.2a","pushedAt":"2024-03-12T14:39:00.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"gabrielspadon","name":"Gabriel Spadon","path":"/gabrielspadon","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6691923?s=80&v=4"}},{"before":"b30fa50078b22ff3e30f3206c2f2a0328f35f6d0","after":"1fd0584cf7b59b752684d78ba9035662ffd2de2e","ref":"refs/heads/master","pushedAt":"2024-03-12T14:38:40.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"gabrielspadon","name":"Gabriel Spadon","path":"/gabrielspadon","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6691923?s=80&v=4"},"commit":{"message":"Merge pull request #74 from AISViz/master-fix\n\nRefactor code and improve SQL schema for performance","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2181679147\" data-permission-text=\"Title is private\" data-url=\"https://github.com/AISViz/AISdb/issues/74\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/AISViz/AISdb/pull/74/hovercard\" href=\"https://github.com/AISViz/AISdb/pull/74\">#74</a> from AISViz/master-fix"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEWlDbfAA","startCursor":null,"endCursor":null}},"title":"Activity · AISViz/AISdb"}