teleren/devto huggingface dataset:
Web-based SQL Editor.
Published: 2024-06-03 01:09:06

Web-based SQL editors are online tools that allow users to write, execute, and manage SQL queries directly from their web browsers. These editors provide a user-friendly interface for interacting with databases and can be accessed from any device with an internet connection.
Web-based SQL editors typically offer features such as syntax highlighting, auto-completion, query history, and result visualization. They support various database management systems (DBMS) like MySQL, PostgreSQL, SQL Server, Oracle, and more. Users can connect to their databases by providing the necessary connection details such as hostname, port number, username, and password.
These editors make it convenient for developers, data analysts, and database administrators to work with databases without the need for installing any software or client-side tools. They can be used for tasks like querying and retrieving data, creating and modifying database structures, and performing database administration tasks.
Some popular web-based SQL editors include phpMyAdmin, Adminer, SQL Fiddle, and DBeaver (which also has a web-based version). Additionally, many cloud-based database providers offer their own web-based SQL editors as part of their services.

I recommend SQLynx as a reliable and user-friendly web-based SQL editor. SQLynx allows users to write and execute SQL queries directly from a web browser. It offers a clean and intuitive interface with features like syntax highlighting, auto-completion, query history, and result visualization.
SQLynx  supports various popular databases, including MySQL, PostgreSQL, SQLite, SQL Server, and Oracle. It also provides database connection management and allows users to save and organize their queries for future use.
With SQLynx, you can easily connect to your databases, write complex SQL queries, and analyze the query results, all within a web-based environment. It is a great choice for developers, data analysts, and database administrators who prefer a web-based solution for their SQL editing needs.
Download：http://www.sqlynx.com/en/#/home/probation/SQLynx
VERSE.DB with a CLI commands ?
Tags: versedb, database, node, cli
Published: 2024-06-03 01:08:20

hi dev community,

we just added a new update for the database and we are testing the **CLI** to see if you guys needs it for the database, so we made a simple **CLI** for the database that can create a new connection for you for the database and set it up for you so you don't need to code the connection and also can install the database since we are working on supporting other languages so this will help in case you want to install it for any other language like python soon, java, c#, ...etc and this staff.

you can **install the cli** with npm for now using this command:
```bash
npm install -g create-verse.db
```

then you can run it using the command: 
```bash
verse.db
```
like in the image:

![Verse.db CLI starting command](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/tktjlaq5ss7zcydd0so7.png)

we wish you guys like and and tell us in the comments if you like the ideas and what suggestions you want us to add

### OUR IDEAD

we also have an idea but we need your help to decide if we should do it or not

we are going to make something like a **database server** it will be running on a **localhost** with a port of your choosin and i will be like an **API** for the data we will make an adapter for it also and everything will be on this localhost, something like that it will remain on the path you want and also will be made with the command **nothing of the usage will change**
```bash
npm create verse.db@latest
```
or 
```bash
verse.db create
``` 
after that you can run the server if you wanted to use the server adapter 
and this will help it for those who wants to make there own database api and hosting it on a host with api instead of coding a new api with express.js this will be faster with out api management 


i wish you guys type in the comments what do you think about it we really are so existed for your opinion ✨

JEDI Studio.ص
Building a Personal Finance Application with Python
Tags: webdev, javascript, beginners, programming
Published: 2024-06-03 00:33:02

## Introduction

In this digital era, managing one's personal finances has become more important than ever. With the rapid growth of technology, building a personal finance application using Python has become an efficient and popular choice for many. Python, a widely-used high-level programming language, offers a variety of libraries and tools that make the development process easier and faster. In this article, we will explore the advantages, disadvantages, and features of building a personal finance application with Python.

## Advantages

1. **Flexibility and scalability:** Python's built-in data structures, flexibility, and object-oriented programming make it easy to handle large amounts of financial data and adapt the application as needed.

2. **User-friendly interface:** Python's syntax is simple and easy to understand, making it more user-friendly for both developers and users.

3. **Integration with third-party tools:** Python's vast library of modules and packages allows easy integration with different financial tools and services, making it a convenient choice for developers.

## Disadvantages

1. **Performance issues:** Python is an interpreted language, which can lead to slower performance compared to compiled languages like C++ and Java.

