A link database for discovering cool and interesting websites

Related tags

Database php links sql database internet surf link-manager
Overview

Yesterlinks

Yesterlinks is a database of links to unique or interesting websites.

This is a project, in its infancy, designed to be a directory of links of various websites as well as a 'random page' button that loads a link at random.

It's currently being designed and written with PHP/SQL and Javascript.

If you want to contribute to this project, please go ahead! If you're not tech-savvy I'll be including a description of how it works, and welcome all ideas.

Goals

The goal of this project is to create a database of links to cool or interesting lesser-known websites. It is meant to encourage people to "bloomscroll" - the opposite of doomscrolling.

Demo

You can play with a live demo at https://links.yesterweb.org/

The Webpages

Currently there are 3 pages:

  • Home (view only, public) /index.php
  • Submit (public, anti-bot) /submit-a-link.html
  • Admin (requires password, can edit/delete/approve entries) /admin/

The Database

The database is the back-end which stores the data. Currently, the database exists of five columns:

| id | title | url | description | category |

How to Contribute

Don't know how to code? No problem! We are looking for all sorts of assistance here. If you play around with the demo and you have some feedback, please reach out! You can open an Issue on here, drop by the Discord server, or email me at [email protected]

Here are some ideas of what I need assistance with:

  • I would love to create a relational database with a fully featured tagging system but I'm afraid this is beyond my particular skills right now. Even if you don't have time to build one, I greatly appreciate any offers for help with figuring out how to do this!
  • New category ideas?
  • Some way to encourage a better user experience 'surfing' through webpages. Either that, or a way to programmatically determine whether a link in the list has 1) CORS enabled and/or 2) is http:// only so as to "filter" the iframe-friendly videos for a 'surf' feature.

How to Clone & Make a Copy

Detailed instructions coming soon!

To Do List

  • Add category descriptions
  • Create authentication (user/admin accounts)
  • Set up approval system.
  • Figure out how to do a public ranking/comment system?
  • Test on mobile
  • Update demo
You might also like...
Low code , Zero Configuration ORM that creates models, config, database and tables on the fly.
Low code , Zero Configuration ORM that creates models, config, database and tables on the fly.

🚀 ARCA ORM 🔥 Low code , Zero Configuration ORM that creates models, config, database and tables on the fly. 🔥 🇮🇳 Made in India 🇮🇳 Complete docu

Scrawler Labs 28 Dec 18, 2022
The query sorting bundle allows you to sort data from QueryBuilder and the Database
The query sorting bundle allows you to sort data from QueryBuilder and the Database

The query sorting bundle allows you to sort data from QueryBuilder and the Database. you can sort multiple columns at the same time and also you can sort relation fields with two-level deep and without any join in your query builder.

Bugloos 12 Oct 6, 2022
A simple library for managing database connections, results pagination and building queries in PHP

PHP lions-software-database-manager This is a simple library for managing database connections, results pagination and building queries in PHP. Esta é

Lions Software 0 Feb 7, 2022
The Enobrev\ORM library is a small framework of classes meant to be used for simply mapping a mysql database to PHP classes, and for creating simply SQL statements using those classes.

The Enobrev\ORM library is a small framework of classes meant to be used for simply mapping a mysql database to PHP classes, and for creating simply SQL statements using those classes.

Mark Armendariz 0 Jan 7, 2022
The lightweight PHP database framework to accelerate development
The lightweight PHP database framework to accelerate development

The lightweight PHP database framework to accelerate development Features Lightweight - Less than 100 KB, portable with only one file Easy - Extremely

Angel Lai 4.6k Dec 28, 2022
[READ ONLY] Subtree split of the Illuminate Database component (see laravel/framework)

Illuminate Database The Illuminate Database component is a full database toolkit for PHP, providing an expressive query builder, ActiveRecord style OR

The Laravel Components 2.5k Dec 27, 2022
Spot v2.x DataMapper built on top of Doctrine's Database Abstraction Layer

Spot DataMapper ORM v2.0 Spot v2.x is built on the Doctrine DBAL, and targets PHP 5.4+. The aim of Spot is to be a lightweight DataMapper alternative

Spot ORM 602 Dec 27, 2022
SQL database access through PDO.

