Google AdSense Canada Account Approved in One Month

Finally, a good news, My new Google Adsense Canada account is been approved after waiting for one month. Let's see how long it will take to reach the payment threshold. Hope not too long!

Post, Code and Quiet Time. Google AdSense Canada Account Approved in One Month By Errong Leng – 15 Feb 2023 – View online → Photo by Vasily Koloda / Unsplash Finally, a good news, My new Google Adsense Canada account is been approved after waiting for one month. Let's see how long it will take to reach the payment threshold. Hope not too long! Post, Code and Quiet Time. © 2023 – Unsubscribe

How to merge|replace images into a PDF document via itextpdf lib in Java

In my previous post, I guided how to find all the images that are signatures place holders. In this post, I will tell how to replace or merge them with your fancy signature image. First, you need to prepare your fancy signature image. You can try with: https://www.sign.plus/online-signature-generator And create a BufferedImage from your signature. In the RenderListener implementation, we detected the image object that might be the signature place holder. Then 4 steps need to be done to merge

Post, Code and Quiet Time. How to merge|replace images into a PDF document via itextpdf lib in Java By Errong Leng – 15 Feb 2023 – View online → Photo by Lewis Keegan / Unsplash In my previous post, I guided how to find all the images that are signatures place holders. In this post, I will tell how to replace or merge them with your fancy signature image. First, you need to prepare your fancy signature image. You can try with: https://www.sign.plus/online-signature-generator And create a BufferedImage from your signature. In the RenderListener implementation, we detected the image object that might be the signature place holder. Then 4 steps need to be done to merge your fancy contract. PdfReader::killIndirect, remove the connection com.itextpdf.text.Image::getInstance(bufferedImage) create a new mask Image PdfWriter writer = pdfStamper.getWriter(); create indirect connection with the new signature image PdfReader.killIndirect(currentImg); BufferedImage bufferedImage = ImageIO .read(new ByteArrayInputStream(imageBytes)); if (bufferedImage != null) { Image signatureImage = Image.getInstance(bufferedImage, null); Image maskImage = signatureImage.getImageMask(); if (maskImage != null) { log.error("maskImage {}", maskImage.getAbsoluteX()); writer.addDirectImageSimple(maskImage); } signatureImage.scaleToFit(targetWidth.floatValue(), targetHeight.floatValue()); writer.addDirectImageSimple(signatureImage, (PRIndirectReference) obj); } Apply signatures programiclly via itextpdf Post, Code and Quiet Time. © 2023 – Unsubscribe

How to detect signature images from a pdf document via itextpdf in Java?

Image you have a pdf that requires customer signatures. Such as You want to write a program to sign the signature automatically. First, you need to scan the whole PDF document and find all the places that require signature. Second, you need to replace those places with your fancy signature. In this post, I will focus on how to detect the images that requires signatures. use itextpdf lib com.itextpdf itextpdf 5.5.13, A Free Java-PDF library PdfReaderContentParser::processContent use PdfRea

