Adsbdb Versions Save

2024-05-07

Chores

• dependencies updated, [31c7a498cd0468340ffc387b77cff06f5953c0bf], [83f819b9cd751ffd20039b2e58a912b1e6c6b96e], [da394df9908a1dc124cb228de14111ad4c9a851b], [f0f604d6f418eaca2fdeefddd38ce2c3c9a7473a]
• .devcontainer use Ubuntu, [cbbd5540409141f12759d0ae95e474a635f42073]

Fixes

• only print ratelimit details if % UPPER_LIMIT, [8d51bbe73026fac1a234e5d3a57015d2eae990a5]
• site random callsign fix, [838f9a94a7d3bdf34ff42eda4f2a0211d20f79e1]

Tests

• dependency change for redis method, [7d67aaba6093a0eda1ac34562776f51decea8756]

see CHANGELOG.md for more details

2024-04-10

Chores

• docker-compose version removed, [cb3f8ece38daa8fff6b8f1fb7004f104f2cd920a]
• dependencies updated, [40421977e9804241806721e53cabe96b777d5a09]

Features

• use mimalloc, [f3eef71e4a9d960f6328ca9a840a3aec9abbcc1f]
• website updated, [a84bc0221ffafa1993de41c4b87e3f1adbe349bf]

Fixes

• site html typo, [ed01451803bce87014ba41540853884570154660]
• Breaking Change registered_owner_operator_flag_code is now an Option<String>, this was necessary due to the new data insertions as detailed below, [55da40f831ddeeab1fa1ebb9c1d9afd918fffd00]

New Aircraft

The number of aircraft that adsbdb contains has been expanded from 191872 to 414002, an increase of 222130. This can be broken down by country of origin to;

17 Switzerland, 25 Netherlands, 31 Singapore, 55 Isle of Man, 227 Ireland, 265 France, 840 China, 12335 Australia, 14388 United Kingdom, 18011 Canada, and 173358 United States of America. There is also an insertion of 2578 from miscellaneous sources.

The vast majority of this data comes from the Civil Aircraft Registries of the respective countries. However not all data from these registries is included, either due to missing data fields, or in the case of mainly the American and Canadian registries, typos – far too many typos to try to correct.

Flight route & other data

The flight routes coverage has also been improved, from 171907 to 250892, an increase of 78985. To supplement this, 381 airlines and 25 airports have also been inserted.

If you are aware of any more aircraft registries available for download, or find any errors that will have undoubtedly snuck in, please feel free to report them to the GitHub Issues page

see CHANGELOG.md for more details

2024-02-16

Chores

• dependencies updated, [07b38338c9223f9a6fe379dc0d946724b95cdf16]
• create_release v0.5.5, [4711e65788641d926f241bc217154a74539d96ee]

Features

• store cache in redis hash, [5b60a49d052af71000eac01e3b1f0acab000b43d]
• display package name & version at application start, [b421f1e8ef502197c31d66ab332fd44036461edc]

Refactors

• use &ApplicationState, [00b02733acf90da791e6994739c7b9b9946015d5]
• sql queries formatted, [131570df01eab1d9129fd2e6c4b4b501529f42e6]

see CHANGELOG.md for more details

2024-02-09

Chores

• create_release v0.5.2, [9915bb745e39b6fc3d51f2875677d8bb284f96d5]
• run.sh v0.2.0, [960854b2119ef8d264facb5a259de5202bcb148a]
• .devcontainer updated, [51bf7c33859a8bac38579f5208391e07ae7175c6], [a5407118d6e45afd6165a4a8ec2858c04d436e96]
• dependencies updated, [b16951bdfb566a3120899e66ecb7f1a3e3003bda], [e1254ad31e431cd2485871c58e8e7c2314f4ac77], [dc9db787e0731d5c7db66b9a512df3f6cad5a1dd], [1427c4722173e5cece9b18a39229c93198166698]

Features

• change redis client to Fred, [df40d99430fbfc9a8610f56496bc23ab57064365]
• matrix cross platform GitHub build, [eb7daedf0197d09771f5a5814805ce9c7338ca22]

Fixes

• create_release sqlx prepare, [65d23c4f203f72f9c0e5c8d67bad171c007b071e]
• rate limit, closes #5, [7eb709ad18511197ff4c534b88d68e1e48b59ca1]

Refactors

• sql files linted, [e51cfceb3d11ba7d5f1e00865ddde92109c649d3]
• DockerFiles cleaned up, [77dc017b9c490e13e3fd0a1254f40c307c09aa13]