Aura.Sql Provides an extension to the native PDO along with a profiler and connection locator. Because ExtendedPdo is an extension of the native PDO,

Aura for PHP 533 Dec 30, 2022
PHP Database Migrations for Everyone
PHP Database Migrations for Everyone

Phinx: Simple PHP Database Migrations Intro Phinx makes it ridiculously easy to manage the database migrations for your PHP app. In less than 5 minute

CakePHP 4.3k Jan 7, 2023
Comments
  • Added a tagging system

    Added a tagging system

    My code editor auto-formatted some lines, so it look like there are way more edits than there actually are. I'll send you the SQL files for the new tables! Don't really wanna just attach them here.

    opened by amethystcube 0
  • Does it require JavaScript to filter/search?

    Does it require JavaScript to filter/search?

    If it does, then a significant part of the target audience is going to refuse to use it at all until a non-JS version is at least available on demand, with a link to it on a visible place.

    I mean, the idea of this project by design appeals more to the non-JS crowd, the webring, Gemini/Gopher, "surf search" search engines etc. kind of crowd. And they are denied using a website with JS turned off.

    I am forced to go use other similar websites instead of this one, since I can't use filters with JS turned off. Please, fix it. Do you really need jQuery on such a website? Or ever? And if you want to use it, could you at least make an all-html version of the website? Preferably one that could be listed at https://nocss.club, which means that the stylying of the content is delegated to the user, as it should have been from the start and is done now in Geminispace.

    Thanks.

    opened by bzbug 0
Owner
Sadness
Sadness
GitHub
Pure PHP NoSQL database with no dependency. Flat file, JSON based document database.

Please give it a Star if you like the project ?? ❤️ SleekDB - A NoSQL Database made using PHP Full documentation: https://sleekdb.github.io/ SleekDB i

Kazi Mehedi Hasan 745 Jan 7, 2023
Connect and work with MySQL/MariaDB database through MySQLi in PHP. This is an introductory project, If you need a simple and straightforward example that takes you straight to the point, you can check out these examples.

First MySQLi PHP Connect and work with MySQL/MariaDB database through MySQLi in PHP. The above exercises are designed for students. This is an introdu

Max Base 4 Feb 22, 2022
Clean up your Magento database by removing orphaned, unused and wrongly added attribute, attribute values and settings (for M2).

Magento 2 EAV Cleaner Console Command Purpose of this project is to check for different flaws that can occur due to EAV and provide cleanup functions.

FireGento e. V. - Hackathons 41 Dec 14, 2022
A simple library to access and manipulate database records. Built on top of Dibi and hardwired for PostgreSQL.

grifart/tables A simple library to access and manipulate database records. Built on top of Dibi and hardwired for PostgreSQL. This library is develope

GRIFART 5 Nov 11, 2022
This package provides a framework-agnostic database backup manager for dumping to and restoring databases from S3, Dropbox, FTP, SFTP, and Rackspace Cloud

Database Backup Manager This package provides a framework-agnostic database backup manager for dumping to and restoring databases from S3, Dropbox, FT

Backup Manager 1.6k Dec 23, 2022
ORM layer that creates models, config and database on the fly

RedBeanPHP 5 RedBeanPHP is an easy to use ORM tool for PHP. Automatically creates tables and columns as you go No configuration, just fire and forget

Gabor de Mooij 2.2k Jan 9, 2023
A Redis based, fully automated and scalable database cache layer for Laravel

Lada Cache A Redis based, fully automated and scalable database cache layer for Laravel Contributors wanted! Have a look at the open issues and send m

Matt 501 Dec 30, 2022
A php class for managing and connecting to a database

Query builder class php This class is responsible for creating and executing sql commands and helps you to execute as easily as possible and safely. I

Mohammad Qasemi 39 Dec 11, 2022
A complete, simple and powerful database framework written in PHP

BaseSQL BaseSQL is a complete database framework written in PHP. It was built to accelerate projects development by handle database connections and qu

Willian Pinheiro 2 Sep 21, 2021
The query filter bundle allows you to filter data from QueryBuilder and the Database

The query filter bundle allows you to filter data from QueryBuilder and the Database. you can filter multiple columns at the same time and also you can filter relation fields with two-level deep and without any join in your query builder.

Milad Ghofrani 0 Apr 8, 2022