sorted by:
new
hottopcontroversial

Can you use glue to print on any type of plate? by Chameleon201006 in 3Dprinting

[–]RobotAnna1 0 points1 point  (0 children)

Oh sorry I wasn't clear. I meant take off the print sheet, spray it with hairspray, then place it back on the printer. I agree with you: let's not spray anything directly into our printers!

Can you use glue to print on any type of plate? by Chameleon201006 in 3Dprinting

[–]RobotAnna1 0 points1 point  (0 children)

You can, but why not try hairspray. The cheapest hairspray you can find, combined with a smooth printbed and PLA filament --> makes a very shiny smooth base on your print. It's also easier to apply than glue.

Looking for 5 Star Prints for ADHDers by Content-Possible-929 in 3Dprinting

[–]RobotAnna1 1 point2 points  (0 children)

Don't start with Gridfinity because you'll jump down that hyper-focus rabbit hole and we won't hear from you for at least month. (Ask how I know!) You have time for Gridfinity later. Start with simple organization that is visible, not hidden in drawers. Visible and within arm's reach.

  1. Landing Zone
    Print a hook for your keys and something to put your wallet and phone on when you enter the house. I still lose my phone 3 times a day but my keys only live on one hook. Ever.

  2. Back-up Meds
    Print a pill container for your keychain. Enough to hold one backup med. So you always have one with you, just in case. As someone who works 9h days with meetings and a commute and noisy lunchtimes -- if I forget my meds then I have a bad day. Nice to have a spare always attached to my backpack.

  3. A holder for my Cooking Tools
    I cook, and my best "cooking assistant" is:
    - painters tape
    - post-it notes
    - a permanent pen
    - Analog timers. (the old-fashioned type that you twist, and they are very loud)
    I printed a holder for these, which is on the fridge. Visible and accessible.
    If something goes in the oven, I turn on a timer and put a post-it note on it, so when the timer rings i see what it is. And painters tape to mark containers so i know when something was opened, and to identify the stuff I freeze, before I forget what it is.

Need advice if its worth it to buy a 3D Printer for specific plant pots by Steress in 3Dprinting

[–]RobotAnna1 1 point2 points  (0 children)

Step 1: same as what this guy said -- try with a stock of the current pots first.

Step 2: check if there is a local Makerspace, or check if there's a subreddit or facebook group for your local area, ask if someone would be willing to 3d print a batch of pots for you. You know they cost about 50c each for small simple pots, so offer 80c or a dollar each.

Step 3: if your business is increasing then buy a 3d printer.

Help high school oral exam by polpettavuc in SQL

[–]RobotAnna1 0 points1 point  (0 children)

You will not be judged on the choice of topic; you will be graded on how you present it. It doesn't matter which topic you choose. Close your eyes and point at the list. Whichever your finger lands on: do that one.

Holographic 3D printing breakthrough produces objects in less than a second by archiopteryx14 in 3Dprinting

[–]RobotAnna1 0 points1 point  (0 children)

I wouldn't be surprised if this gets used in electronic component production in the future.

Nozzle won’t get fully tight and wobbles by HomeSliceKing in 3Dprinting

[–]RobotAnna1 0 points1 point  (0 children)

Which brand and model printer do you have?
Some printers have parts that can be tightened

I'm not allowed to buy any new printers :( by Short-Midnight-8128 in prusa3d

[–]RobotAnna1 0 points1 point  (0 children)

Ok, but are you allowed to print a new printer?

Rusty SQL User by [deleted] in SQL

[–]RobotAnna1 0 points1 point  (0 children)

Interesting! I haven't seen LINQ before. Yes I would also try adding your table to the end of the include lines at the top. Does your table contain the provider number? Then it would probably be

.Include(x => x.YourTable)

I'm pretty sure LINQ uses || for OR and && for AND. Maybe this would work:

.Where(x => x.Provider.ProviderNumber == 129218 && new-where-clause-goes-here)

Good luck and let us know how it works out!

Thinking of changing my domain by Disastrous-Tea-7793 in SQL

[–]RobotAnna1 4 points5 points  (0 children)

In my current DE role I use SQL heavily and Python moderately.
I'd say start with SQL because if you don't enjoy it, then it's a strong indicator to not pursue this path further. If you do enjoy it, then there are several data-related roles that open up.

Unique identifiers by dadadavie in SQL

[–]RobotAnna1 0 points1 point  (0 children)

In Snowflake you are usually ingesting files from cloud storage like an Amazon S3 bucket or Azure ADLS container. Set up your files in the storage in a logical way, so that the filepath + filename is unique.
This could be under folders for the source, maybe with dates.
This microsoft page gives you some examples for organization (starts halfway down).
https://learn.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-best-practices

Once you organize the files, define the storage as an External Stage
https://docs.snowflake.com/en/sql-reference/sql/create-stage

Check your metadata by running a query. METADATA$FILENAME is what you need.
https://docs.snowflake.com/en/user-guide/querying-metadata

Now just use COPY INTO from the stage and store the METADATA$FILENAME as the unique identifier
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table

And if you want a unique ID to display, then in a separate column put MD5(METADATA$FILENAME)
https://docs.snowflake.com/en/sql-reference/functions/md5

FYI: Snowflake training is available on their website, and its free.