see CHANGELOG.md for more details

2024-01-05

Chores

• .devcontainer updated, [9f65dd57d285488ec0454dfdc979f09c2e9edc8c], [a6553e96e19845498df86d91ea98db006775b264]
• Alpine version bump, [218e6e5ac48436252d27222d1c1983cb0a027de7]
• dependencies updated, [4f6bb1266eaa4c8717e94d64d6c4705d83adcb07], [b242e2d4ef23d72245d1e09b38790727ec3a09bd], [ca17710265bb45714655cfee8c6df631ca6d994d]
• file linting, [815cde77e5bbc56421e3cf3bb7a63a9c0f8c6882]
• Rust 1.75.0 linting, [83a687872c3069cd1364aadbf88f3b9b8d45d57f]

Features

• run.sh v0.1.0, [fbdd1a9423772b27a53d1d35c5b479f180dd3818]

Fixes

• ApiError import/export,[0400ab66f8f877658830b57d85664415f4b649b3]
• .gitattributes(?), [b238df27d297b11254ce5a419225cae89c9c307d]
• redis dependency updates, [e6da9e0a0a60862ee0eaba3f929da320792bcd82]
• scraping error message more detail, [a3a1263f32a9afded8fc27d93779823d91549dd2]

Refactors

• dead code removed & re-ordered, [9d6d51bb5473d1752dd24b516772caca968f0d6a]

Reverts

• graceful shutdown re-introduced, [2fa3c1cc95b553197954a989e3e6f7a26115c90e]

Tests

• ratelimit tests improvement, [cbd7bb78b24711cf4c004b4679ed9d9599ca38fd]

see CHANGELOG.md for more details

2023-11-28

Chores

• dependencies update, lints into Cargo.toml, [ce5b724aa2f2623c3503515eaac8e5e3757e4713], [266886505783ab6ceec1a2ac1dd7b5aecdb588ec]
• update PostgreSQL to v16, [bd409cde79e78e068e1f15a73ae04ec57b16b8bb], [1519d7319ec7c2eed3fece726507a69311747e76]
• update axum to 0.7, [a9772d253b77f9b687b207afda85f5306158cd1e], [c4232dd640d67682b5d332854752b78b6a3ea75b]
• .devcontainer updated, [101da4d3fc8829b49d339091840a30099ce17e7d], [abcc5d0bc5ece7865d46cc41d6999212083bb8ab], [2cb9599205f1852b7203b285e0faadc5f42bba02]
• Rust 1.73 linting, [f84617fb22d97dc44966f97cfbfc84ef85036ba2]
• dependencies updated, [c7ab1ecb0e54dc077bf1999e505a5625efe70fb7], [3c714e59f80cc01a2917bdc7b605c417736a716d]
• adsbdb.com site updated, [5e6b74af34e4a3adfffb7ab7c66c1ca251bc6146]

Features

• ApplicationState placed into an Arc, [47287de8703e0bb9386a90dd7d9f7d82bb05f208]
• Track scrapers in a hashmap, [88cca3b0274b4b53d8cd63d130c3dc34994d4437]
• ModelAirline & ModelFlightroue use PgPool instead of transaction, [ddf06c08427fd4184af94fdf27842e8ea914d8dc]
• &String -> &str, [c3eef0d9236472b240e03900dd5005e1a66fd2ac]

Fixes

• ModelFlightRoute function call, [980fde0ddbe1fbaa829aebcd7aaed5350d16a82f]
• ratelimit attempted fix, [51fdf56994ae0288ccad2d532397ae5654aee507]

Refactors

• redis_to_serde tracing, [0a52063688e02fc7ff477718fed83c1eaff53e3f]

see CHANGELOG.md for more details

2023-08-26

Chores

• Rust 1.72.0 linting, [459d3c5632496c954622107f6f1845e4da9545a0]
• dev container psql install, .docker/config delete, [b9dc0b893f5054d0c5313de75eaf5553ef6ccada], [9c32aaf419f76917c9d8050252e0519f716e4695]
• dependencies updated, [9773f097097b47636d697ef44941a8c43c034d61], [05f522fbf1b5fdedabb25a8e8e32d968ec635cde]

Fixes

• correctly copy .sqlx files into container, [6e76d6176336ba69527b0dbb146b8ec3711f699d]

Test

• scraped transaction callsign change, [22c67fc71e08548fe3929214bfc67fb09825c19b]

see CHANGELOG.md for more details

2023-07-29

Chores

• create_release 0.3.0, [0942f4b0fe3fa83a7b0f6b70476f61f571b508cf]
• dependencies updated, [65a1ce2d4d024e1292bc627b80d38ed1bf28f61f]

