Compile ES modules using Rollup

This PR uses Rollup to compile (not copy) ES modules into ./package/govuk-esm
It adds on to recent "Build tasks" work to unblock:

https://github.com/alphagov/govuk-frontend/pull/3318

To track what was mentioned in the dev catch-up, the hoisting of deep imports may have impacts on tree-shaking, which need looking into.
In our current package, import {Accordion} from 'govuk-frontend' will only bring the polyfills necessary for the Accordion.
However with the polyfills of all components being hoisted when building all.mjs, it's likely polyfills that the Accordion doesn't need will be drop would end up in the final bundle (especially as our polyfills are not pure), so we'll need to check what happens there.

@romaricpascal That's a great point
Thankfully the hoisted imports in all.mjs (from this PR) continue to be tree shaken away 🎉
Below is some testing from our webpack example using only { Button } via import/require
Bundling via import from copied files
File sizes for main.min.js with webpack resolving package/govuk-esm/* copied ES modules
14KB — Button polyfills only
import { Button } from 'govuk-frontend'

import { Button } from 'govuk-frontend/govuk-esm/all.mjs'

import Button from 'govuk-frontend/govuk-esm/components/button/button.mjs'

Bundling via import from Rollup es output
File sizes for main.min.js with webpack resolving package/govuk-esm/* compiled ES modules
14KB — Button polyfills only
import { Button } from 'govuk-frontend'

import { Button } from 'govuk-frontend/govuk-esm/all.mjs'

import Button from 'govuk-frontend/govuk-esm/components/button/button.mjs'

Bundling via require() from Rollup umd output
File sizes for main.min.js with webpack resolving package/govuk/* compiled UMD modules
50KB — All polyfills included
const { Button } = require('govuk-frontend')

const { Button } = require('govuk-frontend/govuk/all.js')

12KB — Button polyfills only
const Button = require('govuk-frontend/govuk/components/button/button.js')

I've completed testing in Rollup with npm link on a local build of GOV.UK Frontend
Good news, JavaScript output is identical
Source map content appears to be the Rollup-transformed ES module code (with semicolons inserted etc) but this is likely the Design System @rollup/* plugins needing an "input source map" config to find the original source


docker image does not include libffi.so.6 needed for Python 3.11

Description:
libffi.so.6 is missing from the python3.11 latest image

using vscode launch config to run sam local invoke create the image and acquires public.ecr.aws/sam/emulation-python3.11. after mounting the image and starting the code, if fails to start the session and the output presents
Traceback (most recent call last):   File "/tmp/lambci_debug_files/py_debug_wrapper.py", line 46, in <module>     runpy.run_module('debugpy', run_name='__main__')   File "<frozen runpy>", line 229, in run_module   File "<frozen runpy>", line 88, in _run_code   File "/var/task/debugpy/__main__.py", line 37, in <module>     from debugpy.server import cli   File "/var/task/debugpy/server/__init__.py", line 7, in <module>     import debugpy._vendored.force_pydevd  # noqa     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   File "/var/task/debugpy/_vendored/force_pydevd.py", line 44, in <module>     preimport('pydevd', [   File "/var/task/debugpy/_vendored/__init__.py", line 126, in preimport     import_module(name)   File "/var/lang/lib/python3.11/importlib/__init__.py", line 126, in import_module     return _bootstrap._gcd_import(name[level:], package, level)            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   File "/var/task/debugpy/_vendored/pydevd/pydevd.py", line 45, in <module>     from _pydevd_bundle import pydevd_utils   File "/var/task/debugpy/_vendored/pydevd/_pydevd_bundle/pydevd_utils.py", line 9, in <module>     import ctypes   File "/var/lang/lib/python3.11/ctypes/__init__.py", line 8, in <module>     from _ctypes import Union, Structure, Array ImportError: libffi.so.6: cannot open shared object file: No such file or directory 05 Dec 2023 21:07:19,654 [ERROR] (rapid) Init failed error=Runtime exited with error: exit status 1 InvokeID=
Steps to reproduce:
attached is a zip file of the sample lambda created with sam init  (Note: I included 3.11, and 3.9 venv for reference)
lambda-test.zip
actions to produce the error
1- in the template .yaml; change the  function Runtime: from  python3.9 to python3.11
2- from vscode debug, launch lambda-test:HelloWorldFunction (python3.11)
Note: the error disappears when launch vscode after changing the Runtime to  python3.9 in template.yaml
Additional environment details (Ex: Windows, Mac, Amazon Linux etc)

OS: MacOS
If using SAM CLI, sam --version: 1.99.0
AWS region: us-east-1

Hi, thanks for bringing up the issue. It seems that https://gallery.ecr.aws/lambda/python made a release that has issues and should be fixed next release. Until then we have a mitigation. As you can see in the documentation (https://docs.aws.amazon.com/toolkit-for-vscode/latest/userguide/serverless-apps-run-debug-config-ref.html), there is a field is launch.json sam properties called skipNewImageCheck. Add this to your launch.json and set it to be true. Then you have to manually delete the images on your docker locally, both public.ecr.aws/lambda/python:3.11-rapid-x86_64 and public.ecr.aws/lambda/python:3.11-x86_64. After deleting it, you can then pull an older version of the image on their website, for my example I used public.ecr.aws/lambda/python:3.11.2<IP_ADDRESS>-x86_64 (change architecture to match yours). After that you have to retag the image to the x86-64 tag itself. Therefore the command should be docker tag <YOUR IMAGE ID> public.ecr.aws/lambda/python:3.11-x86_64. After that, running the debugger should work properly.
After running the steps this is what a sample launch.json and docker images command should output:
{     "configurations": [         {             "type": "aws-sam",             "request": "direct-invoke",             "name": "test",             "invokeTarget": {                 "target": "code",                 "projectRoot": "hello_world",                 "lambdaHandler": "app.lambda_handler"             },             "lambda": {                 "runtime": "python3.11",                 "payload": {},                 "environmentVariables": {}             },             "sam": {                 "skipNewImageCheck": true             }         }     ] }
docker images command ouput:
public.ecr.aws/lambda/python   3.11-x86_64                 3e02a31fb67a   2 weeks ago     752MB public.ecr.aws/lambda/python   3.11.2<IP_ADDRESS>-x86_64   3e02a31fb67a   2 weeks ago     752MB
Please let me know if you have any questions or any issues still. Thanks

Hi,
1- the mitigation is working for me, thank you!. I did not test the updated image yet
2- buildArguments


I want to add my profile here.

Please do assign it to me so that i can contribute to DevDisplay.
I will follow the Rules and code of Conduct.
Add the labels Gssoc-ext and Hacktoberfest.

Hi @Rupali1104 , thanks for your interest in contributing to DevDisplay!
You will be assigned now add you profile here and be sure to star the DevDisplay GitHub Repository. 🌟
💌 This is a mandatory step for all contributors. & It's is the first priority of contribution in DevDisplay 💌
🚀 We look forward to your contribution once these steps are completed. 🚀
Thanks 👍🏻


Add entry point to docs

Hi @bckohan,
thank you for the very useful contribution to sphinx for parsing the typer documentation!
I'm managing to use it properly, but in my package I defined the CLI options in the __main__.py file and simply defined an entrypoint in my setup.py script.
entry_points={
        "console_scripts": ["toolname=toolname.__main__:main"],
    },

When building the documentation with sphinx I get though the __main__ string as the command and not the set up entry point.

Is there a way to configure the parsing for the documentation so that it considers this entrypoint?

Hi @ggabernet! I think the :prog: option is what you're looking for. Unfortunately with console scripts it can be hard to resolve the actual name, so the :prog: option can be used to manually set the script name.
Let me know if this works for you!

Hi @ggabernet If you were trying to generate the help for a specific subcommand and supplying the :prog: option I did just fix a bug #24 that may have produced the output you're seeing.


Don't show quickswap on NFT transfer

The 'Swap with Quickswap' shouldn't appear when the token is an NFT (there's a token.isNonFungible() method).
Here's a watch account with NFT's present: jsbrown.eth

Completed in #1989


Conflict with other mod

Prop control 1.0 does not work together with Node Controller Renewal 3.5
https://steamcommunity.com/sharedfiles/filedetails/?id=2472062376
The Mod F:\Steam\steamapps\workshop\content\255710\2956854293 [PropControl.dll] has caused an error [ModException]
Details:
System.NullReferenceException:
at (wrapper managed-to-native) UnityEngine.Component.get_transform () <0x00075>
at ColossalFramework.UI.UIComponent.get_cachedTransform () <0x00041>
at ColossalFramework.UI.UIComponent.get_tooltipBox () <0x00042>
at PropControl.StatusPanel.UpdateTooltips () <0x00285>
at PropControl.StatusPanel.Refresh () <0x000a1>
at PropControl.Patches.PropToolPatches.set_AnarchyEnabled (bool) <0x0003c>
at PropControl.Loading.LoadedActions (ICities.LoadMode) <0x00058>
at AlgernonCommons.LoadingBase1.OnLevelLoaded (ICities.LoadMode) <0x00305> at AlgernonCommons.Patching.PatcherLoadingBase2.OnLevelLoaded (ICities.LoadMode) <0x002fe>
at (wrapper dynamic-method) LoadingWrapper.LoadingWrapper.OnLevelLoaded_Patch4 (LoadingWrapper,SimulationManager/UpdateMode) <0x000d4>

I have been using the two together for myself for some time now without issue, and so have many others.
You have only posted an error message which is meaningless out-of-context; please provide your full output log.

Hi,
I was not able to get any output log, or I dont know where to find it in official paths.
Anyway the issue was resolved by one of the solution below:

Unsubscribing Metro Overhaul Mod (MOM) and all its dependecies

Since MOM is buggy for latest game version 1.17.1
Alternative exists in form of assets so I subscribed to that instead.

OR

Installing Loading Screen Mod Revisited 1.1.9 mod

This mod will make both MOM and propControl work together. However MOM is still buggy by itself.

Yes, MOM can be problematic, and is generally recommended not to be used any more.  I'm glad you got the issue sorted (and I'm assuming you're aware of Skyve and its mod reporting capabilities to help identify problem mods and suggest replacements).
For future reference, here's a guide on where to find the output log.


mounter(ticdc): fix truncate table partition cause mounter failed issue

What problem does this PR solve?

Issue Number: close #10522
What is changed and how it works?
like truncate table logic,  when a table partition is truncated ,  CDC should add this partition ID to the memory map, then get a key encoded by this partition ID,  mounted should ignore it,  otherwise mourner will  failed to decode the key.
Check List
Tests

Unit test
Integration test
Manual test (add detailed scripts or steps below)
No code

Questions
Will it cause performance regression or break compatibility?
Do you need to update user documentation, design documentation or monitoring documentation?
Release note
`None`.

/retest-required

/retest-required

/retest-required


Automatically redeploy to production after submodule update

When there is an update to the template submodule @dvcs/gitignore, gitignore.io should automatically pull the latest update and deploy to staging and production.

Fixed with the following commits

Add travis build parent script - https://github.com/dvcs/gitignore/commit/8ca390d37c7f5c4b06b3f88f3bbf663617b6ac5e
Added update submodule script- https://github.com/joeblau/gitignore.io/commit/fd4e65d8c62fd3bf931c3f1ae5498f7c0067f987
Update travis before install script -https://github.com/joeblau/gitignore.io/commit/296067740c2bf3ddd3c8e256a9564f03b3f437cb
Update travis credentials - https://github.com/joeblau/gitignore.io/commit/336dc1bc744b57f5a23882b7544ca56896a8bfba
Remove quotes around script - https://github.com/joeblau/gitignore.io/commit/44cd1ca92e38dbac830dd28c2a2ef5c06d41ad13

The new result is anytime aa pull request is landed on dvcs/gitignore, Travis-CI will automatically update this repository and deploy to Heeroku's staining environment.


fix: annoying dockerfile errors and tsc fallback

hi

now that we're there we should just run npm i -g typescript for ppl like me who forget to add it as a devDependency or as a CLI command

do you think adding as a devDependency in docker is better and then we can just do
tsc || npx tsc "./tsconfig.json" --build

Does this still need to be worked on or to be reviewed @jacoobes ?

yeah, still looks mergeable

will rebase this soon after I complete my work

@SrIzan10 could you re-create this in new pr please, looks like rebasing will be hell 💀

it can still be mergeable, the dockerfiles hasn't been modified since last year


Switch camera and torch button

Hello everyone,
I'm using this plugin in an Ionic project (it's great, thanks!) but I have an issue. When I try to show the 'switch camera' and 'torch' button, it doesn't work. I have included some code of my controller where I specified these options.
Expected Behaviour
See a button for switching camera and for the flashlight
Actual Behaviour
There's no button for switching the camera and for the flashlight
Platform and Version (eg. Android 5.0 or iOS 9.2.1)
iOS 10
Cordova CLI version and cordova platform version
cordova --version:
6.2.0
cordova platforms:
android 5.1.1
ios 4.1.1
Plugin version
cordova plugin version | grep phonegap-plugin-barcodescanner:
phonegap-plugin-barcodescanner 6.0.5-dev "BarcodeScanner"
Sample Code that illustrates the problem
    $scope.scanBarcode = function() {
        $cordovaBarcodeScanner.scan().then(function(imageData) {

            $scope.scanned = imageData.text;
            console.log("Barcode Format -> " + imageData.format);
            console.log("Cancelled -> " + imageData.cancelled);
        }, function(error) {
            console.log("An error happened -> " + error);
        },
        {
          "showFlipCameraButton" : true, // iOS and Android
          "showTorchButton" : true // iOS and Android
        });
    };

Looks like you're passing the options to the Promise result rather than the plugin.. look carefully at the empty scan() call.

@EddyVerbruggen Thank you for your answer!  Works like a charm now! :)


Add more details in README.md

Please consider adding below content in the README.md file:

Add reference links on top
For more information about TollApp sample, please see Build an IoT solution by using Stream Analytics.
For more information about the Stream Analytics service, see http://azure.microsoft.com/en-us/services/stream-analytics/

Add introduction section, content can be copied from introduction and scenario introduction of  Build an IoT solution by using Stream Analytics.

Add short description of folder structure of this repository.

Add detailed setup steps

Add one-step validation to check if the setup is successful (e.g. if see data in COSMOS DB).

Readme updated for review.


Add tfupdate

https://github.com/minamijoyo/tfupdate

This is probably not needed for now since we always pin the terraform version using a >= and now with 1.0.0 we don't have to worry about state and version issues.


Fix placeholder text issue on Safari.

Connects #167
The combination of line-height and height for the text boxes was causing the
placeholder text to show up near the button of the input box on Safari.
Removing a forced height resolves this.
To test:

Open uploader modal in safari
Check that placeholder text is visible.

+1, tested.


Update HTTP3 Sample for RC1

Reflects the more streamlined behavior. We should publish this when RC1 is shipped on the 14th, and reference it from https://github.com/aspnet/specs/pull/602 (CC @danroth27).
Fixes https://github.com/dotnet/aspnetcore/issues/34488

@wtgodbe  I wanted to mark it as draft so it doesn't accidently get merged before the 14th

@wtgodbe I wanted to mark it as draft so it doesn't accidently get merged before the 14th

My mistake, I didn't see that you had marked it as a draft, I thought that was the default state. Feel free to switch it back to a draft

@wtgodbe  we have an https://github.com/dotnet/AspNetCore.Docs/tree/RC1 branch now  if you have anymore PR's. I'll wait for RC1 to merge this.


process.env.npm_config_user_agent

pnpm/pnpm/issues/3985
cli direct know which package manager use for install deps

https://stackoverflow.com/questions/68133683/is-there-a-cross-platform-way-to-get-the-name-of-the-parent-process-in-node-js


[BigQuery] Routines ETag not being used by the backend for avoiding concurrent updates.

There's an internal issue filed against the backend. And our own integration test is currently being skipped, we just need to unskipped it once the backend has fixed the issue.

This has been fixed by the API team. Waiting on the fix to be rolled out. As soon as it is I'll unskip the test and close the issue.


Use the container registry credentials to build images with the local image builder

Describe changes
When a custom base image is used to build container images for containerized orchestrators, the base image can also be a private container image coming from the same container registry where the resulting image is pushed. In this case, linking the container registry to a service connector doesn’t authenticate the Docker client in the image building phase, so authentication errors will occur.
Pre-requisites
Please ensure you have done the following:

[ ] I have read the CONTRIBUTING.md document.
[ ] If my change requires a change to docs, I have updated the documentation accordingly.
[ ] If I have added an integration, I have updated the integrations table and the corresponding website section.
[ ] I have added tests to cover my changes.

Types of changes

[ ] Bug fix (non-breaking change which fixes an issue)
[ ] New feature (non-breaking change which adds functionality)
[ ] Breaking change (fix or feature that would cause existing functionality to change)
[ ] Other (add details above)

Maybe long-term the image builder could instead be linked to a different docker service connector to pull the image from?

Maybe long-term the image builder could instead be linked to a different docker service connector to pull the image from?

@schustmi I also thought of that, but should that be symmetric then and also use the image builder service connector to push images ? Doesn't that completely replace the container registry ?

I was actually thinking that we should maybe have it to allow the asymmetry of pulling from/pushing to different container registries. However that might actually be solvable also by having different container registries in the stack and not tying the image builder to a container registry.


E492: Not an editor command: NeoBundle

Hi
I installed neobundle with your script and copy recommended vimrc to my vimrc. here it is:
syntax enable

"NeoBundle Scripts-----------------------------
if &compatible
  set nocompatible               " Be iMproved
endif

" Required:
set runtimepath+=~/.vim/bundle/neobundle.vim/

" Required:
call neobundle#begin(expand('~/.vim/bundle/'))

" Let NeoBundle manage NeoBundle
" Required:
NeoBundleFetch 'Shougo/neobundle.vim'

" Add or remove your Bundles here:
NeoBundle 'Shougo/neosnippet.vim'
NeoBundle 'Shougo/neosnippet-snippets'
NeoBundle 'tpope/vim-fugitive'
NeoBundle 'ctrlpvim/ctrlp.vim'
NeoBundle 'flazz/vim-colorschemes'

" You can specify revision/branch/tag.
NeoBundle 'Shougo/vimshell', { 'rev' : '3787e5' }

" Required:
call neobundle#end()

" Required:
filetype plugin indent on

" If there are uninstalled bundles found on startup,
" this will conveniently prompt you to install them.
NeoBundleCheck
"End NeoBundle Scripts-------------------------

set background=dark
let g:solarized_termcolors=256
colorscheme solarized

set tabstop=4     " a tab is four spaces

set backspace=indent,eol,start

set autoindent    " always set autoindenting on

set smarttab      " insert tabs on the start of a line according to

set hlsearch      " highlight search terms

set background=dark
set t_Co=256

set number " show line numbers

set showcmd " show command in bottom bar
set mouse=a

set cursorline " highline current line

filetype indent on " load filetype-specific indent file

set wildmenu " visual autocompelete for command line

when I type :NeoBundlelist or any neobundle command I see to following erorr:
E492: Not an editor command: NeoBundle
what should I do?

You should check neobundle is installed in ~/.vim/bundle/neobundle.vim/.

Apparently my .vim/.vimrc was not linked to ~/.vimrc. Problem solved.
thanks.

OK.


[Bug] query invalid node for python file

Starting with the merge of #176, I get the following message when I open a python file:

treesitter/highlighter: Error executing lua: ...im/0.8.0/share/nvim/runtime/lua/vim/treesitter/query.lua:219: query: invalid node type at position 5813 for language python
stack traceback:
[C]: in function '_ts_parse_query'
...im/0.8.0/share/nvim/runtime/lua/vim/treesitter/query.lua:219:

My system:
OS: macOS 12.6
nvim: v0.8.0 (from Homebrew)
nvim-treesitter conf:
require'nvim-treesitter.configs'.setup {
  ensure_installed = { "comment", "lua", "ruby", "python", "javascript" },
  sync_install = false,
  auto_install = true,
  highlight = {
     enable = true,
   },
   indent = {
     enable = true
   },
}

Oh no!
I wonder what would have caused this. The fact that we added a new node type (except_group_clause) seems like it shouldn't affect existing tree-sitter queries.
Could this perhaps be a version difference? One thing I did observe is that this bumped the LANGUAGE_VERSION (from 13 to 14) as defined in parser.c, and maybe there's an incompatibility here.
By the way, does this mean that neovim is using bleeding-edge tree-sitter-python -- i.e. working off of the latest main? If so, this seems... Brave. It might be a good idea to instead pin it to a SHA or version.

Could you try doing
:TSUpdate all

(as seen here: https://github.com/nvim-treesitter/nvim-treesitter/pull/3711). That might make the problem go away. 🤞

Could you try doing
:TSUpdate all

That did it; thanks!


Sierra Support ?

Hello,
Is there a way to add if #available(OSX 10.13, *) { to make it backward compatible ?
Thanks

There probably is, but it's not something I'm interested in doing or maintaining. Happy to link to a fork if anyone wants to maintain Sierra support though.


Background video playback is incorrectly paused

As of version 6.1.5 background video playback does not work correctly anymore. This is not related to the iOS version, as I first incorrectly assumed. This regression is likely connected to the fixes made for PiP in 6.1.5.
Issue type
Incorrect behavior
Environment information

Library version: 6.1.5
iOS: Tested with iOS 15.2
Device: Physical

Reproducibility
Always reproducible
Steps to reproduce

Open the demo.
Play some video with the inline player.
Detach the video layer and enabled detached background view behavior.
Send the app to the background. Playback incorrectly pauses.

The behavior is fixed if we remove the check for installation of the player view into a hierarchy.
I looked into the past to have a better understanding how this code ended up in the implementation. The final result was implemented between versions 4.0.0 and 5.0.0, mostly in response to issue #84, check commit 23e71041a60fa02479caa8599b8b45a8a0fa4dca and neighbouring ones from the merged feature/background-behavior-fixes branch.
Since everything is related to PiP I'll test PiP playback again (as the implementation changed completely for version 6.1.5 anyway), and all background modes as well. If everything works correctly I assume that the code was kept for safety reasons but was indeed not compatible with the new background detection approach introduced for version 6.1.5.

I could check PiP and background playback on iOS 14.8 and iOS 15.2, the fix works as expected with no noticeable negative consequence.


uvicorn-workers

Motivation and Context

What has changed

How to test?

Links

Screenshots (if appropriate):

This is no longer required. closing


Implement Container creation

A container should be attached to a Pod Sandbox as defined by the CRI.

I plan to work on this next.

I plan to work on this next.

Awesome, thank you!


APT source whitelist request for ppa:ansible/ansible

ppa:ansible/ansible

+1
I also need this

:+1:


When appearance is light, the font is poorly visible.

When the light theme is enabled, the yellow font is hard to see. It is advisable to change to a different color.

You are right. I think everyone uses dark mode :) It's my mistake. I will looking into it.


Using BARTScore to Compare 2 summaries without Human Evaluation

I went through the analysis script for comparing 2 evaluation metric wrt human evaluation (meta evaluating evaluation metric).
I wanted to know if there is some way to compare 2 summaries with help of standalone BARTscore.
Eg:- Higher Rouge Score then better the summary. Similarly can we calculate BARTScore for 2 summaries and then conclude that higher BARTScore better it is

Yes, similar to Rouge score, the higher the BARTScore, the better the summary.

Yes, similar to Rouge score, the higher the BARTScore, the better the summary.

I had a similar doubt about the interpretation of the scores. I understand higher = better. I'm still confused about the interpretation in terms of absolute score (how much a high score is a good score). In the paper, what were the absolute scores for the REALSumm and SummEval datasets? This would give a good reference point.


[Report Next Steps Audit] Simplify the report next steps 2

Tracking issue
As part of the Update Report Next Steps design doc, implement these new report next steps:
by combining a couple of the existing ones. Please refer to the design document for instructions on how to proceed on the PR.

grabbing for tomorrow!

not overdue, this has been merged and should be on prod shortly

on prod! closing


Use async cuda op to check for INF, NAN

@fps7806 suggested we could speed up validation in small models by creating custom async cuda ops that checked isinf and isnan asynchronously and threw an async exception if needed (this exception can be annotated with information of the stack trace at the correct location). These ops would need to be implemented in C++. It would be nice to reimplement our validation logic using these.

Is there a good benchmark we can use to evaluate the benefits of doing this? Ideally we can run a script with/without the exception checking which would give us a best-case speed up.

I think a good benchmark would be the Pyro unit tests:
make test-cuda

or what would run more quickly
CUDA_TEST=1 pytest -vx tests/test_examples.py::test_cuda

We could also focus on a single example under CUDA, e.g.
python examples/hmm.py --cuda

and other scripts in examples/ that accept the --cuda flag.


Bump dependencies

Added explicit opt-ins for ReadiumInternalApi because of a bug in AGP, see https://issuetracker.google.com/issues/328105511

Can either the navigation bundle be removed, or use it in the test app in place of these two lines?
Can the test-frameworks bundle also be removed since it's not being used?


fix(UI): add B1-english icon to superblock

Checklist:

[x] I have read and followed the contribution guidelines.
[x] I have read and followed the how to open a pull request guide.
[x] My pull request targets the main branch of freeCodeCamp.
[x] I have tested these changes either locally on my machine, or GitPod.

Closes #56061
Сreated a new b1-english icon that matches the style of a1-english, replaced the temporary use of a1-english in the b1 section with a new icon

LGTM @OrestSonich 🎉 Thanks for contributing to freeCodeCamp 🎉
Any interesting in creating some more icons? We need B2, C1, and C2 as well.

Thanks for your feedback! Sure, I'll try create more. Do you have an issues for these?

@OrestSonich there isn't an issue open, feel free to add them with a PR that is not related to any issue


select last record with where

I have a few billions rows in table for 4k mutable params and I need to get last values for 500 of them My table is partitioned by day and order by param ids so i need just to find last record with needed id
SELECT max(time)
FROM obj_ntgres.param_values_history
PREWHERE param_id = 4171

work bad: Elapsed: 0.437 sec. Processed 2.56 million rows, 5.21 MB (5.87 million rows/s., 11.92 MB/s.)
SELECT *
FROM obj_ntgres.param_values_history
WHERE param_id = 4171
ORDER BY time DESC
LIMIT 1

worse: 1 rows in set. Elapsed: 3.413 sec. Processed 2.56 million rows, 5.45 MB (751.21 thousand rows/s., 1.60 MB/s.)
Table
CREATE TABLE obj_ntgres.param_values_history (

  time DateTime,

  param_id UInt16,

  param_value Float32,

  param_value_quality Decimal(1, 0),

  msec Decimal(3, 0)

) ENGINE = MergeTree PARTITION BY toStartOfDay(time)

ORDER BY

  param_id SETTINGS index_granularity = 8192

Maybe you have some ideas?  I want order by time asc limit 1 , but from the end of table)

Likely duplicate of #1344.

I did make a workaround for simple use cases. Add param id to primary key first. Then run a query to group number of rows for a param is by buckets (say 1h bucket). Find last buckets that contain more than limit (500 in your case) records.
Re-run the query with constraint on time that is derived from time buckets and on param_id.

I did make a workaround for simple use cases. Add time and param id to primary key. Then run a query to group number of rows for a param is by buckets (say 1h bucket). Find last buckets that contain more than limit (500 in your case) records.
Re-run the query with constraint on time that is derived from time buckets and on param_id.

if trully understand you, it will work if i can find all my params in small timerange , but i have many params second ago and some 3 months ago

Now i'm using Materialized view for my purposes and it looks preaty good

Cross link with SO question https://stackoverflow.com/questions/55608325/clickhouse-select-last-record-without-max-on-all-table/55657641#55657641


depend on typing only if Python <= 3.5

Installing typing on Python >= 3.6 causes issues.

@gatkin would it be possible to get a new release with this fixed? the typing pypi module completely breaks modern python environments so all our builds have to work around this by pip uninstall typing afterwards.