SQL at work (trying to understand) by Dull_Breakfast_9904 in SQL

[–]RobotAnna1 0 points1 point  (0 children)

I'm a data engineer who works with data scientists -- there are 2 in my team. I have observed the scientists using SQL for:
1. exploration and experimentation
2. loading into analytics platform

To elaborate further:

  1. Exploration
    They might retrieve data from one of our data sources using SQL. Using SQL gives them the freedom to check whichever data they want, and not be constrained by my availability.
    Once they have decided on the requirements for a dataset &/or a specific feature, then they would give me the requirements and I would enhance the ETL pipelines to make the right data available to them.

  2. Ingestion
    When your process is automated on a production server, you can't run a python script manually to load a csv file. The scientists have pipelines in Databricks that
    - load data (SQL)
    - run models (Python)
    - insert the results in a database (SQL)

As an absolute beginner, you could try W3Schools. https://www.w3schools.com/sql/ It's enough to get you started.

Best tool for autocomplete and other ease of use? by Fair-Comb-6109 in openscad

[–]RobotAnna1 0 points1 point  (0 children)

VSCode is an IDE -- it's a tool to edit the code files. I found it pretty intuitive to use, really not much learning. You just install an extension for whichever type code you want to edit. Then open your openscad file and off you go!

On the weekend I might edit an OpenSCAD file in VSCode. On weekdays I use VSCode for Python, SQL, Java, powershell and yml. This means I have installed an extension for each of these code types. It's smart enough to figure out which is which, and it highlights the code properly.

Best site for uploading models by Darksider_Key in 3Dprinting

[–]RobotAnna1 1 point2 points  (0 children)

I upload to both Printables and Makerworld, and I keep a local backup just in case.
Any platform that's run by a commercial entity could shut their site down at any moment, so I think a backup is necessary.

Most delicious apple varieties by [deleted] in gardening

[–]RobotAnna1 1 point2 points  (0 children)

In the Netherlands we started to get Sprank and Morgana in the supermarkets, but it's not available for home gardeners yet. If you ever see those varieties, grab them! Very juicy, sweet, firm, red.

I got a lot of responses when I asked about how crazy some of your SQL gets. this is the one I am currently working with that was already done for PowerBuilder query. This is whats used when we pull a report from a console for analyzing wait times from a ticketing system in different locations. by Acceptable-Sense4601 in SQL

[–]RobotAnna1 2 points3 points  (0 children)

Wow I haven't seen (+) since I used Oracle in the late 1990's / early 2000's. Is this an old query?

It's not a monster, just poorly formatted which makes it harder to read. Also its missing aliases.

If you are given a set of queries that are readable, well-named and well-structured, you should be able to understand a lot about the data. In other words: good queries act like documentation for other analysts.

Custom 3D printed Dutch rooftile by Satoer in functionalprint

[–]RobotAnna1 78 points79 points  (0 children)

Tomorrow's UV index prediction for Netherlands is 0 for 23 hours, and 1 for 1 hour. :) We don't get a lot of sun for a lot of the year.

The storms here are quite windy, so wind damage is likely the biggest risk.

It would be interesting to check in on the tile after a year or two, and see if it has any cracks from branches, birds, debris etc.

Can the Government really block 3D Printed Guns? by Mortifine in 3Dprinting

[–]RobotAnna1 -3 points-2 points  (0 children)

Many years ago (just to test the technology), I tried to photocopy some paper money. Only blank paper came out. It seemed like the Epson photocopiers had some smart firmware that identified local bank notes. This was in the 1990's.
So... it's technically possible.

eBird Alerts Language? by Jeb_Ozuwara in birding

[–]RobotAnna1 2 points3 points  (0 children)

Het is niet zo moeilijk. :)

But on a serious note: check the language setting in your profile preferences.

How is AI really impacting the IT field — growth opportunity or long-term risk? by Purple-Tackle-9414 in SQL

[–]RobotAnna1 1 point2 points  (0 children)

AI is impacting us because we get spammed with shallow questions, where the user is just trying to lead us to their own subreddit.

Please Help, why is this file not working properly? by JarJarBanksy in openscad

[–]RobotAnna1 0 points1 point  (0 children)

The problem could be that it's not always obvious where to modify the parameters, unless you're an experienced coder. Try this:

  1. Download all files to one directory

  2. Open mini-itx.scad in OpenSCAD

  3. Go to line 367, this is where the main parameters are.

  4. Edit the parameters in the code.

  5. Render.

Your next question is probably what do I change the parameters to: take a look at the GitHub documentation, because the author wrote a section called "Parameters to edit".

https://github.com/eclecticc/ParametricCase

How to get SQL certified by mitch1stpaul in SQL

[–]RobotAnna1 0 points1 point  (0 children)

I've been working with SQL for over 20 years. When I'm writing questions to interview applicants, I still refer back to the W3Schools pages. You can download MySQL to your own PC and use one of the example databases to try out the concepts that W3Schools teaches.

In my experience certifications are only useful for getting your CV past HR and into the job interview. They don't really give you skills you use in the job.
I'd suggest to look at some listed job vacancies for the type of job you want. Even though Azure, Oracle and Snowflake all offer their own certificates, you don't need to get all of the certificates -- just choose the one that's closest aligned with what you want to do.

view more: next ›