2. **Security concerns:** As with any digital financial application, security measures need to be carefully implemented to protect sensitive user data from cyber threats.

## Features

1. **Budget tracking and management:** The application can help users track their expenses and create personalized budgets to manage their finances better.

2. **Bill reminders and payment scheduling:** The application can send notifications for upcoming bills and allow users to schedule payments directly through the app.

3. **Investment tracking:** Users can track their investments, view performance charts, and receive alerts for changes in the market.

### Example Code for Budget Tracking

```python
import pandas as pd

# Sample data representing user expenses
data = {
    'Date': ['2023-01-01', '2023-01-02', '2023-01-03'],
    'Category': ['Groceries', 'Rent', 'Utilities'],
    'Amount': [25.50, 1200, 175.75]
}

# Create a DataFrame
expenses = pd.DataFrame(data)

# Calculate total expenses
total_expenses = expenses['Amount'].sum()
print(f"Total Expenses: ${total_expenses:.2f}")
```

This simple Python script uses the pandas library to manage and calculate expenses, demonstrating how easily financial data can be handled.

## Conclusion

In conclusion, building a personal finance application with Python offers a combination of simplicity, flexibility, and features that make it a strong contender in the world of financial technology. However, it is essential to consider the potential drawbacks and ensure proper security measures are in place to protect user data. With proper planning and development, a well-built personal finance application with Python can provide users with a powerful tool for managing their finances effectively.
Opus App Review -A Passive $529/day In 60 Seconds!
Tags: opus, opusreview, opusfeatures, opusapp
Published: 2024-06-03 00:15:41

Opus App Review : Features

Auto-Promote Any WarriorPlus Affiliate Link in 60 Seconds…
Enjoy The Power Of Human-Like A.I…
Built-On The Latest ChatGPT-4O…
Install In 1-Click & You’re Good To Go…
Auto Promote Any WarriorPlus Offer…
Works On All Devices…
Newbie Friendly Interface…
Analytics & Tracking Built-In…
Created For Beginners…
Automatic Traffic Generation…
Biz-In-A-Box Commercial Licence Included…
No Tech Skills Or Experience Needed…

Click Here : https://alauddinreview.com/opus-app-review/
El principio
Tags: beginners, python, spanish, learning
Published: 2024-06-02 23:37:50

Fácil.
Estuve dándole un poco la brasa a ChatGPT 4o sobre como girar desde las finanzas y la banca, a la programación. Le hablé de mis inquietudes sobre el machine learning y la investigación sobre escenarios y proyecciones con modelos montecarlo y teoría de opciones reales.
Me recomendó dos cosas:

- Comenzar a estudiar python en Coursera, con un curso concreto Python for everybody.

- Documentar mi aprendizaje. Me nombró GitHub para los proyectos, y me nombró algunas plataformas donde ir dejando mis avances, porque decía literalmente, que podría ser motivador para otros a la vez que me daría visibilidad para buscar alguna actividad que desarrollar en este mundo.

Y aquí estoy dando constancia de la segunda, en la que contaré de la primera.

Comencé el curso de iniciación el pasado 25 de mayo. Ya tenía conocimientos de alguna cosilla, por lo que no me fue demasiado difícil avanzar por él. Hasta me han dado un certificado y todo.
https://coursera.org/share/b6043ab6b07cd7ea55466c0464e94539

Lo mas interesante del curso es la cantidad de recursos que tiene por los que puedes volver a pasar y que además muchos de ellos están abiertos, sin tener que realizar el curso. Esta es la página https://www.py4e.com/ que mantiene vivo todo el material y videos donde Charles Severance imparte el curso en varias plataformas.

Ahora he pasado al segundo curso dentro de un programa de 5, de la misma universidad y también impartido por Severance, donde ya entramos en las Estructura de Datos.

La verdad que no se que mas poner por aquí por ahora, es tan incipiente el aprendizaje que todavía no veo lógico destacar ninguna parte.

Bueno, pues ya arranqué.
[Game of Purpose] Day 15 - End of tutorial
Tags: gamedev
Published: 2024-06-02 23:04:12

Today I finished a [tutorial](https://www.youtube.com/watch?v=k-zMkzmduqI)

This is my final result:

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/xeq4uofw5ovgwa3op3gx.png)

This is how my castle looks:

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/r1r06pkajvbi6tky6vjj.png)