Features

• rate limits increased, lower: 120 -> 512, upper: 240 -> 1024, [49af6b2970f88e0b097e90e76aa4598bab0e0df8]
• sqlx logging based on env level, [e7d256488d78670bd999e5be0fdadd859e4912c1]

Fixes

• copy sqlx prepared files into api.Dockerfile, [9ed3944cd8a35e65b86696844db079d562b77669]

see CHANGELOG.md for more details

2023-06-11

Chores

• dependencies updated, [109c7a72ef21652b3269fd3a86c0d5842c3ebf70], [66eee54ede84af8cd0a5e18ae9c51186ebb3a724], [88fd8d7447d67c7eae879722c4669cf1032240f9], [c827db21e6375e964e9e39dfa48fced6964bdc27], [e94098e48cd5bafbf8b4fef93b06d52a65f4033e], [fcec134f6e05ddee4accfd7ead4e2c608e646c00]
• Dockerfiles Alpine bump to 3.18, [4f55f7c63ce0fec02aacc6b18bcfc0a80bec2f2b]
• sqlx prepare, [6057dce2c6a9fce7b5d3df72f907a1cd4d95f2fa], [e8139a9da2d344211a73e8cdf46703c453d940c4], [e355807c706cc807c61d82c8ddeb14039911d74f]

Docs

• CONTRIBUTING.md added, [676d06f6a7a1766b58d1b2bbd9f240afc0726956]
• GitHub data issue add source, [4ae44c25716a29eb81e02c2142e4ac5fffa87f29]

Features

• define_routes macro, [8daf85854e49784294580f961ae0b9ae47444d44]
• sleep macro, [21f1b81a2a02cbc8a170c52d4a7b3961ec067642]
• unit_struct & from_request_parts macros, [61e2391c59ed36870b8aaa2640002db6b2024bc2], [6e52dc267bb06fc96341d73662ccff6dfb8a445e]
• app_error internal! macro, [c3f497171b387c36a26429e100c0e2113124fd3a]
• create_release prepare sqlx, [f05b6b15ee87c4e391bbf9758361d495e69415af]
• devcontainer install sqlx-cli, [1403434d1f0e36452ba9f3f4d8b6923b06eb5225]
• from_request_parts macro, [c5a5e2e6c49b4f40510099ae6a4815ce9e46f41b]
• ModelAirport use macro, [c9d01503c5d18a20eb25cd7cf45b97cf3f128e68]
• ModelAircraft use macros, [ab72f2eba49d768f9ef998cadd12cb1f91b895e6]
• ModelAirline use macro, [6619fe9b4638d5d81e35a105092e1780b371164f]
• ModelAirport query improved, [b9d603c85d856cb2b80cf02283e677872e59224a]
• ModelFlightroute, use JOINS rather than subqueries, [3d31ec2a7bef3398d6b35352c3a43a09dc01bf84]

Fixes

• GitHub workflow use regex for semver tag, [de75904774749346af87b73e5eae0234c61b368a]
• nursery redis drop lint, [535f1eee02bca5df9387803fc7bb64eede04e630]

Refactors

• dead code removed, [91a4a4043c0da7d0c68c132e6442e144aa30daf8]
• methods renamed, [16337e76f140731c953f35fa71239fcb740803ff], [23686cecbe8eef8a6e702176098ee7faf187cf98]
• ModelFlightRoute query refactors, and macros, [1c296a1b7fed5c9e83bf53501948c4a9ccd1f12f]
• mods moved, [03606946cd0ad159a12dc40692df0d504c4ff4aa]
• ModelFlightroute sql query into parts, [cb78968befa521b1589ba4635c89e1c2e9db84ad]
• ModelFlightroute insert scraped flightroute use macros, [b64c34549e87f180f399f757a77edb05d4fe3659]

Reverts

• .devcontainer sparse protocol now default, [430ce92bebbc7e856612f80fcef754b507f2d426]

see CHANGELOG.md for more details

2023-03-13

Chores

• dependencies updated, [ac52eb8deb75c18a04ac13a8ba216b4df6ea84d8]
• devcontainer use sparse protocol index, [9e167c5fc830e0f2be312c027a5b235c73cb59e3]
• Rust 1.68.0 linting, [13352ff02bf9cab87c50c31f072c4a928f455120]

Fixes

• LIMIT 1 in sql queries, [9caa5824015616f954fff8d9ab6120b0d78cfed7]

see CHANGELOG.md for more details