Post, Code and Quiet Time. How to detect signature images from a pdf document via itextpdf in Java? By Errong Leng – 15 Feb 2023 – View online → Photo by Estée Janssens / Unsplash Image you have a pdf that requires customer signatures. Such as You want to write a program to sign the signature automatically. First, you need to scan the whole PDF document and find all the places that require signature. Second, you need to replace those places with your fancy signature. In this post, I will focus on how to detect the images that requires signatures. use itextpdf lib com.itextpdf itextpdf 5.5.13, A Free Java-PDF library PdfReaderContentParser::processContent use PdfReader to read the pdf file and get the page numbers. Then PdfReaderContentParser::processContent to process the content of each page. The function accept a RenderListener interface to inform you when a text will be rendered, and when an image will be rendered. try { Path path = Paths.get(new ClassPathResource("test.pdf").getFile().getAbsolutePath()); byte[] pdf = Files.readAllBytes(path); PdfReader pdfReader = new PdfReader(pdf); ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream(); PdfStamper pdfStamper = new PdfStamper(pdfReader, byteArrayOutputStream); for (int page = 1; page <= pdfReader.getNumberOfPages(); page++) { PdfReaderContentParser parser = new PdfReaderContentParser(pdfReader); parser.processContent(page, new RenderListener() {...}); } pdfStamper.close(); } catch (Exception e) { log.error("Oops!", e); } RenderListener::renderText & renderImage Since in the above pdf, all the places requires signature will have the below structure orders: Text X Image Signature Place Holder Text Customer Signature. Then we make the assumption: If an Image is rendered between them(X and Customer), it can be considered as the Image for signature. new RenderListener() { private String previousText; private PdfImageObject currentImg; @Override public void beginTextBlock() {} @Override public void renderText(TextRenderInfo textRenderInfo) { if (textRenderInfo.getText().equalsIgnoreCase("Customer")) { if (previousText.equalsIgnoreCase("X")) { if (currentImg != null) { // this image is for customer signature PdfDictionary pd = currentImg.getDictionary(); log.info("detect customer signature image with dimension : {} x {}", pd.get(PdfName.WIDTH), pd.get(PdfName.HEIGHT)); // reset to null currentImg = null; } } } previousText = textRenderInfo.getText(); } @Override public void endTextBlock() {} @SneakyThrows @Override public void renderImage(ImageRenderInfo imageRenderInfo) { PdfImageObject imgObj = imageRenderInfo.getImage(); if (currentImg == null) { currentImg = imgObj; } } Ok. Then we find out all the images place holders for signatures. In my next post, I will continue how to merge your fancy signature to replace them. Post, Code and Quiet Time. © 2023 – Unsubscribe

Vite SSR for React in NX workspace

Why not use @nrwl/react:setup-ssr Yea, NX has a react plugin can set up SSR for your react application. It does works well. But the dev server is not smart though. It use the @nrwl/webpack:ssr-dev-server executor, it support browser build target and server build target and wait until both build target completed and then run the server main.js via node. It does watch the files but it always restart the server even if you just edit frontend part. It does not support Hot Module Replacement (HMR).

Post, Code and Quiet Time. Vite SSR for React in NX workspace By Errong Leng – 08 Feb 2023 – View online → Photo by engin akyurt / Unsplash Why not use @nrwl/react:setup-ssr Yea, NX has a react plugin can set up SSR for your react application. It does works well. But the dev server is not smart though. It use the @nrwl/webpack:ssr-dev-server executor, it support browser build target and server build target and wait until both build target completed and then run the server main.js via node. It does watch the files but it always restart the server even if you just edit frontend part. It does not support Hot Module Replacement (HMR). But you can still use this plugin to set up React SSR skeleton for your app. Why Vite? Lightning Fast HMR Vite serves source code over native ESM. This is essentially letting the browser take over part of the job of a bundler: Vite only needs to transform and serve source code on demand, as the browser requests it. Code behind conditional dynamic imports is only processed if actually used on the current screen. Vite provides built-in support for server-side rendering (SSR). Though The Vite playground contains example SSR setups for React. The example works well but requires a few migration if you want adding it into a NX workspace. In this post, I will tell how I accomplished to make Vite SSR for React work in NX. Vite SSR with build via webpack Vite Dev Server serves a static web app very well. But it does not work out for SSR. In order to server a SSR app, you need to run your app via node. NX has a "@nrwl/js:node" executor. I was thinking to run a dev server using @nrwl/js:node but point to @nrwl/vite:build as the buildTarget. It fail due to schema not match, I raised a issue and hope it can be addressed by Vite NX plugin soon. webpack build target for React SSR. I intented set "watch" option to false, Since Vite Dev Server support HMR for frontend. In case you change any server side code, you have to restart the "ssr-serve" target. index.html changes to use Vite Dev Server all external css files please @import in src/styles.css and it needs to be linked in index.html. The main render function for frontend needs to be loaded as a Javascript module. These are for Vite Dev Server, if you use webpack for production build, then you don't need link styles.css and main.tsx in the index.html, since webpack will inject them for you automatically. <!--app-html--> is the placeholder for SSR rendered string. Vite SSR Set up use Vite Dev Server as middleware please note the root of Vite Dev Server should be the folder where the vite.config.js located. server the index.html via ssrLoadModule and your SSR mechanisam. Vite SSR for React in NX example project GitHub - lengerrong/nx-vite-ssr-react-app Contribute to lengerrong/nx-vite-ssr-react-app development by creating an account on GitHub. GitHub•lengerrong You can clone the code and play in your local. Whenever you make change to your frontend part, it will do hot module reload update quickly. References Vite Next Generation Frontend Tooling Vite Post, Code and Quiet Time. © 2023 – Unsubscribe

How to migrate Oracle database to Microsoft SQL server database

Oracle migrate to SQL Server SQL Server Migratin Assistant is a free tool that Microsoft provides to automate database migration to SQL Server. I tried to use recently but gave up finally. Since it not support connection to your database server via custom JDBC url which is usually used by most backend java application. DBeaver: one tool for all data sources I've googled for days trying to find any open source alternatives. Fortunately, I found DBeaver. You can download DBeaver Ultimate and

Post, Code and Quiet Time. How to migrate Oracle database to Microsoft SQL server database By Errong Leng – 07 Feb 2023 – View online → Photo by Melvin / Unsplash Oracle migrate to SQL Server SQL Server Migratin Assistant is a free tool that Microsoft provides to automate database migration to SQL Server. I tried to use recently but gave up finally. Since it not support connection to your database server via custom JDBC url which is usually used by most backend java application. DBeaver: one tool for all data sources I've googled for days trying to find any open source alternatives. Fortunately, I found DBeaver. You can download DBeaver Ultimate and try a 14 days free trial. It just met all my needs. All you need to do is 3 steps: 1. connect to both source and target database 2. select the tables you want to migrate from source database 3. right click and select 'export data' menu and complete the rest References DBeaver Ultimate DBeaver Ultimate is a full-featured toolkit for database management that also provides easy access to AWS services: integration with AWS user and permission management, connection to AWS databases in a few clicks. DBeaver SQL Server Migration Assistant - SQL Server Learn about SQL Server Migration Assistant, a tool that automates database migration to SQL Server from Microsoft Access, DB2, MySQL, Oracle, and SAP ASE. Microsoft Learn•cpichuka Post, Code and Quiet Time. © 2023 – Unsubscribe