After this tutorial, especially the last part I felt that I don't enjoy creating objects. Creating terrain, painting was somewhat ok, but building a castle was so boring. I wanted it to end as fast as possible, so I copy pasted walls. That's why it looks so fake.

My next goal is to setup version control system (VCS) with either Perforce, which I need some time to spend on, or git.

-----

I had some more time today and I followed [this tutorial](https://www.youtube.com/watch?v=Hvmvv2MG-UE) of setting up Perforce server. I created a 16$/month droplet on Digital Ocean. I hope I could do that on my NAS, so that I don't have to pay that much.


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/kyaziyuxclqhdygxcmns.png)
Key Tips for Database Design
Tags: beginners, database
Published: 2024-06-02 22:58:26

1. Normalization: Break down your data into additional tables to eliminate redundancy and ensure data integrity.
2. Primary Keys: Assign a unique identifier to each table. This key ensures that each record within the table can be uniquely identified.
3. Foreign Keys: Used to establish relationships between tables. This method maintains referential integrity by linking related data across different tables.
4. Data Types: Choose appropriate data types for each column to ensure data accuracy and optimize storage.
Babylon.js Browser MMO - DevLog - Update #3 - Displaying other players
Tags: babylonjs, gamedev, indie, mmo
Published: 2024-06-02 22:06:49

Hello,
Here is a next brief update from me. 
Bad weather means more progress :)

Players can now see other players, including their position and rotation changes. Additionally, running animations are now being played.

In the chat, which is currently read-only, a message is sent to all online players whenever someone joins the game.

What's next?
I will work on hiding entities when someone leaves the game. I will also introduce a spatial hash algorithm to calculate nearby entities, which will be used for ensuring that only information about those entities which are nearby is sent to the players.

Best regards

{% youtube 4H1sLoYlx6k  %}
Another way to deserialise DateTime in Rust
Tags: rust, serde, programming
Published: 2024-06-02 21:10:29

In a previous post, I wanted to deserialise a date from a Toml file and implemented the Deserialize trait for a type NaiveDate. When I was implementing metrics, I had to do it again, but implement serialise and deserialise for NaiveDate and I found another way, possibly simpler, to serialise and deserialise NaiveDate.

**First:** add derive support to your Cargo.toml

<!-- more -->

Inside dependencies, make sure that derive feature is enabled

```toml
[dependencies]
serde = { version = "1.0.198", features = ["derive"] }
```

**Second:** In the struct containing the NaiveDate you want to **serialise** and **deserialise**, add `#[serde(with = "naive_date_format")]`. E.g.

```rust
use crate::metrics::naive_date_format;
// ...

#[derive(Clone, Debug, PartialEq, Serialize, Deserialize)]  
pub struct PostCounter {  
    pub post_id: String,  
    pub total: u64,  
    pub origins: HashSet<String>,  
    #[serde(with = "naive_date_format")]
    pub stats_date: NaiveDate,  
}
```

**Third:** Create naive_date_format function

You may figured already that naive_date_format is a function. This is a suggested implementation

```rust
mod naive_date_format {  
    use chrono::NaiveDate;  
    use serde::{self, Deserialize, Deserializer, Serializer};  
  
    const FORMAT: &str = "%Y-%m-%d";  

	/// Transforms a NaiveDate into a String
    pub fn serialize<S>(date: &NaiveDate, serializer: S) -> Result<S::Ok, S::Error>
        where
            S: Serializer,
    {  
        let s = date.format(FORMAT).to_string();
        serializer.serialize_str(&s)
    }

	/// Transforms a String into a NaiveDate
    pub fn deserialize<'de, D>(deserializer: D) -> Result<NaiveDate, D::Error>  
        where
            D: Deserializer<'de>,
    {
        let s = String::deserialize(deserializer)?;
        NaiveDate::parse_from_str(&s, FORMAT).map_err(serde::de::Error::custom)
    }
}
```

### Conclusion

If you need a conclusion, please read again the code before the conclusion.

---

Original post in the author's blog: [Another way to deserialise DateTime in Rust](https://thiagocafe.com/view/20240602_another_way_to_deserialise_datetime_in_rust/)
Hello (Dev) world
Tags: beginners, learning
Published: 2024-06-02 21:04:38

Hey, Dev community 👋 – Ian here.

