Skip to content
Snippets Groups Projects
  1. Aug 04, 2023
  2. Jul 27, 2023
  3. Jul 25, 2023
  4. Jul 24, 2023
  5. Jul 23, 2023
  6. Jul 22, 2023
  7. Jul 20, 2023
  8. Jul 17, 2023
  9. Jul 15, 2023
  10. Jul 13, 2023
    • Mario Oenning's avatar
      fix: /rss lazy load issue & perf improvements · 27819b44
      Mario Oenning authored
      
      Some fixes for the /rss endpoints
      
      * Load all data in one go:
      Previously data was lazy loaded thus it made several sub-queries per
      package (> 200 queries for composing the rss data for a single request).
      Now we are performing a single SQL query.
      (request time improvement: 550ms -> 130ms)
      This also fixes aurweb-errors#510 and alike
      
      * Remove some "dead code":
      The fields "source, author, link" were never included in the rss output
      (wrong or insufficient data passed to the different entry.xyz functions)
      Nobody seems to be missing them anyways, so let's remove em.
      
      * Remove "Last-Modified" header:
      Obsolete since nginx can/will only handle "If-Modified-Since" requests
      in it's current configuration. All requests are passed to fastapi anyways.
      
      Signed-off-by: default avatarmoson <moson@archlinux.org>
      Verified
      27819b44
  11. Jul 10, 2023
  12. Jul 09, 2023
  13. Jul 08, 2023
  14. Jul 04, 2023
  15. Jul 02, 2023
    • Mario Oenning's avatar
      perf: add index to tweak our default search query · 7c8b9ba6
      Mario Oenning authored
      
      Adds an index on PackageBases.Popularity and PackageBases.Name to
      improve performance of our default search query sorted by "Popularity"
      
      Signed-off-by: default avatarmoson-mo <mo-son@mailbox.org>
      Verified
      7c8b9ba6
    • Mario Oenning's avatar
      perf: tweak some search queries · c41f2e85
      Mario Oenning authored
      
      We currently sorting on two columns in different tables which is quite
      expensive in terms of performance:
      MariaDB is first merging the data into some temporary table to apply the
      sorting and record limiting.
      
      We can tweak a couple of these queries by changing the "order by" clause
      such that they refer to columns within the same table (PackageBases).
      So instead performing the second sorting on "Packages.Name", we do
      this on "PackageBases.Name" instead.
      This should still be "good enough" to produce properly sorted results.
      
      Signed-off-by: default avatarmoson-mo <mo-son@mailbox.org>
      Verified
      c41f2e85
  16. Jun 22, 2023
  17. Jun 16, 2023
    • Mario Oenning's avatar
      fix: restore command, remove premature creation of pkgbase · 143575c9
      Mario Oenning authored
      
      We're currently creating a "PackageBases" when the "restore" command is executed.
      
      This is problematic for pkgbases that never existed before.
      In those cases it will create the record but fail in the update.py script.
      Thus it leaves an orphan "PackageBases" record in the DB
      (which does not have any related "Packages" record(s))
      
      Navigating to such a packages /pkgbase/... URL will result in a crash
      since it is not foreseen to have "orphan" pkgbase records.
      
      We can safely remove the early creation of that record because
      it'll be taken care of in the update.py script that is being called
      
      We'll also fix some tests. Before it was executing a dummy script
      instead of "update.py" which might be a bit misleading
      since it did not check the real outcome of our "restore" action.
      
      Signed-off-by: default avatarmoson-mo <mo-son@mailbox.org>
      Verified
      143575c9
    • Mario Oenning's avatar
      housekeep: Amend .gitignore and .dockerignore · c6c81f07
      Mario Oenning authored
      
      Prevent some files/dirs to end up in the repo / docker image:
      * directories typically used for python virtualenvs
      * files that are being generated by running tests
      
      Signed-off-by: default avatarmoson-mo <mo-son@mailbox.org>
      Verified
      c6c81f07
  18. Jun 15, 2023
  19. Jun 11, 2023
  20. Jun 10, 2023
  21. Jun 08, 2023
  22. Jun 07, 2023
  23. May 27, 2023
Loading