Build and scale Apps like a team of experts in a week
Hosted GraphQL backend stack (100% open-source) with all you need in one place to develop secure applications for solo-entrepreneur and small team
# Install the Agoston client
# in your frontend project:
npm i @agoston-io/client
// Create the Agoston client
// in your frontend project:
import { AgostonClient } from '@agoston-io/client'
AgostonClient({
backendUrl: ({}).AGOSTON_BACKEND_URL
}).then(agostonClient => {
if (agostonClient.isAuthenticated()) {
console.log(`Welcome user ${agostonClient.userId()} 👋!`);
}
});
-- Create your backend logic within your provided backend PostgreSQL database:
CREATE TABLE IF NOT EXISTS agoston_public.tweets
(
id bigserial primary key,
created_ts timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-- session() always returns the session data from the authenticated user:
user_id integer NOT NULL DEFAULT (session() ->> 'user_id')::int,
tweet character varying(250) NOT NULL,
-- A link with your user table:
CONSTRAINT fk_01 FOREIGN KEY (user_id) REFERENCES agoston_public.users (id)
);
// Agoston automatically exposes the CRUD methods
// around your tables to the GraphQL endpoint.
// Use the pre-configured build-in Apollo client
// to implement your own GraphQL logic.
// Create a Tweet:
const { mutate } = useMutation(gql`
mutation createTweet(
$tweet: String! = "Hello world!"
) {
createTweet(input: {tweet: {tweet: $tweet}}) {
tweet {
id
}
}
}
`)
// Agoston automatically exposes the CRUD methods
// around your tables to the GraphQL endpoint.
// Use the pre-configured build-in Apollo client
// to implement your own GraphQL logic.
// Read a Tweet:
const { result } = useQuery(gql`
query tweet(
$id: Int = 1
) {
tweet(id: $id) {
id
createdTs
user { username }
tweet
}
}
`)
// Agoston automatically exposes the CRUD methods
// around your tables to the GraphQL endpoint.
// Use the pre-configured build-in Apollo client
// to implement your own GraphQL logic.
// Update a Tweet:
const { mutate } = useMutation(gql`
mutation updateTweet(
$id: Int = 1,
$tweet: String! = "Hallo welt!"
) {
updateTweet(
input: { id: $id, patch: {tweet: $tweet} }
) {
tweet {
id
}
}
}
`)
// Agoston automatically exposes the CRUD methods
// around your tables to the GraphQL endpoint.
// Use the pre-configured build-in Apollo client
// to implement your own GraphQL logic.
// Delete a Tweet:
const { mutate } = useMutation(gql`
mutation deleteTweet(
$id: Int = 1
) {
deleteTweet(input: {id: $id}) {
tweet {
id
}
}
}
`)
// Update your frontend cache on data changes!
// For instance, update the "tweets" result
// when new tweets come:
setup() {
const { result } = useSubscription(gql`
subscription tweets(
$topic: String = "tweets"
) {
listen(topic: $topic) {
query {
tweets {
nodes {
id
createdTs
user { username }
tweet
}
}
}
}
}
`)
watch(
result,
data => {
console.log("New tweets received:", data.tweets)
}
)
}WHAT DEVELOPERS SAY ABOUT AGOSTON
FEATURES
100% open-source, hosted with ❤️
PostgreSQL
Forge your app's data model with the unparalleled power of PostgreSQL, the epitome of a solid, secure, and lightning-fast open-source relational database system. Delve into a realm of limitless possibilities, seamlessly executing both simple and complex queries and custom code with unmatched efficiency and reliability.
GraphQL
Elevate your app with the cutting-edge capabilities of GraphQL! Agoston seamlessly constructs the GraphQL server for you, complete with live rendering for instant updates. Embrace development with the latest and greatest development trend, empowering you to create like a seasoned pro!
Blazing Fast
PostgreSQL and Postgraphile unite to empower you. PostgreSQL guarantees optimal data performance, while Postgraphile transforms your GraphQL requests into a single, finely-tuned SQL query. Put to the test, Postgraphile delivers an impressive 550 requests per second for intricate queries, boasting ultra-low latency.
Authentication
Enhance your app's user experience by offering a variety of social authentication providers or a single/password option. Users are effortlessly synchronized in the database, making them instantly accessible for your app's use.
Connect any APIs
Tap into the vast possibilities of external APIs effortlessly. Whether it's GET, POST, or any other method, our native REST client package seamlessly integrates your backend with external services, enabling smooth data consumption and interaction.
Tasks and jobs
Initiate recurring database tasks to manipulate data, invoke APIs, and more. Additionally, send asynchronous tasks to enhance user experience, particularly for operations requiring extended processing time.
Shielded
Our backend and infrastructure are constantly updated to eliminate vulnerabilities, with versioning to prevent ransomware and encryption to safeguard sensitive data. You can even use your own master-generated key for database encryption, ensuring top-tier protection and peace of mind for your data.
Real-time
Unlock the unparalleled potential of real-time applications with Agoston's revolutionary built-in GraphQL subscription feature. Seamlessly synchronize data and updates instantly, guaranteeing your application remains consistently connected and at the forefront of innovation.
All in one
Agoston is your all-in-one solution, boasting a comprehensive array of essential features necessary for any application. From seamless payment collection via Stripe to effortless email sending capabilities and beyond, Agoston equips you with everything you need and more to elevate your app to new heights of success!
INTEGRATION
How easy is it to build on Agoston?
// Log your user in from // any social authentication providers // in your frontend project: agostonClient.loginOrSignUpFromProvider({ options: { redirectSuccess: '/profile', redirectError: '/login' } });// Log your user in with // username and password: var err = await agostonClient.loginOrSignUpWithUserPassword({ username: 'niolap', password: 'password' }); if (err) { console.log(`Login error: ${err}`) }