Thought I'd share a quick intro about myself:

I'm an avid reader, writer, and indie hacker. However, most of my startup ideas are now buried in my virtual backyard, but at least I'm learning (my attempt at justifying the sunk cost 🤷🏻‍♂️).

- I'm a curator of tech newsletters and often share what I've been reading

- I'm an editor of a Substack called Scaling Down – a starter guide for engineers and product teams who made the leap from Big Tech to a startup

– I build web scrapers to help me aggregate information and tinker with RAG-based web apps to help me summarize it

Happy to help with any of the above.
Building an Alternative to Examine.com: A Challenging Journey!
Tags: seo, startup, ai
Published: 2024-06-02 20:40:01

Many of you might already know about Examine.com, a leading resource for supplement research. Examine focuses on specific health areas, scouts for related research papers, and then describes the link to different supplements. This meticulous process is understandably labor-intensive, which is why they charge a fee for accessing their data. However, with the advent of AI, many parts of this process can be automated, and that's the solution I'm working on.

For instance, here's a compilation of research linked to **Reduced Body Weight**:

https://pillser.com/health-outcomes/reduced-body-weight-158

I've indexed thousands of research papers and extracted insights that connect these studies to various supplements on the market. My long-term goal is to create a pioneering supplement store where every product is linked to research. Unlike Examine, I plan to make all research summaries public and instead focus on earning affiliate revenue from related supplement sales.

The biggest challenge is ensuring data accuracy. Given the complexity of these topics, I am currently limiting insights to demonstrate a link between the study, health outcome, and substance. Users are then directed to the actual research papers to build confidence in their decisions. However, as AI models evolve, I aim to expand this into a comprehensive insight engine.

AI and large language models (LLMs) are crucial in this process. Finding research papers is relatively straightforward with resources like PubMed. I use a combination of API services, varying in cost and speed, to scout for relevant mentions in the research (using fast and cheap models), validate the relevance of these mentions (using top models), and finally ensure the accuracy of the summary versus the excerpt (using another model). The idea is that the first model may make mistakes, the second filters out false positives, and the third acts as a final safeguard.

I am deeply fascinated by this problem domain and, more broadly, by data normalization and the applications of LLMs in solving these problems. While this project is currently a hobby that I anticipate will be a money-losing activity for a long time, I believe there is a significant chance that [Pillser](https://pillser.com/) could become a preferred site for supplement buyers due to its unique combination of scientific backing and extensive inventory.

I am probably a few months away from completing the database, but I wanted to share this for early feedback. The website is called [Pillser](https://pillser.com/), and you can already search for different health goals and associated research directly from the landing page.
Get Certified With GitHub
Tags: github, opensource, productivity, git
Published: 2024-06-02 20:01:52


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/627mo15mbx77ifp06t19.png)
Hi everyone                                                                                        Get Certified with GitHub 😻 

🚨 Register to join our series and promote in your local communities.
From June 5th to June 26th, we will help you get prepared to take the GitHub Foundation Certification with the help of Microsoft and GitHub experts! 

🚀🤓You will learn how to collaborate on a project and with teams to grow your knowledge by using different tools like GitHub Copilot, GitHub Codespaces and more🌟😇. Plus, you'll have the chance to earn a free certification voucher for the GitHub Foundation Certification! 🎉 .Get started by exploring the link below:
https://aka.ms/GetCertifiedwithGitHub?wt.mc_id=studentamb_360864                                                                                                                     Feel free to ask for any more enquiries✅
7. Gunicorn als service - Django in Produktion Teil 7
Published: 2024-06-02 19:54:55

## Vorwort
Mit `gunicorn meine_app.wsgi` kannst du seit der letzten Folge deinen Appserver starten. Das ganze wäre aber etwas unpraktisch, wenn du immer eine Shell-Sitzung mit deinem Gunicorn offen haben müsstest, um deine Webapp laufen zu lassen. Außerdem, was passiert wenn die App crasht? Was passiert falls du gerade kein Internet hast, oder wenn du mal deinen Server neu starten willst? Da jedes mal den gleichen Befehl wieder einzugeben macht keinen Sinn. Deswegen gibt es `.service` Dateien, die dafür sorgen dass dein Gunicorn automatisch beim Neustart / Anschalten deines Servers gestartet wird.

## Installation von gunicorn.service
Lege entweder eine Datei an, oder verlinke von deiner Repo aus:
``` 
sudo ln -s /srv/www/meine_repo/services/gunicorn.service /etc/systemd/system/gunicorn.service
# oder:
sudo touch /etc/systemd/system/gunicorn.service
```

Diese kannst du mit folgendem Inhalt füllen:
```
[Unit]
Description=Gunicorn service that serves meine_app
After=network.target

[Service]
# Hier kannst du das richtige environment laden
Environment="ENV_NAME=production"

# Nutze am besten nicht root, sondern einen eigens erstellten nutzer, z.B. meine_app_gunicorn
User=root
Group=root

# Deine .wsgi - Datei ist in deinem django-Projektverzeichnis
# Hier wird dein Start-Befehl ausgeführt
WorkingDirectory=/srv/www/meine_repository/mein_projekt

# Das hier Startet deine django App
ExecStart=/srv/www/meine_repository/venv/bin/gunicorn --log-file /var/log/gunicorn --workers 1 --bind 127.0.0.1:8000 meine_app.wsgi

ExecReload=/bin/kill -s HUP $MAINPID
KillMode=mixed
TimeoutStopSec=5
PrivateTmp=true

[Install]
WantedBy=multi-user.target
```

Jetzt musst du nur noch den service anmachen:
```
# Lade deine neue Konfiguration
sudo systemctl daemon-reload
# Schalte gunicorn ein, sodass der Service automatisch bei einem reboot angeht
sudo systemctl enable gunicorn
# Starte gunicorn
sudo systemctl start gunicorn

# Jetzt sollte hier ein grünes 'started' und 'enabled' rauskommen:
sudo systemctl status gunicorn
```

PS: probiere doch mal ein `reboot` aus, danach sollte dein gunicorn auch wieder laufen.

Viel Spaß beim Coden,
Dein Ruben

[Mein Blog](rubenvoss.de)
Cent's Two Cents - Start
Published: 2024-06-02 16:30:38

Hello everyone!

In an attempt to be more consistent with learning, I am going to start this blog to essentially summarize what I've done in the 60-90 minutes I take out of my day to learn.

I have started [The Odin Project](https://www.theodinproject.com/) so a lot of the early blogs will be relatively simple, as we are going over the basic of basics (in my opinion of course). I've decided to go through everything again in order to solidify my foundation before  I continue finishing the side projects I've started but never finished.

Before I describe what I went over today, I would like to describe a few of my goals for myself:

1. Complete The Odin Project
2. Finish my side projects (discord bot, ultimate bravery lor)
3. Participate in more challenges (codepen challenges, dev.to challenges, maybe a hackathon)
4. Update my portfolio site which i have not updated in years (my resume is included in this step)
5. Find a job in web development (i work a a bank mainly using sql and unix. While nice, not really what i want to do as a career)

Now onto what I learned today.

I have started the foundations course for the odin project. As of now I have finished the introduction section, which includes how the course will work, how to interact with the community if you need help, and how to learn. I also just started the foundations section which will go over how the web works, and computer basics. I did go to a non standard college so I appreciate this overview from then.

One interested thing I've learned from these lessons is the pomodoro technique, which is essentially a 25 min study session then 5 minute break on repeat. When I studied as a student, I usually separate it by subjects, which means I could be going for only a few minutes or hours at a time. I'm going try to use this technique tomorrow so I can see if it can help my concentration.

That's all for today! Until tomorrow!
Fun-filled tech event during #NYtechweek, June 6th!
Tags: techcommunity, developers, machinelearning, ai
Published: 2024-06-02 19:26:28

---
title: Fun-filled tech event during #NYtechweek, June 6th!
published: true
tags: #techcommunity #developers #machinelearning #ai 
---
Hi, devcommunity!

I'm excited to host an in-person community event during New York Tech Week on Thursday, June 6th! If you are in the New York area, please join! This will be a fun-filled event with games, food, beverages, and music. Full details to register here: https://lu.ma/vwgzxjm8. Registration ends Monday, June, 3rd at 11:59 pm (ET). Looking forward to seeing you!

To learn more about me: https://dipishap.crd.co/
To learn more about Drive: https://drivellc.crd.co/

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/a822meon9yteen6m71wt.jpg)

---